Uploaded image for project: 'Jira Platform Cloud'
  1. Jira Platform Cloud
  2. JRACLOUD-22577

Ability to search for all issues that are linked to (i.e. blocking) by any issue

    • 5
    • 20
    • Our product teams collect and evaluate feedback from a number of different sources. To learn more about how we use customer feedback in the planning process, check out our new feature policy.

      linkedIssues() is fine if you know what issues to check links to, but if like us, you want to be able to see any issues that have been assigned to you that are blocking someone else from completing one of their issues, then it cannot be done.

      I want to be able to do something like:
      (status = Open OR status = Reopened) AND assignee = currentUser() AND issue in linkedIssues((status = Open or status = Reopened) and link = blocks) ORDER BY priority DESC, created ASC

      "tell me which items i have open that block other issues that are open"

          Form Name

            [JRACLOUD-22577] Ability to search for all issues that are linked to (i.e. blocking) by any issue

            Laura Campbell_Seibert added a comment - - edited

            Dependency Mapper for Jira may be of help since it allows you to visualize dependencies between issues. You can choose how you want to group them, so see links based on project, Epic, fix version, or assignee, and then choose if you want to see the issues in a board, list, matrix or several other chart options.

            Laura Campbell_Seibert added a comment - - edited Dependency Mapper for Jira may be of help since it allows you to visualize dependencies between issues. You can choose how you want to group them, so see links based on project, Epic, fix version, or assignee, and then choose if you want to see the issues in a board, list, matrix or several other chart options.

            We use Jira for project management and the ability to SEE all the issues that are blocking projects in "red" is fundamental.

            William Judd added a comment - We use Jira for project management and the ability to SEE all the issues that are blocking projects in "red" is fundamental.

            Still struggling with this, I can't get approval for the plugins, just wish this were possible natively. 

            Lisa Napier added a comment - Still struggling with this, I can't get approval for the plugins, just wish this were possible natively. 

            I believe this is something common,

             

             i need to be able to query as following (as often requested by teamleads)

             

            "Show me all Epics with their linked tickets" 

            so roughly translated to JQL this would be something as following: 

             

            Project = XX AND type = EPIC OR issue in (LinkedIssuesOf("isTaksOf", project = XX AND type = EPIC)) 

            Kevin Gérard added a comment - I believe this is something common,    i need to be able to query as following (as often requested by teamleads)   "Show me all Epics with their linked tickets"  so roughly translated to JQL this would be something as following:    Project = XX AND type = EPIC OR issue in (LinkedIssuesOf("isTaksOf", project = XX AND type = EPIC)) 

            I'm also looking for a solution similar to this.  I was to query all items that caused a bug or more specifically, are linked by "is caused by".  As with he above issue, I'm not looking for linked issues of known items, but any item that been linked by the specified link.  Please tell me Jira has added this feature>

            Steven Sampson added a comment - I'm also looking for a solution similar to this.  I was to query all items that caused a bug or more specifically, are linked by "is caused by".  As with he above issue, I'm not looking for linked issues of known items, but any item that been linked by the specified link.  Please tell me Jira has added this feature>

            Bump, this is well needed

            oliver.peacey added a comment - Bump, this is well needed

            8 years and still missing in Cloud?

            vladan_colovic added a comment - 8 years and still missing in Cloud?

            it can be achieved with SQL for JIRA:

            issue in sql("
            select othersissues.key
            from issuestatusdefinitions s
            inner join issues othersissues on s.id=othersissues .typeid
            where othersissues .id in (
            select myissues.id
            from issuelinks l
            inner join issues myissues on myissues.id=l.issueid
            and
            myissues.jql='(status = Open OR status = Reopened) AND assignee = currentUser()'
            where l.type='Blocks' and l.direction='inward' )
            and s.name in ('Open', 'Reopened')
            ") ORDER BY priority DESC, created ASC

            Pablo Beltran added a comment - it can be achieved with SQL for JIRA : issue in sql(" select othersissues.key from issuestatusdefinitions s inner join issues othersissues on s.id=othersissues .typeid where othersissues .id in ( select myissues.id from issuelinks l inner join issues myissues on myissues.id=l.issueid and myissues.jql='(status = Open OR status = Reopened) AND assignee = currentUser()' where l.type='Blocks' and l.direction='inward' ) and s.name in ('Open', 'Reopened') ") ORDER BY priority DESC, created ASC

            Check out the linkedIssuesHasStatus (status,[linkType]) function in JQL Tricks Plugin!

            Jobin Kuruvilla added a comment - Check out the linkedIssuesHasStatus (status, [linkType] ) function in JQL Tricks Plugin!

              Unassigned Unassigned
              stringfellow Steve Pike
              Votes:
              64 Vote for this issue
              Watchers:
              37 Start watching this issue

                Created:
                Updated: