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

[See Masa]

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 Claspill]

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/

[Kit Friend]

I've never spotted that one before @Trudy Claspill

Every day's a school day

[Trudy Claspill]

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

It needed to be startOfDay, not startIfDay