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

Question

In my project subtasks, we have 3 values

* Story Points
* Story Points 1
* 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 · Answer

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