How to extract Jira tickets which spent some times (e,g 4 days ) from status changed on each items.

Question

We'd like to extracted target Jira tickets which are some retentions from status changed. We are currently using cloud free version due to evaluation. if the version of Jira is able to extract such items by JQL, please let me know. if we need to define some special setting on Jira, please also tell me such way, if the version of Jira is not available to use such extraction, please let me know what version of Jira need to us to use such extraction?

I guess we need to use timespend word in JQL, but not clear how to use it in my environment.

BR,

Masa

Trudy P Claspill · Answer

I had a typo in my suggestion which I have corrected.

It needed to be startOfDay, not startIfDay

Kit Friend · Answer

I've never spotted that one before @Trudy P Claspill

Every day's a school day

Trudy P Claspill · Answer

Hello @See Masa

Welcome to the Atlassian community.

I am not sure that I understand your requirement. Can you try explaining it in more details and provide examples of issues you would and wouldn't want included in the results?

If you want to find issues that have not had a Status change in the past N days you can use

Status NOT CHANGED AFTER startOfDay(-4)

That functionality is described here:

https://support.atlassian.com/jira-software-cloud/docs/jql-operators/