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

[Black Pen Mathematics]

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

[Bill Sheboy]

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