Help with JQL Query in Advance Release Notes

Question

Hello -

I am trying create a query to:

- A specific project

- Stories

- System Impacted (custom field)

- Status: closed in the last 7 days

Everything is pulling up perfectly, except for the Status. It works if I use Status = Open, but no other options (and I have stories in statuses of In Progress, Ready to Work, In Review and Closed).

Here is my query that works:

project = MOP AND status = Open AND issuetype = Story AND "System Impacted" = Jira

What do I need to modify?

Jens Schumacher - Released_so · Answer

Hi @Lindsay Kirsch, the following query should work. Not that this might not work with JPD project, as they do not set a resolution when an issue is completed.

project = MOP 
AND status = Open 
AND issuetype = Story 
AND "System Impacted" = Jira
AND resolutiondate >= -7d

Lindsay Kirsch · Answer

Unfortunately this is not working.

Sujeet Pathak - Amoeboids · Answer

@Lindsay Kirsch assuming 'Closed' is the terminal status, you may try a JQL like this

"project = MOP AND AND issuetype = Story AND "System Impacted" = Jira AND resolved >= -7d"

Hope this helps. Let me know if this works for you.

Best,
Sujeet