Table Filter macro

Juan Fuentes_e5ts3x

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 P Claspill

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/