LinkedIssues

[Kashif Saleem]

I want to create a query to show me all issuetype bugs linked to a specific issuetype task is that possible?

[Bill Sheboy · Accepted solution]

Hi @Kashif Saleem -- Welcome to the Atlassian Community!

Short answer: no, not with out-of-the-box JQL features

Longer answer approaches/work-arounds, based upon frequency of need and costs:

• One time and free: you may want to export to a spreadsheet to manually compare the issues
• Often and monthly costs: consider purchasing a marketplace addon to enhance JQL features
• Often and free: consider learning about automation rules to dynamically build the query you need

Best regards,
Bill

[Kashif Saleem]

Hi Bill,

        Thanks for the swift reply.

What if I used scriptrunner, would it possible then?

Regards

[Bill Sheboy]

Yes, I expect you can do that with ScriptRunner.  I haven't used that tool for years, so I recommend checking their documentation or waiting a bit to see how others comment to this post/question.

[Daniel Turczanski - JQL Search Extensions]

Hi,

With standard JQL you can only get a list of issues with links and export them to Excel for further processing. This works if you want to do a one-off analysis.

Standard JQL doesn't easily allow it but the results can be quickly found using our professional indexing service:

• JQL Search Extensions

After you install the app you can simply search:

issue in linkedIssuesOfQuery("type=Task", "blocks")

You may want to check out the docs as well.

I hope this helps!

Daniel

[Daniel Ebers]

Hi @Kashif Saleem

like Bill suggested there are some options with Script Runner for Jira Cloud (using the Enhanced search).

If I got you correctly you are after information about the linkage of bugs and tasks.
The "linkedIssuesOf" should be the function, however it could need some refinement.

The documentation can be found here:

https://docs.adaptavist.com/sr4jc/current/scriptrunner-enhanced-search/enhanced-search-included-functions#id-.EnhancedSearchIncludedFunctionsvCurrent-linkedIssuesOf

Because the function also works on Jira Server where I have it at hand I tested it and got it to work as follows:

type = bug AND issueFunction in linkedIssuesOf("type = task", "blocks")

However, the link type of "blocks" was just an example. I believe that in Cloud it should work with no much difference.

Here an example how the query reflects to an issue which has a linked issue of the type "task" queried for:
Regards,
Daniel

[Herbert Kevin]

Hi,

do you know if it's possible to do the same thing without using :

issueFunction in linkedIssuesOf

or  

issue in linkedIssuesOfQuery

I can't us this 2 functions.  

[Bill Sheboy]

Hi @Herbert Kevin 

Please see the earlier, noted work-arounds, suggesting exporting the issues for analysis in a spreadsheet (or other tool)...when you need this infrequently.  If you need this often, you will need one of the marketplace addons for JQL to help.

Kind regards,
Bill

[Rahul_RVS]

Hi @Kashif Saleem 

For a ready made solution you can try out our plugin, to track progress of issues in your Links hierarchy on time estimates and at story points as well.

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

We have a feature to filter child issue types linked to the parent issue. And the app allows to view the complete hierarchy based on your issue links type.

Key features of Links Hierarchy:

• Links 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

You also get 4 other important functionalities within the same plugin, Epic Hierarchy (standard Jira Epic -> Story -> Subtask hierarchy) and Multiple Time in Status reports (to track your issues), Worklogs report based on multiple filter criteria, Timesheet screen to enter your time spent from a single place.

Thanks

Rahul