How to use a duration field in Issue Search

Question

I created a new ScriptRunner Script Custom field for "Days in Current Status" using the Duration Template, but when I try to use this field in my Issue Search nothing works. What is the correct format for a duration field?

Ex. Displays on Jira Issue - 1 year, 18 weeks, 6 days, 18 hours, 12 minutes

I would like to search for issues over 5 days

"Days in Current Status" ~ '>=5days'

Pavel Abdi · Answer

@SMAtlassianMber Thank you for pointing this out to me.

SMAtlassianMber · Answer

There is an outstanding Bug regarding scriptrunner and duration fields.  - https://productsupport.adaptavist.com/browse/SRJIRA-3215

Pavel Abdi · Answer

Hi everyone,

I can't get the Duration search work correctly. I set up a Script Field to calculate time in progress as described here https://scriptrunner.adaptavist.com/latest/jira/scripted-fields.html#_total_time_this_issue_has_been_in_progress.

The displayed value seems to be correct. However, when I try to search by the script field it shows incorrect results. For example, the search "Time in progress" > 2d" also showed an issue with the value "1 day, 1 hour, 56 minutes".

What am I doing wrong?