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 write a JQL query for Epics with multiple parameters?

Holly Schomann_lcpysz

Can I write a JQL query to filter for all Epics that have a status of 'To Do', AND 'In Progress' AND any epic whose status was marked as 'Done' in the past 30 days?

Is it possible to retrieve both of these groups in one JQL query?

Appreciate your help!

Accepted answers

Sreenivasaraju P

Hi @Holly Schomann ,

Yes. you can do this with JQL.

You can try with below query.

issuetype = epic and (status in ("To Do", "In Progress") or (status = Done and status changed AFTER -30d))

All comments

Sreenivasaraju P

Hi @Holly Schomann ,

Yes. you can do this with JQL.

You can try with below query.

issuetype = epic and (status in ("To Do", "In Progress") or (status = Done and status changed AFTER -30d))

Holly Schomann_lcpysz

Thank you so much for your help! This almost works. For some reason I am now getting non epic tickets if they have changed in the past month?

Sreenivasaraju P

try below query.

(issuetype = epic and status in ("To Do", "In Progress")) or (issuetype = epic and status = Done and status changed AFTER -30d)

Holly Schomann_lcpysz

This worked!!! You are a genius!! Thank you thank you!!

Holly

Welcome!

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

Quick Links

Find more posts tagged with

cloud

jira-software

jira-software-cloud