Filter issue that has open linked issue(Blocked+Blocked By)

Question

There has been previous threads relating to this problem, however many provided old solution.

Could someone please suggest how can I achieve to filter issues in project that has linked issues that are blocking it and still unresolved.

I currently use

Project=xyz AND issueLinkType in (blocks,"is blocked by","depends on")

This gives me list of all linked issue irrespective of it's resolution.

Can anyone help me from this group? Thanks!

Muhammad Ramzan_Atlassian Certified Master_ · Answer

Hi @Vaishnavi Kulkarni , I am afraid, you can't by vanila jql. There are some adons which can support you. Famous one's are * JQL Search Extensions for Jira & reports * Script Runner below is the example of JQL Search Extensions for Jira & repo following query will return all linked issues which are not resolved issue in linkedBy("is blocked by", "is related to", resolution = unresolved) Reference https://jqlsearchextensions.atlassian.net/wiki/spaces/SEARCH/pages/30497099/JQL+Reference+Server#JQLSearchExtensions(Server)-LinksCountLessThan

Hyrum Steffensen {Appfire} · Answer

Hello Vaishnavi,

If you are using Jira Server or Data Center, you can use Power Scripts JQL support to return issues based on link type. For example:

key in hasLinksOfType("project = EX AND status != Done", "Relates")

Please note that I a support engineer for Power Scripts and I work for Anova Apps, an Appfire company.

Regards,

Hyrum