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; } } }

JQL/Filter to search for specific issue link Types and Links

Taduri_ Kiran

By using JQL using 1) issueFunction in hasLinks("is blocked by") or 2) issueFunction in hasLinkType(Blocks) one can get the list of issues that have this link.

And in the results the column "Links" shows the issuekey that satisfy this criteria. But the shortcoming is "Links" columns also shows issuekey that does not satisfy this criteria.

Ex: Result may show ABC-123 has "Links" ABC-345, ABC-456. But only ABC-345 is the right link that satisfies the link type = Blocks. ABC-456's link type =Depends.

How to narrow downs only those Links that meet a very specific Link Type. Ex: If I search for Link Type = Blocks, I dont want to see Links that dont meet this specific Link Type.

Accepted answers

Jack Nolddor [Sweet Bananas]

Hi Taduri, Kiran,

JQL is the responsible to narrow the issue impacted by the given query.

For those issues, will show the present value within any of the configured colums.

Links columns will always shows all links within the field regardless of the query, because the query only affects to the issues showing not filder the value on their fields in wany way.

Regards

All comments

Jack Nolddor [Sweet Bananas]

Hi Taduri, Kiran,

JQL is the responsible to narrow the issue impacted by the given query.

For those issues, will show the present value within any of the configured colums.

Links columns will always shows all links within the field regardless of the query, because the query only affects to the issues showing not filder the value on their fields in wany way.

Regards

Taduri_ Kiran

@Jack Nolddor [Sweet Bananas]

I get the logic you point to. But are there any options to filter the info to view only those "Links" that meet the "Link Type" constraint?

Jack Nolddor [Sweet Bananas]

hmmm what about something like this?

Supposing issues with "is blocked by" link have some constrains like project = myproject or status != done

You can query linked issues matching the 'is blocked by' criteria using this:

issueFunction in linkedIssuesOf('project = myproject and status != done', 'is blocked by')

Regards

Taduri_ Kiran

@Jack Nolddor [Sweet Bananas]

That would only narrow down the data set but the "Links" will show all issue keys that may or may not meet the JQL Filter

Brad Quirk - Quirk Consulting

Hi Kiran,

I've been struggling with the same kind of problem, to the point where I built my own app to solve it. This app allows you to specify a JQL query, limit the number of issue link types that get returned, and even create sub-filters to isolate certain projects/fields - https://marketplace.atlassian.com/apps/1221796/dependency-mapper-for-jira?hosting=cloud&tab=overview

Kieran Tighe

This is a good question, and seems like a deficiency in querying to me, that you can't manipulate the columns in any way... It makes links information in particular difficult to use at any macro level for exact reasons you outline.

One possible alternative is the Structure plug-in if you have it - there you can group by link / link type, so you can build a tree structure showing who's dependent on whom.

Kushal Amin

Hi, are you still facing this issue ? If so, could you share what was the workaround that finally helped retrieve the right data for your query.

Werner Schott

The lack of selection in JQL is a massive deficiency. Not worthy of the QL suffix.

Anna_lpl1dr

Hi Kiran,

I am exploring possibility of having better traceability report in Jira. Will your tool allow me to build it?

We use Zephur for test purposes which has a built in Traceability report for

Requirements --> Tests --> Executions --> Defects

JQL doesn't give the flexibility of building complex queries and dumps all links in LINKS column, regardless of their type.

I need to see Epics in front of this chain with issue link types where applicable. Is it possible with your tool?

Welcome!

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

Quick Links

Find more posts tagged with

scriptrunner

issue

adaptavist

jql

atl-gruland

link