Table Filter macro

[Juan Fuentes]

I am trying to create a filter for Jira issues that filter by a specific Epic.  So in my project I have 10 Epics but for a specific status I only want to show 1 Epic and all its task under it.  I can get the specific Epic to show but none of the task.  Any ideas

I tried the following

project = AVOB AND issuetype = Epic AND epicLink = (AccountRating)

project = AVOB AND issuetype = Epic AND epicLink = accountRating

project = AVOB AND issuetype = Epic AND epiclink = accountRating

project = AVOB AND issuetype = Epic AND epic = accountRating

[Trudy Claspill · Accepted solution]

Hello @Juan Fuentes 

Your syntax is incorrect. 

If you want the results to show the Epic and
its child issues, and
"AccountRating" is the name of the Epic, and
the issues are in a Company Managed project in Jira...

then the syntax you need is this:

project=AVOB and ((issuetype=Epic and "Epic Name"="AccountRating") or ("Epic Link" = "AccountRating"))

(issuetype=Epic and "Epic Name"="AccountRating") gets you the Epic named "AccountRating".

("Epic Link" = "AccountRating") gets you the child issues of that Epic.

Combining those two statements with an OR gets you both sets of issues.

project=AVOB limits the returned results to only issues in the AVOB project.

For more information on JQL options refer to this documentation.

https://support.atlassian.com/jira-software-cloud/docs/use-advanced-search-with-jira-query-language-jql/

[Juan Fuentes]

Thank you for the help.  I tried it and it did not work .  But I did get further   I now get no search results found.  I confirmed the Epic Link

[Trudy Claspill]

It appears that your Epic Link/Epic Name is "Account Rating" with a space. If you put it in the query without a space, that would explain why no results are found.

After fixing that if you still get no results then please show us the actual filter you are trying to use.

[Juan Fuentes]

I cant believe over a space i had an issue.  I had assumed I had to eliminate the space when referencing the table.  I was wrong thank you it worked

[Trudy Claspill]

Glad I could help!

If your problem has been solved, please consider marking the Answer as Accepted to help other users find posts with validated solutions.