Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Compare filed between 2 filters in Jira

Kristiyan Trenov May 7, 2025

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!

4 answers

1 accepted

2 votes
Answer accepted
Bill Sheboy
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
May 7, 2025

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

0 votes
Kristiyan Trenov May 8, 2025

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.  

0 votes
Kristiyan Trenov May 7, 2025

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.

0 votes
Collista Lewingdon
Community Champion
May 7, 2025

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 May 7, 2025

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 

Suggest an answer

Log in or Sign up to answer