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; } } }

SQL query with showing stories NOT in a specific epic

Anita Kalmane_hd27ax

Any JIRA SQL ppl there? I need a simple query to show all stories on the board EXCEPT if they are under a particular epic (let's call it epic QA Automation). When trying 'project = RA AND "Epic Name" != "QA Automation" ORDER BY Rank ASC' , it gives me only epics as a result, not all stories under them.

Accepted answers

Anita Kalmane_hd27ax

A colleague helped me and it's now solved! For those interested, this is the query I used in the end: project = RA AND ("Epic Link" != RA-1111 or "Epic Link" is EMPTY) ORDER BY Rank ASC

All comments

Jack Brickey

I suspect you are wanting something like this…

"Epic Link" != “xxxx” and "Epic Link" is not empty

you need to find the epic link associated with the epic of interest here and replace “xxxx”. The is not empty is to ensure you exclude stories that don’t belong to any epic.

Radek Dostál

Also, let's not confuse SQL with JQL - they may be structurally similar but they have nothing to do with one another. SQL would be database queries, in general, JQL is only Jira Query Language used only by Jira and that's that - it may eventually be converted to sql somewhere down the code but they're certainly not the same thing. It's a good distinction to make - "sql" is bound to confuse people, not to be the grammar police but wanted to point that out

Jack Brickey

Agree and based on the example that @Anita Kalmane presented I assume she is looking for JQL.

Anita Kalmane_hd27ax

A colleague helped me and it's now solved! For those interested, this is the query I used in the end: project = RA AND ("Epic Link" != RA-1111 or "Epic Link" is EMPTY) ORDER BY Rank ASC

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