Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Need help filtering by a field that is present in two different issue types

mark zermeno May 28, 2024

Hello,

I have the field 'Priority Level' in the issue types 'Requirement' and 'Feature' in my JIRA project. What i would like to do is compare the values of 'Priority Level' in both issue types.

For instance, if the 'Priority Level' in the 'Requirement' is different from the 'Priority Level' in the 'Feature' i would like to see only those issues.

 

 

2 answers

0 votes
John Funk
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
May 30, 2024

Hi Mark,

Do those fields have the exact same options for them? Are the options named exactly the same? 

0 votes
Tankem Williams
Contributor
May 28, 2024

Hello Mark,
Thank you for your request through the community. A comparison of this nature is not possible because JQL itself does not support direct comparison between fields of different issue types within a single query. However, there is a possible workaround,

  1. Export 'Requirement' issues with their 'Priority Level' to a CSV file with the JQL
    issuetype = Requirement AND "Priority Level" is not EMPTY
  2. Export 'Requirement' issues with their 'Priority Level' to a CSV file with the JQL
    issuetype = Feature AND "Priority Level" is not EMPTY
  3. Now with both issues on the same Excel sheet, you can add a filter to pull out those Priority levels that are different from both issue types.

I hope this helps.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
FREE
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Atlassian Community Events