JQL for all Open, In-Progress, backlog and closed in the last 10d= days to an EPIC?

Joyce Wright_3myyoy

I have this filter

 

project = XXXX AND issuetype in (standardIssueTypes(), subTaskIssueTypes()) AND status in (Open, "In Progress", Backlog) AND "Epic Link" = XXXX-34638 AND resolved <= -10d ORDER BY resolved ASC

This obviously returns all issues resolved in the last 10 day for the XXXX project

 

How do I build a filter to just show all issues linked to XXXX-34638 that are in Open, Backlog, In-Progress or closed in the last 10 day?

Bill Sheboy

Hi @Joyce Wright -- Welcome to the Atlassian Community!

Your last sentence describes the query well, and the key is to separate the parts: first check the things which are true for all issues, and then join together with OR the parts which vary.  For example:

this AND that AND anotherThing AND ( sometimesThis OR sometimesThat )

For your query that could be this:

project = XXXX
 AND issuetype IN (standardIssueTypes(), subTaskIssueTypes())
 AND "Epic Link" = XXXX-34638
 AND ( status IN (Open, "In Progress", Backlog) OR resolved >= -10d )
 ORDER BY resolved ASC

Please note the parentheses which help the query match the evaluation order you want.

To learn more about creating such queries, please see this free training from Atlassian:

• https://university.atlassian.com/student/activity/1225443-intro-to-jql-in-jira-software-course-description
• https://university.atlassian.com/student/path/849533-gain-project-insights-through-jql

Kind regards,
Bill