nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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.

Accepted answers

Pramodh M

@Ian _I_ - Aware

Use

Not status changed after startOfWeek("-1")

Let me know if you have any queries

Thanks

All comments

Pramodh M

@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?

Mithil_hklwzb

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud