Automation for Jira - endWith only matching with Yes and No

Malka_5pfb6p

So I am doing a defect matrix and here are some of the things I am trying to check. The ones that check for yes or no are passing, the ones with any other word come back as expecting three elements, but only finding two.

{{#=}}IF({{issue.Application Workflow is Functional?.value.endsWith("No")}},30,0)+ IF({{issue.Does this Involve Data Corruption?.value.endsWith("No")}},0,50) + IF ({{issue.Performance or Speed Related?.value.endsWith("Yes")}},10,0) + IF ({{issue.Compliance Issue?.value.endsWith("Yes")}},30,0) + IF({{issue.Is this a Patient Care Issue?.endsWith("Maybe")}},15,0) + IF({{issue.Is this a Patient Care Issue?.value.endsWith("Yes")}},30,0) + IF({{issue.Impact to Financial?.endsWith("Direct")}},30,0) + IF({{Impact to Financial?.endsWith("Indirect")}},20,0)+ IF({{Impact to Financial?.endsWith("None")}},0,0)+ IF({{issue.Data Not Displaying or Displaying Incorrectly?.value.endsWith("Yes")}},15,0) + IF({{issue.Visual Artifact.value.endsWith("Yes")}},5,0) {{/}}

Bill Sheboy

Hi @Malka 

Were you able to figure this one out?  I did some checking and I noticed:

• The function endsWith does not handle empty values or mismatches well.  I got around that by using the default value to support the IF test.  For example,

IF({{somefield.endsWith("Hello")|false}}, 10, 20)

• In your formula, some things include the issue. reference and others do not.  That should not matter, but who knows.  Same thing for the use of .value

 

Best regards,

Bill