Uploaded image for project: 'Jira Data Center'
  1. Jira Data Center
  2. JRASERVER-14747

Ability to search for issues with blockers linked to them

    • 1
    • Hide
      Atlassian Update – 21 December 2018

      Dear Jira users,

      We’re glad to announce that this issue will be addressed in our upcoming 8.0 release.

      You can find more details about our 8.0 beta release here — https://community.developer.atlassian.com/t/beta-for-jira-8-0-is-up-for-grabs/25588

      Looking forward to your feedback!

      Kind regards,
      Syed Masood
      Product Manager, Jira Server and Data Center

      Show
      Atlassian Update – 21 December 2018 Dear Jira users, We’re glad to announce that this issue will be addressed in our upcoming 8.0 release. You can find more details about our 8.0 beta release here — https://community.developer.atlassian.com/t/beta-for-jira-8-0-is-up-for-grabs/25588 Looking forward to your feedback! Kind regards, Syed Masood Product Manager, Jira Server and Data Center
    • We collect Jira feedback from various sources, and we evaluate what we've collected when planning our product roadmap. To understand how this piece of feedback will be reviewed, see our Implementation of New Features Policy.

      NOTE: This suggestion is for JIRA Server. Using JIRA Cloud? See the corresponding suggestion.

      A search I would find handy is to be able to pull up all issues that are linked to another as a 'blocker'
      (and in a seperate search, those that are 'blocked')

      so we can see what issues are stopping others progressing

      apologies if this is already possible, but I can't see it in the version of 3.11 enterprise I'm using (was set up before I started work here, and I have no admin rights )

            [JRASERVER-14747] Ability to search for issues with blockers linked to them

            This feature would be great if it included searching by specific issuelink type, not just a blocker. 

            Tracy Walton added a comment - This feature would be great if it included searching by specific issuelink type, not just a blocker. 

            SQL for JIRA supports it in an easy and flexible way:

            issue in sql("
            select i.key
            from issuelinks l inner join issues i on l.issueid= i.id and jql='project=MYPROJ'
            where l.type='Blocks' and l.direction = 'inward'
            ")

            or maybe you want to perform just the same SQL outside of the Issue Navigator nicely integrated with your corporate reporting tool

            Pablo Beltran added a comment - SQL for JIRA supports it in an easy and flexible way: issue in sql(" select i.key from issuelinks l inner join issues i on l.issueid= i.id and jql='project=MYPROJ' where l.type='Blocks' and l.direction = 'inward' ") or maybe you want to perform just the same SQL outside of the Issue Navigator nicely integrated with your corporate reporting tool

            If you are open to using an add-on, we made Vivid Trace for JIRA to solve this problem & all problems like it. The following JQL queries address each of your queries, and will make a good starting point for fine-tuning.

            A search I would find handy is to be able to pull up all issues that are linked to another as a 'blocker'

            To find all issues that block i.e. ABC-123, including those that block the blockers, and so on:
            issue IN relations(ABC-123, "issuelinktype = blocks", "direction = inward")

            (and in a seperate search, those that are 'blocked')

            issue IN relations(ABC-123, "issuelinktype = blocks", "direction = outward")

            The JQL functions are fully documented here. And you don't have to memorize any parameter orders, just put in whatever parameters you need in whatever order suits you.

            Cheers!

            Keiei Tanto [Vivid] added a comment - If you are open to using an add-on, we made Vivid Trace for JIRA to solve this problem & all problems like it. The following JQL queries address each of your queries, and will make a good starting point for fine-tuning. A search I would find handy is to be able to pull up all issues that are linked to another as a 'blocker' To find all issues that block i.e. ABC-123 , including those that block the blockers, and so on: issue IN relations(ABC-123, "issuelinktype = blocks", "direction = inward") (and in a seperate search, those that are 'blocked') issue IN relations(ABC-123, "issuelinktype = blocks", "direction = outward") The JQL functions are fully documented here . And you don't have to memorize any parameter orders, just put in whatever parameters you need in whatever order suits you. Cheers!

            Seshu added a comment -

            Would be nice to be able to pull up both the blocks & blocked by issue IDs and their statuses & assignee in the same search/filter. This is an important report for us that we will need almost on a daily basis.

            Seshu added a comment - Would be nice to be able to pull up both the blocks & blocked by issue IDs and their statuses & assignee in the same search/filter. This is an important report for us that we will need almost on a daily basis.

            I wholeheartedly agree

            Mark Hetherington added a comment - I wholeheartedly agree

            I echo the users above me. We'd like the ability to search for issues that are blocked or are blockers of ANY issue.

            Cory Watson added a comment - I echo the users above me. We'd like the ability to search for issues that are blocked or are blockers of ANY issue.

            Would be nice to be able to search for all issues that are 'blocking', 'dependant' etc.

            William 'Smooth' Richens added a comment - Would be nice to be able to search for all issues that are 'blocking', 'dependant' etc.

            Please note that this request was definitely not solved in JIRA 4.0. What was added via JRA-3101 is the ability to search for issues linked to a specific issue. This request is asking for the capability to search for all issues that have a link of a certain type, regardless of the link target.

            This is still something being requested by my users, and seems like it should not be complicated.

            Kavian Moradhassel added a comment - Please note that this request was definitely not solved in JIRA 4.0. What was added via JRA-3101 is the ability to search for issues linked to a specific issue. This request is asking for the capability to search for all issues that have a link of a certain type, regardless of the link target. This is still something being requested by my users, and seems like it should not be complicated.

            Jon Abad added a comment -

            Brian,
            How does one search a project for all issues blocking other issues? The new linkedissues() function in 4.0 doesn't appear to provide this functionality.

            Jon Abad added a comment - Brian, How does one search a project for all issues blocking other issues? The new linkedissues() function in 4.0 doesn't appear to provide this functionality.

            Brian Lane added a comment -

            We are addressing this request with the upcoming release of JIRA 4.0.

            JIRA 4.0 will include a new query language that resolves many search related issues with JIRA.

            For more information about JQL, the beta JQL reference guide is available online: http://confluence.atlassian.com/display/JIRA/Advanced+Searching

            JIRA 4.0 beta 2 is currently available for download:

            http://www.atlassian.com/software/jira/beta

            Brian Lane added a comment - We are addressing this request with the upcoming release of JIRA 4.0. JIRA 4.0 will include a new query language that resolves many search related issues with JIRA. For more information about JQL, the beta JQL reference guide is available online: http://confluence.atlassian.com/display/JIRA/Advanced+Searching JIRA 4.0 beta 2 is currently available for download: http://www.atlassian.com/software/jira/beta

              agniadzik Artur Gniadzik
              8bd10cb4dd18 Rachael Russell
              Votes:
              48 Vote for this issue
              Watchers:
              22 Start watching this issue

                Created:
                Updated:
                Resolved: