SQL query with showing stories NOT in a specific epic

[Anita Kalmane]

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.

[Anita Kalmane · Accepted solution]

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

[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.