Build search filter using JQL

[Sutapa Basu]

I am trying to build a custom search filter in Jira using JQL.

I am trying to find all the linked items for all the work items in a given sprint.

I tried the linkedIssue filter, but seems like i am not building it right. Any suggestion how i can accomplish this task?

Thanks

[Rahul_RVS]

Hi @Sutapa Basu 

If you would be interested in a mktplace app, to visualize the hierarchy based on the issue links, we have created an add-on to track the progress at each level,

Agile Tools - Epic Tree, Links Tree and Time in Status 

Key features:

• Hierarchy upto 10 levels deep
• Progress % on "remaining estimate" or "original estimates"
• Edit Issue summary, time estimates, story points and assignee on the tree with real time updates in the progress
• Rolled up percentage completion at all levels
• Ability to add/remove the columns on the report

Disclaimer: I work for RVS, the vendor for this app, and I am one of the developers in the team

[Sutapa Basu]

Thanks for the, for Cloud Jira is this app included or it need to paid separately?

Thanks

[Ste Wright]

Hi @Sutapa Basu 

There's a native way but it's manual - or another way, but using an App.

---

Native Jira

I'd use...

issueLink in (ABC-1, ABC-2)

^ To find all Issues linked to list of Issues. It does include Epics, Sub-tasks, etc but you could limit that - for example...

issueLink in (ABC-1, ABC-2) and issuetype not in (Sub-task, Epic)

or, to limit by one link type...

issueLink[blocks] = ABC-1

You can also use the link type in the field name itself - such as...

issueBlocks = ABC-1

^ See more about how this works in the JQL Advanced Search reference

But, you'll notice I'm using the Issue Keys - not a dynamic Sprint reference. The limitation in native Jira is you cannot sub-query - so you'd need to...

• Get a list of Issue Keys for Issues in the current Sprint
• Build the JQL query manually using those Keys and the IN operator
• Modify the query each Sprint
• Add/remove Issues if Sprint scope is modified

---

Using an App

Use an App to achieve the dynamic version of this JQL - such as Scriptrunner or Enhanced Search.

Then, you could use the sub-querying features with a JQL like...

issueFunction in linkedIssuesOf("sprint in openSprints()")

or

issueFunction in linkedIssuesOf("sprint = 23")

^ To find linked issues of Issues in a specific, or currently open Sprint.

---

Let us know if either of these help resolve your need :)

Ste

[Sutapa Basu]

Thanks it does help little bit.

[Trudy Claspill]

The native "linkedIssue" function is only for

- returning the child issues of an Epic, or

- returning sub-tasks of a non-epic type of issue

Jira does not natively provide a JQL method that will allow you to retrieve all the issues based on one criteria (i.e. in a sprint) and then also get all the issues linked to that first set of issues you found.

Do you already have any third party apps on your Jira instance that extend the capabilities of issues searching? If not, are you open to paying for such an app?

[Sutapa Basu]

Thanks for the feedback. Currently I don't think we are interested in additional paid app. 

Thanks