Jira filter based on comparison of two properties

Question

Hello Atlassian Community,

I'm currently trying to set up a filter for a Jira project but can't seem to get it to work like I want it to.

I have Issues with a 'Location' and an 'Owner' property and would like to filter those Issues in a way that only shows Issues where 'Location' and 'Owner' don't have the same value.

Is there a way to do this without the need of installing any Plugins?

BR,
Alexander

Alexander Schrett · Answer

Thanks for the fast reply, I'll have to find a workaround then.

BR,

Alex

Warren_mz9b4z · Answer

Hi Alexander

I don't believe so. I'm assuming the Owner and Location are custom fields and that they're set up as text - if so, JQL is unable to query text-based custom fields for specific values and hence can't compare to each other either.

So you could use Location is EMPTY or Location ~ "something" but you can't use Location = "a specific value" and definitely can't do Location = Owner

I hope this helps you