How can I display all tickets from the previous week whose status was not changed?

[Ian _I_ - Aware]

Hello Everyone .

I want to display a list of tickets created in the last week and then compare those same tickets again with the current week and list those whose status was not changed and were not updated.

How can I do this please?

I have this JQL, but I am not sure how to compare the update status with the current week.

project = "XXYYCC" AND issuetype = "Production Bug" AND created >= 2022-02-07 AND created <= 2022-02-13 AND status != Closed AND status != Resolved AND statusCategoryChangedDate >= 2022-02-14 AND statusCategoryChangedDate >= 2022-02-20

Many thanks.

[Pramodh M · Accepted solution]

@Ian _I_ - Aware 

Use

Not status changed after startOfWeek("-1")

Let me know if you have any queries

Thanks

[Ian _I_ - Aware]

Thank you very much @Pramodh M 

So, now my query looks like this:

project = "XXYXXCC" AND issuetype = "Production Bug" AND created >= 2022-02-07 AND created <= 2022-02-13 AND status != Closed AND status != Resolved AND Not status changed after startOfWeek("-1")

When I run it I get several tickets, but the creation date and the updated data are like this:

Created 9/2/22 Updated 9/2/22
Created 8/2/22 Updated 9/2/22

Surely I should see tickets where the creation date is less than the updated data?  Or am I missing something?

[Pramodh M]

It's correct hover over the created date or updated date to see the expect time in the issue view

You could use the startOfWeek("-1") for created field as well to search the issues instead of entering the date manually

And use resolution = Unresolved to return only unresolved issues if you have practice of setting the resolution field

[Ian _I_ - Aware]

Forgive my ignorance @Pramodh M  but if one of the tickets in the results is created on 09/02/2022 17:27 and updated on 09/02/2022 18:11 why does it appear?  Is it because even though there was an update the status didn't change

Is there no way to have the updated column along with another column for when the status was last updated too?

[Pramodh M]

Status may not be changed but the other field values may have changed right?

Status update is tracked in history

And updated  tracks the field value updates as well along any changes to issues!

Let me know if you have any queries

[Ian _I_ - Aware]

That makes sense. Is there no way to track status changes (date/time) separately?

Many thanks for your kind help.

[Mithil]

project = XXX AND created >= startOfWeek(-1) AND created <= endOfWeek(-1)