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!
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:
Kind regards,
Bill
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.