How to see only and only dependent tasks in JQL search results?

[Anish Shah]

If I use following query in JQL . 

issuefunction in hasLinks("is blocked by") AND issuelinktype = "is blocked by"

It will result in all the related linked links to that specific story/task in column name: "linked issue" 

But If want to show only and only "is blocked by" issue linked in results table. How to do that? 

[Ivan Garcia {Appfire}]

Hi @Anish Shah 

If you're up for trying an app, my company develops Dashboard Hub for Jira - Custom Charts & Share Reports, with which you can easily create custom charts with JQL.

I suggest giving it a try with the 30-day free trial and see if it solves your pain :) Hope it helps!

Iván from Appfire team

[Marc - Devoteam]

Hi @Anish Shah 

This is not an option.

As JQL searches for all issues where a linked issue is present with "is blocked by", this will show all other linked issues on the column as well.

You could make a JQL with excluding those, but this will exclude also issues that do have linked issues"is blocked by", but are excluded by the exclude clause.

Example:

issueLinkType = "is blocked by" and issuefunction not in hasLinkType(depends)

Returns all issues with issueLinkType = "is blocked by", but will exclude issues with issueLinkType = "is blocked by" where the in or out ward liktype of the depends link is used.

[Anish Shah]

Ok. Understood. As you mentioned, currently, it is not an option to see only blocking items.  

Is it not even possible somehow in Jira Dashboards or in Confluence using table formatting or any other possible way? 

[Marc - Devoteam]

HI @Anish Shah 

I don't see this working in Jira as the JQL will show the output. You might give it a try with a JQL extension app and a Dash-boarding app.

Examples; JQL Search Extensions and Custom Charts.

In Confluence you might have more of a chance, but it will require an app as well.

Example: Table and Filter charts

[Anish Shah]

Ok . thanks for suggestions.