Forums

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

Create issue (filter) to extract issues by comparing two issue types

Black Pen Mathematics
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
May 28, 2021

In my project subtasks, we have 3 values 

  1. Story Points
  2. Story Points 1
  3. Revised Estimate

I want to create a filter in Jira to extract the subtasks where the 'Revised Estimate' value is higher than 'Story Points' and 'Story Points 1' both

 

Please help

 

 

1 answer

0 votes
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 28, 2021

Hi @Black Pen Mathematics  -- Welcome to the Atlassian Community!

Jira's JQL is not a SQL, and so you cannot easily compare different fields with out of the box Jira.  There are purchasable marketplace add-ons to support this.

How often do you need this information?

  • If just once, I recommend exporting the issues you care about and performing the check in a spreadsheet
  • If you need this often, consider purchasing a marketplace addon, or..
  • Create an automation rule to do this, perhaps adding a label or custom field when the condition exists.  You could then use a standard JQL query to find the issues.

Best regards,

Bill

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events