Filter out the list of issue moved to a particular status after a DueDate

[Vikrant Yadav]

Hi Guys,

Need your help in JQL to find the list of issue what are moved to a Status B after DueDate. or issue changed to a status B after DueDate crossed. 

Kindly suggest

[Bill Sheboy · Accepted solution]

Hi @Vikrant Yadav 

That is not possible with the built-in features of JQL as it cannot compare issues fields; it can only compare fields to a specific (or relative) value.

Possible workarounds include:

• hardcode the Due Date values in your JQL to perform such queries; this will potentially require many queries or query clauses
• investigate marketplace apps / addons which perform this type of reporting or can query the issue history better than JQL
• export the issues and their histories to another tool to allow such reporting

Kind regards,
Bill

[Vikrant Yadav]

Thanks, @Bill Sheboy  Yeah without plugin it's feasible. Via Scriptrunner Enhance search we can compare two fields, I think. 

[Petru Simion _Simitech Ltd__]

@Vikrant Yadav 

If you are using cloud and you are open to use apps, you can use CIFJ - Issue History For Jira, an app recently released by our company.

You can set the Updated Field = Status and Date Updated greater than your desired date.

You can even add a certain value for the Value To in case you only want to filter for those issues transitioned in a specific status.

[Vikrant Yadav]

@Petru Simion _Simitech Ltd__  I this we can't compare with Due Date field. 
Like Status changed after DueDate