JQL Query Assistance - Linked Issues

jprentice
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
August 13, 2019

I'm looking to get data on top separate linked ticket types.

  1. I want to see all tickets with a "relates to" link that is from a specific project
    • The tickets that I want displayed are engineering tickets and the linked tickets come from the support team so we can show what tickets in the release solve an issue brought in by support.
      • Tried this as well as some minor variations without luck
        • fixVersion = Bascom AND type = Bug AND issueFunction in linkedIssuesOf(Project = Support, "relates to")
  2. I want to see all tickets that has a link of "is depended by" so we can have a list view of all tickets blocking other tickets and can see both ticket numbers in the view.

Played around with the following without luck.  https://confluence.atlassian.com/jirasoftwarecloud/advanced-searching-functions-reference764.1565752696-1299981349.1565752696#Advancedsearching-functionsreference-linkedIssueslinkedIssues

Any help would be appreciated.

1 answer

1 accepted

0 votes
Answer accepted
Muhammad Ramzan(Atlassian Certified Master)
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
August 14, 2019

I am using JQL Search Extensions for Jira & reports  to get the data with links.

 

you can use following queries to get the results.

 

following query will return all issues which have link 'relates to'

 

issue in linkType("relates to")

 

Find issues which are blocked by issues from project JQL with priority = Highest. 

issue in linkedBy("is blocked by""is related to""project = JQL AND priority = Highest")

 

Find issues which link at least one issue from project JQL. 

issue in links("project = JQL")

 

 

You can find documentation here

https://jqlsearchextensions.atlassian.net/wiki/spaces/SEARCH/pages/30497099/JQL+Reference+Server#JQLReference(Server)-LinkedIssueType

jprentice
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
August 14, 2019

@Muhammad Ramzan(Atlassian Certified Master)- I don't appear to have the same JQL options.

image.png

Like Influential Eliot likes this
Muhammad Ramzan(Atlassian Certified Master)
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
August 14, 2019

I think you did not install the plugin that's why

JQL Search Extensions for Jira & reports

Suggest an answer

Log in or Sign up to answer