Hi, which JQL to get all issues EXEPT epics with certain Label (lets say label "A") and child issue

[Nataliia.Kasatkina]

Hi, I`m trying to get all issues EXEPT epics with certain Label (lets say label "A") and child issues of that epics, but those issues might not have this label "A". Thank you

[Mark Segall · Accepted solution]

Hi @Nataliia.Kasatkina - Unfortunately, this is not something that can be handled with native JQL.  You'll need a 3rd party app like ScriptRunner or JQL Extensions to perform a query where you're trying to retrieve children of a subset of epics.

[Nataliia.Kasatkina]

Hi @Mark Segall thank you

[Marlene Kegel - codefortynine · Accepted solution]

Hi @Nataliia.Kasatkina,

I am Marlene from codefortynine.

Another option would be Dynamic Custom Fields for Jira.

With our app you can create computed custom fields, which derive field values from existing issue data. 

For your use case you could create a custom field which displays the labels of the parent issue (e.g. the Epic). 

The Jira expression for this custom field would be the following:

issue.parent ? issue.parent.labels : (issue.epic ? issue.epic.labels : [])

 Once you've added this custom field to your issue, you could filter for "all issues EXEPT epics with certain Label and child issues of that epics, but those issues might not have this label" using JQL. 

[Nataliia.Kasatkina]

Thank you!

[mauricio.groth]

Hi @Nataliia.Kasatkina

As you're on Jira Cloud, the correct answer is to get an app that provides JQL extensions you're looking for.

With standard JQL, you can only get a list of issues and export them to Excel for further processing. This works if you want to do a one-off analysis. If your use case is more dynamic than that, look beyond standard Jira.

Standard JQL doesn't easily allow it, but you can quickly find the results using our professional indexing service JQL Search Extensions 

You can use this query to return all issues EXEPT epics with a certain Label (let’s say label "A") and child issues of that epics.

issue in epicsOfChildrenInQuery("") and labels = A OR issue in childrenOfEpicsInQuery("labels = A”)

 After this, you can save the query as s filter like this:

 

And then, run it in Jira’s JQL using:

filter!= filterName

Check out the documentation for more examples.

If you have any other questions, please contact our support. We’ll be happy to help you!
Best regards,
Maurício

[Nataliia.Kasatkina]

Thank you!