nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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!

Accepted answers

Bill Sheboy

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

All comments

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

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.

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

Bill Sheboy

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?

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.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

unknown-hosting-type

jira-unknown-hosting-type