Advanced JQL Query for Issues in a Workflow State for More Than 3 Business Days in JIRA

[Trupti Gaikwad]

Advanced JQL Query for Issues in a Workflow State for More Than 3 Business Days in JIRA or any plugin available for this?

[Jobin Kuruvilla [Adaptavist]]

Try the same trick in this answer. Instead of 30 days, use 3 days in the first filter.

[Jenin CM]

Cool..this seems to be a good solution! Tx Jobin

[Trupti Gaikwad]

Thanks..this one is good..

[Jenin CM]

Hi Trupti,

Can you please give a try for scripted jql functions? I didn't had a chance to look through it but I believe it could help you if u invest some time on it:

https://jamieechlin.atlassian.net/wiki/display/GRV/Scripted+JQL+Functions#ScriptedJQLFunctions-AggregateExpressions

Regards

Jenin