How to write the query to generate report - no of days a particular ticket is in progress?

[Dina Paul Chowdhury]

Can some one help me with the JQl query for that? I want to explore if we can create something with the age task report?

[Deleted user · Accepted solution]

Hi @Dina Paul Chowdhury , You will not be able to use native JQL functionality to bring the number of days an issue is in a specific status (In-progress). A couple of options you can start to explore are -

1. Use custom scripted field using groovy as discussed here

2. Use marketplace apps like JIRA suite utilities or Time In Status 

3. Here is another connected page for your reference

Hope this helps!

-kalyani

[Dina Paul Chowdhury]

Thanks kalyani.   Time in Status worked .