Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root


1 badge earned


Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!


Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.


Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!


Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

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


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.

5 answers

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.

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

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.

0 votes

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 -

0 votes

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.


@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?

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')


Like # people like this

@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

Provided JQL should display linked issues which appeared before on "Links" columns, filtered by the given link criteria. However if you check the "Links" colums for these issues will display all links regardless of the given criteria since as I said before there is no way to filder colum data using JQL only matches issues.

@Jack Nolddor _Sweet Bananas_ 


Understand the constraint and I am seeking any solution that can address this.  Thank you 

The only alternative here is create a Calculated Scripted Field to dynamically show the 'is blocked by' issues of the current issue. Then, add that new field as a Colum in spite of the Links field.


You need some groovy skills to do that.

Like Joachim Schneider likes this

@Jack Nolddor _Sweet Bananas_ 


Thank you , in other words create a new custom field?

A scripted one using Script Runner for Jira

Field 'issueFunction' does not exist or you do not have permission to view it.
Like # people like this

Suggest an answer

Log in or Sign up to answer

Atlassian Community Events