Compare filed between 2 filters in Jira

[Kristiyan Trenov]

Hey guys, i am a newbie in jql and trying to compare fixVersion field between 2 filter i made. First filters containing Initiative tickets and the second contains Epics. The goal is to have a filter results with the tickets that are not matching fixVersion field. I spent few hours and i am nowhere, please bring fresh ideas. Thanks a lot!

[Bill Sheboy · Accepted solution]

Hi @Kristiyan Trenov -- Welcome to the Atlassian Community!

Jira Query Language (JQL) is not a SQL, and so does not have many of the features of a SQL...such as joins between result sets on the field values.

How frequently do you need this type of query as that will determine possible workarounds:

• Need this one time
  • Export the results of both queries to a spreadsheet and perform the comparison in that tool
• Need this often
  • Investigate Atlassian Marketplace apps which extend the features of JQL, perhaps adding this feature
  • Regularly export all of your data a reporting database which does support SQL, and its features

Kind regards,
Bill

[Kristiyan Trenov]

Hey guys. so i think im getting close with this query filter = REIN_INITIATIVE_CHILD_OF AND fixVersion in versionMatch("^2025*") OR filter = REIN_EPICS_CHILD_OF AND fixVersion in versionMatch("^2025*")

currently im getting the results of the tickets that contain fixVersion and their Parent link. Indeed most parents link don't contain fixversion , but i was wondering what i need to change in order to present only the parents that are not matching the child fix version? confused? :D 

The goal is to find the Parent tickets that have different value in FixVersion field. The filters i use is all the epics and initiatives which have parent tickets above them.  

[Kristiyan Trenov]

the goal is to compare the fixVersion field between Child issues ( Initiative > Epics ) i want to be able to find the tickets that have miss match.

[Collista Lewingdon]

It is very helpful if you include screenshots that show what you have already tried and we can generally help you edit and try new formulations. 

[Kristiyan Trenov]

Hey , thanks for the fast reply ,im not sure what will be helpful as i am all over the place and trying many different ways. For now i have created the needed filters and decided is the way to go , to compare the results from the 2 filters in one query ? :X