Help with JQL Query in Advance Release Notes

[Lindsay Kirsch]

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]

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

[Sujeet Pathak]

@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

[Lindsay Kirsch]

Unfortunately this is not working.