I have two custom fields that are type Select List (single choice):
Both custom fields have the same options available for selection
I would like to run a query where I can return a list when Health (This Week) = Health (Last Week). I would also like to be able to run the inverse query, where Health (This Week) != Health (Last Week).
I have tried:
issueFunction in issueFieldMatch("", "customfield_21108", customfield_21107)
but I don't get any results (even though I should). I think the third argument isn't being resolved?
I've also tried:
issueFunction in expression("", "customfield_21108 = customfield_21107")
but I don't get the results I expect. Interestingly I get the same results with "=" or "!="
I don't think those work with select list custom fields, but only with number and dates, which support comparison.
You could create a script to loop over each issue in a given JQL search ( like cf is not empty and cf is not empty ).
The script should return the issuekey for each issue where the cfs have the same value.
If you don't want to create a script for that, you could simply use the JQL below, since there aren't maby values to compare:
(cf = "Not Started" AND cf = "Not Started" ) OR (cf = "On Track" AND cf = "On Track" ) OR (cf = "Off Track" AND cf = "Off Track" ) OR (cf = "Done AND cf = "Done" )
To see where they are not the same, save the above JQL in a filter and create another one like:
cf is not empty and cf is not empty AND filter != 1234
Replace 1234 with the ID of the filter you saved. It should return all issues where the cfs are not empty and not equal.
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events