Unable to get results for EMPTY Epic user stories/ tasks/ bugs

[alice hwang]

I am trying to bulk change a number of user stories, tasks, bugs that have no Epics linked to them. The source of truth would be my current Jira board, filtered on 'Issues with no Epic' within the Epic filter which = 91 items total. When I try to get the same results via Advanced Search option, I am getting a total of ~266 items. 

Here is the JQL: project = FHIR AND status = "To Do" AND "Epic Name" is EMPTY
 AND Sprint is EMPTY AND type in (Story, Task, Bug)

When I spot checked 1 of the results from the JQL, I noticed that the Epic Name and Epic Link are blank for one of my user stories when they are apart of an Epic so not sure what I am doing wrong

[Trudy Claspill · Accepted solution]

Hello @alice hwang 

Welcome to the Atlassian community!

Are you working with issues in a Company Managed project or a Team Managed project? That information will show at the bottom of the navigation panel on the left when you are viewing the project.

In either case "Epic Name" is not the right field to use in your JQL.

For a Company Managed project the field you should use is "Epic Link".

For a Team Managed project the field you should use is Parent.

[Trudy Claspill]

Hello @alice hwang 

Were you able to solve your issue with the Answer I provided? If so, please consider marking the Answer as Accepted to help other users find posts with validated solutions.

If you are still having an issue, please let us know so we can try to help you solve it.