How to filter issues on the Assignee being equal to "Acceptance Tester" field?

[Shady Makar]

Hi,

How can we filter on tickets that have the same assignee as the Acceptance Tester field? (its a field we created that can take users..just like assignee)

Thanks,

Shady

[Jack Brickey · Accepted solution]

Hi @Shady Makar ,

Native JQL will not perform field compares. There are a couple of options you could consider here. You could elect to add an add on application such as scriptrunner or similar or you might consider using automation. The idea with automation would be to create a custom field an update that field anytime the assignee matches your acceptance tester field. Basically you trigger on either one of those fields changing and then compare the two. If they are the same then your new custom field could be set to true. Then using JQ well you could look for all issues where your custom field is True. A bit of a hack but it is an option.

[Bill Sheboy]

Hi @Shady Makar 

Yes, and...to Jack's answer:

How often do you need to do this and for how many issues?  When infrequently, you could export the issues to a spreadsheet and perform the comparison there.

Kind regards,
Bill

[Shady Makar]

Like at the end of the sprint, i wanted to evaluate that, but the more automated approach the better. I already built the automation to edit the labels and then I just have a dashboard that filters on that label.

Thanks @Jack Brickey and @Bill Sheboy