How to JQL a list of tasks that are linked to a feature that has a specific tag?

Question

Hi,

I have a list of features, and in each of the features, i have linked tasks that will deliver that feature.

I have labelled each of these features with a tag "x".

Is it possible to write a JQL that get all the list of tasks which will deliver feature that has the "x" tag?

Many thanks!

Zoryana Bohutska _SaaSJet_ · Answer

Hi @fmak

Also, you can try the app created by my team - Dynamic Filter: JQL Replacer.

It lets you filter the issue list without JQL knowledge. In your case, you can create make such configurations like in this screenshot.

If you need more information, place let me know.

Regards

Zoryana

Olga Videc · Answer

Hello @fmak

First, everything that Bill wrote is correct, you can't achieve this out of the box you need an add-on from the marketplace.

There are many choices, commonly used Adaptavist ScriptRunner.

Here is JQL for Scriptrunner

issueFunction in linkedIssuesOf("issuetype = task and labels in ( 'label_1', 'label_2')" )

You can change the issue type to whatever you want or you can use a different condition you can use project instead of issue type, whatever you want.

BR, Olga

Bill Sheboy · Answer

Hi @fmak -- Welcome to the Atlassian Community!

Unfortunately you cannot perform that query with out of the box Jira Cloud.  Your options to solve this depend upon how frequently you need this solved:

* Need this often: consider purchasing a JQL add-on from the marketplace to enhance searches
* Need this infrequently...

a) Run one query to get all of your epics with that tag/label

project = myProject
 AND issueType = Epic
 AND Labels = "X"

b) Export the list of issues, and grab just the keys to produce a list like this: (EPIC-1, EPIC-2, EPIC-3, ...)

c) Run another query to get the tasks for those epics

project = myProject
 AND issueType = task
 AND "Epic Link" IN (EPIC-1, EPIC-2, EPIC-3, ...)

Best regards,

Bill