nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Search Issues by Epic with a certain Label

Andy Zimmermann

Hi there

Is there a way to write a a baisc jql-filter on issues that also checks a property of their epic? Or could it be done via the script-runner-plugin?

Background story: We often log work on epics of issues in the current sprint, if the work cannot directly be associated to a task. Like sprint planning etc.
But only on epics that allow the logging of work (i.e. do not contain label=logWorkNotAllowed)

So either a) start with the actual issues (showing epic-link-column in results)
Filter issues by a certain sprint (sprint=XYZ) then filter by epics which do not have the label "logWorkNotAllowed"
or b) list epics directly
Filter issues by "issueType = Epic AND labels != logWorkNotAllowed" then select only those which have a connected issue in sprint=XYZ

In Datebase-Terms we need to Join the issues with their epics, and apply filters on both.
Is that possible?

Thanks for your help!
Kind Regards Andy

Accepted answers

Jack Nolddor [Sweet Bananas]

Hi Andy,

Sadly you cannot achieve the desired search using standard features on Jira, you must go for a third-party app instead. Using i.e. JQL Booster Pack you can type the following:

a) Start with the actual issues (showing epic-link-column in results)
Filter issues by a certain sprint (sprint=XYZ) then filter by epics which do not have the label "logWorkNotAllowed"

Sprint = XYZ AND issue NOT IN issuesInEpics(' type = Epic AND labels = logWorkNotAllowed ')

>> This Will return the issues but not the Epics

b) list epics directly
Filter issues by "issueType = Epic AND labels != logWorkNotAllowed" then select only those which have a connected issue in sprint=XYZ

type = Epic AND (labels != logWorkNotAllowed OR labels IS EMPTY) AND issue IN epicsOf(' Sprint = XYZ ')

>> This will return the Epics but not related issues

You can easyly save above queries as filters, give them a meaningful name, and then combine both results by tying:

filter = "You named filter for Epics" OR filter = "You named filter for issues"

(*) Note that this is just an exaple, you must tune above queries to fit your needs

Using this app you can also query other issues relations, check:

References:

Official documentation

Hope this helps you to create awesome queries

Kind regards

All comments

Vikrant Yadav

@Andy Zimmermann i think you are using wrong label field , try to "labels" instead of label

try this :- issuetype = Epic AND labels != CoreApp

Andy Zimmermann

oh thats actually just a typo. Fixed it. thanks for the catch!

but the main issue still stands

Vikrant Yadav

@Andy Zimmermann You can create Sprint custom field and filter issues via JQL.

Andy Zimmermann

I don't understand how that would help.

What I need, is this kind of issue filter query:
"sprint = XYZ AND labelsOfEpic != logWorkNotAllowed"But ofc there is no such thing as "labelsOfEpic", or is there a way to filter by the issues associated epic properties additonally to filtering the issue property (sprint)?

Or alternativly: the epic-filter
"issueType = Epic AND labels != logWorkNotAllowed AND issuesConnectedToEpicHaveSprint = XYZ", where again I could not find any way to query the associated issues of an epic (i.e. the fake label: issuesConnectedToEpicHaveSprint )

Jack Nolddor [Sweet Bananas]

Hi Andy,

Sadly you cannot achieve the desired search using standard features on Jira, you must go for a third-party app instead. Using i.e. JQL Booster Pack you can type the following:

a) Start with the actual issues (showing epic-link-column in results)
Filter issues by a certain sprint (sprint=XYZ) then filter by epics which do not have the label "logWorkNotAllowed"

Sprint = XYZ AND issue NOT IN issuesInEpics(' type = Epic AND labels = logWorkNotAllowed ')

>> This Will return the issues but not the Epics

b) list epics directly
Filter issues by "issueType = Epic AND labels != logWorkNotAllowed" then select only those which have a connected issue in sprint=XYZ

type = Epic AND (labels != logWorkNotAllowed OR labels IS EMPTY) AND issue IN epicsOf(' Sprint = XYZ ')

>> This will return the Epics but not related issues

You can easyly save above queries as filters, give them a meaningful name, and then combine both results by tying:

filter = "You named filter for Epics" OR filter = "You named filter for issues"

(*) Note that this is just an exaple, you must tune above queries to fit your needs

Using this app you can also query other issues relations, check:

References:

Official documentation

Hope this helps you to create awesome queries

Kind regards

Andy Zimmermann

Thats exactly the information I needed
I'll check it out!

Thank you very much

Jack Nolddor [Sweet Bananas]

You're welcome

Björn Eriksson_2ezm1m

Hi
Is this possible to achieve with ScriptRunner?

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

issue

filter

atl-gruland

issue-link

epic

label

epic-link