Add a formula attribute to the if helper

[githubbob42]

Mingle Card: 6232
Narrative

If and filter are cumbersome to use.  Lets make it so users can just put in the formula they want to use.

Acceptance Criteria

{{#if  formula=””}}{{/if}}   should evaluate what is in expr.

These helpers with can only use the old method or the formula but not both.

Analysis

Related Stories

Tasks

{{ table query: SELECT Number, Name, Owner, 'Task Status' WHERE Type = Task and Story = THIS CARD ORDER BY Status }}

Defects

{{ table query: SELECT Number, Name, Owner, 'Status' WHERE Type = Defect and 'Related Story' = THIS CARD }}

Impact Analysis

Developers: Fill in this section during code review.

Test Plan

Use the attached template below

Test Result: Pass
 

Mobile PR: 2716

User: [email protected]   /  lastpass

Hardware: Dell XPS PC, IPAD Pro.

OS: Windows 10 & IOS 11

Browser: Chrome & Safari 

 
https://dev.fieldfx.com/
 

Test Cases:

https://lfw.testrail.io/index.php?/cases/view/6951

https://lfw.testrail.io/index.php?/cases/view/6953

https://lfw.testrail.io/index.php?/cases/view/6952

Test Notes:

I was able to verify that the {{#if  formula=””}}{{/if}}  works using the attached templated.

-

-
{{#each FX5__Ticket_Items__r}} 
{{#if formula="RecordType.DeveloperName == 'Labor'"}}Labor{{else}}NotLabor{{/if}}
{{/each}} 

I was able to create a report using the template and sync to back office 

!clip-06dd-e6fa.png!{height: 485px; width: 950px;}

[githubbob42]

Feature: #5861 Report Template Usability Improvements (Mingle)

[githubbob42]

Pull Request #3103