Query results returning epics and not stories

[jlcbeck]

Am trying to run a query that shows me all of the user stories/tasks that are not assigned to an epic within a project. The below query only returned epics.

"Epic Name" is not EMPTY AND project = Pipelines

[Nic Brough -Adaptavist- · Accepted solution]

Ah, yes, this one is delightfully confusing.

Epic Name is a sentence that goes on an Epic.  It's only ever put on the Epics.

Epic Link is the link from a Story (or other issue) to the Epic with the name.

So, your query returns Epics because it's looking for data in a field that is only ever on Epics.  Try looking at the link instead:

"Epic Link" is not EMPTY AND project = Pipelines

[jlcbeck]

Many thanks for the quick response!

[Mikael Sandberg · Accepted solution]

Welcome to the Atlassian Community!

Use "Epic Link" instead of "Epic Name". The Epic Name is the short name for the epic, Epic Link is the relational link to determine an issue's parent epic.

[jlcbeck]

Thanks for the quick response!