Issues in same status for more than 2 weeks but less than a month

[LUIS MIGUEL DAZA MENDOZA]

Hi I want to create a filter to find issues in the same X status for more than 2 weeks but less than a month.
Is this possible with JQL?

[Bill Sheboy]

Hi @LUIS MIGUEL DAZA MENDOZA -- Welcome to the Atlassian Community!

Short answer: it is not possible to check that for any, non-specific timeframe using the built-in JQL.  You could investigate marketplace addons / app to help with such queries.

Using the JQL CHANGED operator, one could check within a specific timeframe, such as this:

project = myProject
 AND NOT status CHANGED AFTER -30d
 ORDER BY updated ASC

This would find the issues where the status did not change in the last 30 days.  But note the dates are specific (or relative to "now") and must be adjusted.  The expression also does not provide the duration of "no status change".

To measure and query the duration of time in a status, one would need tools to gather that duration from the issue history which also allow querying the duration.

Kind regards,
Bill

[Vitalii_Bobak_SaaSJet]

Hi @LUIS MIGUEL DAZA MENDOZA 

JQL by itself doesn't support date calculations for time spent in a status. However, you can create a filter for issues that have been in a status for a specific duration using custom fields or apps that extend Jira’s reporting capabilities.

For your requirement—finding issues in a specific status for more than 2 weeks but less than a month—consider using an add-on like Time in Status. This tool lets you set up detailed filters and reports to see how long each issue has stayed in a status and even export the data if needed.

 For this just:

1. Choose Time in Status report and sort by project (assignee, sprint, any JQL etc)
2. Filter Issues by preferred time
3. Get your report!

You can also book a live demo - we'll show you the application inside out and answer all your questions. 

Add-on developed by my team. 

Have a nice day 🥳

[Madhu_RVS]

Hi @LUIS MIGUEL DAZA MENDOZA 

Welcome to the community !!

As suggested by Bill, a mktplace app can help here. f you would be interested in the same, please try out an add-on we have developed for the same use case.

Time in Status Reports 

The app has more than 20+ reports to meet a variety of use cases. For you requirement, the report below can help track the issues which are in particular status for more than a specified time easily. You can add multiple conditions to narrow down your result set.

More details here

Disclaimer : I work for the vendor who built this app

[Christian]

Hi Luis

This JQL will find that for what meets that criteria currently for status "closed":

status changed to closed after -2w before -1m

If you want to find all historical issues that were in a particular status for that amount of time, I do not believe there is a way to do that in standard Jira. You could set up some automations that could track that for you moving forward, or use an app like script runner to find that find that information.

I hope that helps and let me know if you have any other questions.

Christian

[Gizem Gökçe _OBSS_]

Hello @LUIS MIGUEL DAZA MENDOZA ,

Welcome to the community!

You can use JQL to find issues that have been in the same status for a specific time range, such as more than 2 weeks but less than a month. Here’s how you can do it:

JQL Query: To find issues that have been in the status "X" for more than 2 weeks but less than a month, you can use:

status = "X" AND statusChangedDate <= -14d AND statusChangedDate >= -30d

This query only works if the issue hasn’t transitioned out of status "X" within the specified time frame. Jira doesn’t natively track cumulative time spent in a status.

Alternative Solution:
If you need more flexibility, such as tracking the cumulative time spent in a status across transitions, you can use Timepiece - Time in Status for Jira, the oldest and leading 'Time in Status' app in the Atlassian Marketplace, which is developed by my team at OBSS.

With Timepiece, you can:

• Generate a Status Duration Report to see how long each ticket has spent in specific statuses, even if it transitioned multiple times.
• Filter issues that match your criteria

Timepiece is available for both Jira Cloud and Data Center. Let me know if you’d like more information or assistance with your reporting needs! If you wish, you can also schedule a live demo. We will provide a comprehensive overview of the application and address any inquiries you may have.

Best regards,
Gizem

[Hannes Obweger - JXL for Jira]

Hi @LUIS MIGUEL DAZA MENDOZA

welcome to the community!

Just to add to @Bill Sheboy's great answer:

For more advanced use cases, this is an area where many customers rely on apps from the Atlassian Marketplace. E.g., you may want to have a look at the app that my team and I are working on, JXL for Jira.

JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also comes with a long list of so-called history columns that aren’t natively available, including date of/time since transition to [status], time in [status], and many more. 

This is how it looks in action:

As you can see above, you can easily sort and filter by your history columns, and also use them across JXL's advanced features, such as support for (configurable) issue hierarchies, issue grouping by any issue field(s), sum-ups, or conditional formatting.

Of course, you can also export your data to XSLX (Excel or Google Sheets) or CSV in just two clicks.

Any questions just let me know,

Best,

Hannes

[Petru Simion _Simitech Ltd__]

You can use the app recently released by our company CIFJ - Issue History for Jira

https://marketplace.atlassian.com/apps/1235591/cifj-issue-history-dashboard?hosting=cloud&tab=overview

You can search, filter by issue change date to be between the dates you mentioned and you will get the list of issues matching your search criteria.

You can also export the search result to CSV for further investigation or storage.