Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

How to query duration searcher field?

Charlie Misonne Community Leader Mar 20, 2020

I'v got a scripted field using ScriptRunner. The script outputs a Long value with ScripRunner useing the Duration template.

The custom field also uses the Duration searcher.

The values in the issues are fine. But querying them with JQL does not work as excpected.

Example:

The field shows this value on an issue: 1 day, 11 hours, 5 minutes

When I search for: myField < 2d the issue is not in the results.

Is it possible to use a duration field in JQL? Or should I use a date field instead?

 

1 answer

@Charlie Misonne I'm currently having the same issues. Did you figure it out :)?

Charlie Misonne Community Leader Apr 28, 2020

Hello

No I didn't. I chose to use a date field instead.
I don't think we can query duration field but I'm not 100% sure. If you really need it try asking via a vendor support ticket.

Thank you for the answer :)

It kind of sucks that the official documentation shows examples that do not work.

I'm curious too. I'm trying to use the scripted field for "Total time this issue has been In Progress". Are you able to export the data to a CSV containing the custom "Duration" field? 

Thanks
Dawn




Also, I see this note on the scriptrunner docs page. "Use the Duration Searcher. For the template choose Duration." Any idea what this means? 

Did you also assign a search term to the field? I found this in their docs.  

(Optional) Enter a Search Term if you want to use Scripted Fields when searching for issues with JQL. There are several conditions that must be met for Search Terms, including: they must be unique, case sensitive, and contain no whitespace. Existing search terms/Jira custom field names cannot be used.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
SERVER
VERSION
7.12.3
TAGS
Community showcase
Published in Apps & Integrations

🍻🍂Apptoberfest Update: Upcoming Virtual Events 🎉

Hello Community! I hope you've been enjoying the 🍂Apptoberfestivities🍂 (I know I have!) The event is heating up next week with a series of virtual events that we're calling the 🍻🍂Partner App ...

723 views 7 24
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you