Create Filter for Cards in Progress Longer than Estimated

[Scott Gray]

Hello,

I've created a filter to tell me when a card has been 'in-progress' longer than 4 days. This helps me as a PM see what might need a nudge or or whatnot. The issue I'm having is that while this filter works great for 70% of our cards, we do have ones where the estimated story point value is greater than 4 so it should be in 'in-progress' for more than 4 days. 

Is there a way to setup the filter so it shows cards that:

status = "In Progress" AND NOT status changed after X

Where X is the estimated story point value? Or something like Time in in-progress - estimated story point value is > 2?

~Scott

[Mohamed Adel]

Hi @Scott Gray 

Unfortunately, this can't be achieved with out-of-box JQL in JIRA. 

I would recommend to have search for custom JQL function option using Scriptrunner 

you can do something like that inside the script  :

• Get all the issue with status = " Status"
• get the issue histories (where String = 'Status')
• search for the creation date for specific status change "from" --- "to" 
• compare the creation date with current date - (estimated story point)

To be frank it is a bit complex solution. 

Thanks,

Mohamed Adel