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

JQL function for showing all issues linked to any issue by a given issue link type

    • 828
    • 70
    • 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.

      originally copied from this comment

      Function linkedIssues() only shows the issues linked to a particular issue, I want to find all issues those are linked to other issues marked by a specific link type, e.g., "is blocked by".

      This function could incorporate querying issues that are linked to any issue with a given link type and bearing in mind that links have two identities, one in each direction, the link type could be direction specific or not.

      Examples

      1. find all issues that are duplicates of issue JRA-25640 (one direction, issue specified)
      2. find all issues that are blocking issue JRA-25640 or that JRA-25640 blocks (bidirectional, issue specified)
      3. find all issues that are duplicates of any issue, or which duplicate any issue (bidirectional, no issue specified)
      4. find all issues that are blocked (one direction, no issue specified)
      5. find all issues that are linked to a specific issue and display those based on a specific depth (linked issues displaying linked relationship two, three, etc., issues deep)

      Implementation Notes

      • The JQL function that exists must continue to work exactly as it does. If it is possible to overload the JQL function based on arity and this makes a consistent API, then this would be preferred. Otherwise, there may need to be a new function name which provides vararg behaviour as described above.
      • The link index entries added in 4.4 (I think) provide enough to build performant lucene queries for the above use cases. What's missing is the JQL function plumbing.

            [JRASERVER-25640] JQL function for showing all issues linked to any issue by a given issue link type

            Hi - I'm looking for a visual cue to put on the ticket so when we look at the board we can see that it is blocked. A bright red label, a red boundary, flashing lights - whatever works!  Any enhancements in the works for this?

            Alex Eldridge added a comment - Hi - I'm looking for a visual cue to put on the ticket so when we look at the board we can see that it is blocked. A bright red label, a red boundary, flashing lights - whatever works!  Any enhancements in the works for this?

            Hi all, I believe you will find really useful the following JQL functions provided by latest version of JQL Booster Pack (FREE):

             

            Jack Nolddor [Sweet Bananas] added a comment - Hi all, I believe you will find really useful the following JQL functions provided by latest version of JQL Booster Pack (FREE): parentsOf() subtasksOf() epicsOf() issuesInEpics() linkedIssuesOf()  

            Is there a page with more examples?

            I would like to add colors to cards based on filters. Marking a ticket which blocks another is quiete easy now (hooray). But what about the blocked tickets?

            I would like to colorize in orange:

            "This ticket is blocked by one or more other non-resolved tickets."

            and in green:

            "This ticket is not blocked by any non-resolved ticket"

            Thorsten Feldmann added a comment - Is there a page with more examples? I would like to add colors to cards based on filters. Marking a ticket which blocks another is quiete easy now (hooray). But what about the blocked tickets? I would like to colorize in orange: "This ticket is blocked by one or more other non-resolved tickets." and in green: "This ticket is not blocked by any non-resolved ticket"

            @Joshua Wyss

            "Solutions" like this are the exactl reason why my company is actively looking for Jira alternative (YouTrack by JetBrains, Azure DevOps by Microsoft, etc)

            vladan_colovic added a comment - @Joshua Wyss "Solutions" like this are the exactl reason why my company is actively looking for Jira alternative (YouTrack by JetBrains, Azure DevOps by Microsoft, etc)

            For those owning a license for Power Scripts (formerly known as JJupin] you have these features included.

            Florin Haszler (Alten Kepler) added a comment - For those owning a license for Power Scripts (formerly known as JJupin] you have these features included.

            @Joshua Wyss because I don't want to pay for scriptrunner to do something Jira already should have. 

            Victor Vucicevich added a comment - @Joshua Wyss because I don't want to pay for scriptrunner to do something Jira already should have. 

            when can we use this function issuelinks.. we have our own Jira instance in our server

             

            Deleted Account (Inactive) added a comment - - edited when can we use this function issuelinks.. we have our own Jira instance in our server  

            @Valadan Colovic I'm not sure what Atlassian's incentive to adding this feature is when ScriptRunner already has it and has more options. Plus, Atlassian surly make a profit off of the add-ons...

            Deleted Account (Inactive) added a comment - @Valadan Colovic I'm not sure what Atlassian's incentive to adding this feature is when ScriptRunner already has it and has more options. Plus, Atlassian surly make a profit off of the add-ons...

            OMG? JIRA still lacks this basic functionality? In Cloud?

            vladan_colovic added a comment - OMG? JIRA still lacks this basic functionality? In Cloud?

            Hi manohar.kurapati

            This suggestion relates to Jira Server only. For status updates on Jira Cloud please watch the corresponding suggestion https://jira.atlassian.com/browse/JRACLOUD-25640

            Best regards

            Gosia Kowalska, Product Manager for Jira Server and Data Center

            Gosia Kowalska added a comment - Hi manohar.kurapati ,  This suggestion relates to Jira Server only. For status updates on Jira Cloud please watch the corresponding suggestion https://jira.atlassian.com/browse/JRACLOUD-25640 Best regards Gosia Kowalska, Product Manager for Jira Server and Data Center

            @Arthur Gniadzik

            Please can you confirm when this basic functionality will be LIVE for customers?

            We are using Jira cloud in our organization with 1100+ active users. To get a add-on to do this function will cost us $1000 per month. Really appreciate if you can get this feature live soon. 

            Thanks

             

            Manohar Kurapati added a comment - @Arthur Gniadzik Please can you confirm when this basic functionality will be LIVE for customers? We are using Jira cloud in our organization with 1100+ active users. To get a add-on to do this function will cost us $1000 per month. Really appreciate if you can get this feature live soon.  Thanks  

            Thanks for detail update on current status.

            Bhavin Acharya added a comment - Thanks for detail update on current status.

            Rexel USA added a comment -

            @Artur Gniadzik

            Thanks for the update! 

            Do you have an ETA release for Jira 8? 

            • Zac

            Rexel USA added a comment - @Artur Gniadzik Thanks for the update!  Do you have an ETA release for Jira 8?  Zac

            Rexel USA added a comment -

            @Artur Gniadzik

            In your notes it says there was supposed to be an update within 6 months. It's been 8. Any update? 

             

            Rexel USA added a comment - @Artur Gniadzik In your notes it says there was supposed to be an update within 6 months. It's been 8. Any update?   

            This request, to me, is specifically requesting that Atlassian develop a JQL Function that caches and allows searching of Issue Link data based on arguments provided to the function.

            Alternatively, I would say that asking for AutoComplete support for JQL Functions is a feature request in-and-of-itself. 

            I'm not critiquing, I'm merely commenting on why that would be more difficult. 

            Steven F Behnke added a comment - This request, to me, is specifically requesting that Atlassian develop a JQL Function that caches and allows searching of Issue Link data based on arguments provided to the function. Alternatively, I would say that asking for AutoComplete support for JQL Functions is a feature request in-and-of-itself.  I'm not critiquing, I'm merely commenting on why that would be more difficult. 

            For that purpose we have created this issue, right? we are suggesting Atlassian to provide this feature. Otherwise how can I get correct data of my project and sense for action??

            Bhavin Acharya added a comment - For that purpose we have created this issue, right? we are suggesting Atlassian to provide this feature. Otherwise how can I get correct data of my project and sense for action??

            That'd be nice but I don't think JQL functions support autocomplete.

            Steven F Behnke added a comment - That'd be nice but I don't think JQL functions support autocomplete.

            filter should available for all linking including custom linking.

            for example, it should be like, when we put 'type' and Jira shows all possible operator options.

            Bhavin Acharya added a comment - filter should available for all linking including custom linking. for example, it should be like, when we put 'type' and Jira shows all possible operator options.

            Just to tell you that I'd need to create a filter where I can detect issues that are not blocked anymore, so can be worked (the issue is in "ToDo" and has blocking linked issues but all of them are "Done").

            Cristiano Toncelli added a comment - Just to tell you that I'd need to create a filter where I can detect issues that are not blocked anymore, so can be worked (the issue is in "ToDo" and has blocking linked issues but all of them are "Done").

            Tracy Walton added a comment - - edited

            I would like for my automation rule to only run if a particular linkedissue type is not found on the issue. It doesn't look like the scope of this JRASERVER ticket will cover that

             

             

            Wait! I see the issue now that Legna commented above. Thanks!

            Tracy Walton added a comment - - edited I would like for my automation rule to only run if a particular linkedissue type is not found on the issue. It doesn't look like the scope of this JRASERVER ticket will cover that     Wait! I see the issue now that Legna commented above. Thanks!

            Hi all,

            I would like to know if there is a target date for delivering this feature for cloud version that corresponds to the same request into this ticket. Since there are no updates over its status, I would like to know if there is any update about that.

             

            Legna Garcia added a comment - Hi all, I would like to know if there is a target date for delivering this feature for cloud version that corresponds to the same request into this ticket . Since there are no updates over its status, I would like to know if there is any update about that.  

            Brad Hasha added a comment -

            That addresses is EMPTY and not EMPTY which is something that would be useful for our team.  However, it doesn't address the ability to search by issue type, eg. relates to, blocked by, etc.  Those would be very useful to our team, as well as to many other teams from the digging I've done.

            Brad Hasha added a comment - That addresses is EMPTY and not EMPTY which is something that would be useful for our team.  However, it doesn't address the ability to search by issue type, eg. relates to, blocked by, etc.  Those would be very useful to our team, as well as to many other teams from the digging I've done.

            Hi everyone,

            Thank you for voting and commenting on this suggestion. As with most suggestions, this one also touches upon multiple problems and unfortunately there is no "silver bullet" solution that would address all of them.

            As Jira Server Team, we are currently exploring ways to address some aspects of this suggestion, namely, making it possible to search by linked issues.

            We have already asked some of you for feedback via email, but we would like to hear from more users.

            Please spare 5 min of your time, review our proposal and respond to a short survey here: https://goo.gl/forms/whbCmntSe0Eu6tAv2

            Let us know what you think. This will help a lot.

            Thank you!

            Gosia Kowalska
            Jira Server Team

            Gosia Kowalska added a comment - Hi everyone, Thank you for voting and commenting on this suggestion. As with most suggestions, this one also touches upon multiple problems and unfortunately there is no "silver bullet" solution that would address all of them. As Jira Server Team, we are currently exploring ways to address some aspects of this suggestion, namely, making it possible to search by linked issues. We have already asked some of you for feedback via email, but we would like to hear from more users. Please spare 5 min of your time, review our proposal and respond to a short survey here: https://goo.gl/forms/whbCmntSe0Eu6tAv2 Let us know what you think. This will help a lot. Thank you! Gosia Kowalska Jira Server Team

            Bobby Erwin added a comment - - edited

            If you want it for the cloud, please vote for:
            https://jira.atlassian.com/browse/JRACLOUD-25640

            Bobby Erwin added a comment - - edited If you want it for the cloud, please vote for: https://jira.atlassian.com/browse/JRACLOUD-25640

            Echo Dan's opinion above: what about JIRA cloud? We need this!

            Maria Flores added a comment - Echo Dan's opinion above: what about JIRA cloud? We need this!

            dan_sandler1829579087 added a comment -

            What about JIRA cloud? This seems to me to be something that should be a part of the JQL

            dan_sandler1829579087 added a comment - What about JIRA cloud? This seems to me to be something that should be a part of the JQL

            THANK YOU - this will be of great help for a variety of projects that we've seen. Looking forward to seeing in a future JIRA version.

            Miheer Munjal added a comment - THANK YOU - this will be of great help for a variety of projects that we've seen. Looking forward to seeing in a future JIRA version.

            Hi everyone,

            Thank you for your votes and thoughts on this issue.

            We fully understand that many of you are dependent on this functionality.

            After careful consideration, we've decided to prioritize this suggestion on Jira Server roadmap. We hope to start development after our current projects are completed. 

            Expect to hear an update on our progress within the next 6 months. 

            To learn more on how JAC suggestions are reviewed, see our updated workflow for server feature suggestions.

            Kind regards,

            Jira Server Product Management

            Gosia Kowalska added a comment - Hi everyone, Thank you for your votes and thoughts on this issue. We fully understand that many of you are dependent on this functionality. After careful consideration, we've decided to prioritize this suggestion on Jira Server roadmap. We hope to start development after our current projects are completed.  Expect to hear an update on our progress within the next 6 months.  To learn more on how JAC suggestions are reviewed, see our updated workflow for server feature suggestions . Kind regards, Jira Server Product Management

            Mas Jaya added a comment -

            +100 voting this feature.

            Mas Jaya added a comment - +100 voting this feature.

            I think it's a case of the Atlassian technical tail wagging the business dog.

            Some of our non-technical but important users spotted Scum Board quick filters and were immediately perplexed when they found themselves staring at a stock field in a JIRA issue but couldn't use it in filters.  I had to tell them they could have it if they ponied up for a per-user license.   Oh, and it's advanced filtering that adds programmer-like query primitives that are daunting to non-technical users.  We have a LOT of active users. The more there are the more there are to be perplexed.

            JIRA Advanced Query Guru is not a job title here. I could be one, but I have enough work to fill my day and then some.

            Greg Carpenter added a comment - I think it's a case of the Atlassian technical tail wagging the business dog. Some of our non-technical but important users spotted Scum Board quick filters and were immediately perplexed when they found themselves staring at a stock field in a JIRA issue but couldn't use it in filters.  I had to tell them they could have it if they ponied up for a per-user license.   Oh, and it's advanced filtering that adds programmer-like query primitives that are daunting to non-technical users.  We have a LOT of active users. The more there are the more there are to be perplexed. JIRA Advanced Query Guru is not a job title here. I could be one, but I have enough work to fill my day and then some.

            The field comes built in with JIRA and it's there in every issue. Sorry, paying per-user license fees for the ability to filter on fields that are built in just doesn't cut it.

            Greg Carpenter added a comment - The field comes built in with JIRA and it's there in every issue. Sorry, paying per-user license fees for the ability to filter on fields that are built in just doesn't cut it.

            Maggie Gu added a comment -

            It's hard to manage JIRA by current JQL, is there a plan for this feature?

            Maggie Gu added a comment - It's hard to manage JIRA by current JQL, is there a plan for this feature?

            MM (PREM) added a comment -

            seems that Atlassian can't make money out of this. So they do not care!!!

            MM (PREM) added a comment - seems that Atlassian can't make money out of this. So they do not care!!!

            j.jarvela added a comment -

            Also voting for this feature

            j.jarvela added a comment - Also voting for this feature

            Nick added a comment -

            Considering JIRA issues dynamically populated in Confluence pages is a pretty important integration and the only real option is through JQL filtering this would seem like a very necessary feature out of the box. Its very sad when the integration between two products made by the same company are **so lacking and incomplete. The thought that JIRA's Product Manager Dave Meyer would pawn the responsibility of this to the marketplace is embarrassing.

            Nick added a comment - Considering JIRA issues dynamically populated in Confluence pages is a pretty important integration and the only real option is through JQL filtering this would seem like a very necessary feature out of the box . Its very sad when the integration between two products made by the same company are **so lacking and incomplete. The thought that JIRA's Product Manager Dave Meyer would pawn the responsibility of this to the marketplace is embarrassing.

            I'll go one step further. The query needs to (optionally) return the issues and subtasks that belong to the epic that has the selected link type.

            Shawn Wallack added a comment - I'll go one step further. The query needs to (optionally) return the issues and subtasks that belong to the epic that has the selected link type.

            Shu Santo Kurniawan added a comment - - edited

            why this function still not available ?

             

            Shu Santo Kurniawan added a comment - - edited why this function still not available ?  

            It is a shame not having this functionality.

            Vineet Saurabh added a comment - It is a shame not having this functionality.

            Understood this is unlikely to be worked on, but it would be a very useful feature for us.

            Simon Williams added a comment - Understood this is unlikely to be worked on, but it would be a very useful feature for us.

            this would hugely improve the power of JIRA 

            Charlie Misonne added a comment - this would hugely improve the power of JIRA 

            +1 this is a huge pain point for our team, with cloud version even if we were willing and able, we dont have the option of an plug in.

            Rosa Trachta added a comment - +1 this is a huge pain point for our team, with cloud version even if we were willing and able, we dont have the option of an plug in.

            Mike, and why not SQL for JIRA?

            Pablo Beltran added a comment - Mike, and why not SQL for JIRA ?

            Mike Diehn added a comment -

            Ert, we removed JQL Tricks from our production instance because it let users easily build JIRA killing queries. Training and "co-worker feedback" helped but we're always hiring new people who don't get that "feedback" quickly enough to make the training important to them.

            Mike Diehn added a comment - Ert, we removed JQL Tricks from our production instance because it let users easily build JIRA killing queries. Training and "co-worker feedback" helped but we're always hiring new people who don't get that "feedback" quickly enough to make the training important to them.

            Ert Dredge added a comment -

            +1. Can't we at least just add the JQL tricks plugin to Cloud?

            Ert Dredge added a comment - +1. Can't we at least just add the JQL tricks plugin to Cloud?

            Kirk Fahlberg added a comment - - edited

            +1 - Our company is using Jira cloud and we cannot load any of the add-ons needed to get this type of functionality.

            Function linkedIssues() only shows the issues linked to a particular issue, I want to find all issues those are linked to other issues marked by a specific link type, e.g., "is blocked by".

            This function could incorporate querying issues that are linked to any issue with a given link type and bearing in mind that links have two identities, one in each direction, the link type could be direction specific or not.

            Examples

            • find all issues that are blocked (one direction, no issue specified)
            • * find all issues that are duplicates of any issue, or which duplicate any issue (bidirectional, no issue specified)

            Edit: Failed to mention... that the company we are working with uses a competitive product that is able to filter these out. At our sprint reviews we present a report of
            Planned Story Points — Completed Story Points ---- Blocked Story Points
            Blocked Issue List (Lists the issues that are Blocks or Is Blocked By)
            Incomplete Issue List
            Complete Issue List.

            The built in Sprint Report is very similar - MINUS the ability to show Blocks or Is Blocked By.

            Kirk Fahlberg added a comment - - edited +1 - Our company is using Jira cloud and we cannot load any of the add-ons needed to get this type of functionality. Function linkedIssues() only shows the issues linked to a particular issue, I want to find all issues those are linked to other issues marked by a specific link type, e.g., "is blocked by". This function could incorporate querying issues that are linked to any issue with a given link type and bearing in mind that links have two identities, one in each direction, the link type could be direction specific or not. Examples find all issues that are blocked (one direction, no issue specified) * find all issues that are duplicates of any issue, or which duplicate any issue (bidirectional, no issue specified) Edit: Failed to mention... that the company we are working with uses a competitive product that is able to filter these out. At our sprint reviews we present a report of Planned Story Points — Completed Story Points ---- Blocked Story Points Blocked Issue List (Lists the issues that are Blocks or Is Blocked By) Incomplete Issue List Complete Issue List. The built in Sprint Report is very similar - MINUS the ability to show Blocks or Is Blocked By.

            Sigh, if I had a dime for every time a feature we needed was only available as an on-prem plugin I could contract out my own implementation of an issue system.

            Barry Kaplan added a comment - Sigh, if I had a dime for every time a feature we needed was only available as an on-prem plugin I could contract out my own implementation of an issue system.

            DJX added a comment -

            I think Atlassian should start to follow the lead of other software vendors like Autodesk. When a 3rd party comes out with a plugin that many people use, they purchase it and roll it into their base software. I prefer this model, because I actually get new features and added value for each license renewal. It also keeps the add-on costs low, and thus the TCO low as well.

            DJX added a comment - I think Atlassian should start to follow the lead of other software vendors like Autodesk. When a 3rd party comes out with a plugin that many people use, they purchase it and roll it into their base software. I prefer this model, because I actually get new features and added value for each license renewal. It also keeps the add-on costs low, and thus the TCO low as well.

            Tim Ryan added a comment -

            As an addendum to my above comment, there is a plugin called "Vivd Trace" that claims to have this searching on linked issues functionality, however it is not currently available for JIRA Cloud instances (unsure of JIRA server compatibility).

            Tim Ryan added a comment - As an addendum to my above comment, there is a plugin called "Vivd Trace" that claims to have this searching on linked issues functionality, however it is not currently available for JIRA Cloud instances (unsure of JIRA server compatibility).

            Tim Ryan added a comment -

            I used to use this functionality, got my teams on board with linking issues, now we can't access the functionality + the plugin that could have worked around this problem has been discontinued

            Tim Ryan added a comment - I used to use this functionality, got my teams on board with linking issues, now we can't access the functionality + the plugin that could have worked around this problem has been discontinued

            Dave Meyer added a comment -

            Hi domain,

            You can learn more about how we use jira.atlassian.com to prioritize feature requests here.

            Regards,
            Dave Meyer
            Senior Product Manager, JIRA

            Dave Meyer added a comment - Hi domain , You can learn more about how we use jira.atlassian.com to prioritize feature requests here . Regards, Dave Meyer Senior Product Manager, JIRA

            For what version it will be scheduled?

            Peter Mitev added a comment - For what version it will be scheduled?

            When will this be available?

            Christopher Griggs added a comment - When will this be available?

            Atlassian must re-think about JIRA, AGILE & CAPTURE future enhancements/missing functionality to be added to the system to provide complete ALM solution to the market. Team has some wonderful ideas and end-users time-time providing valuable user experience feedback and suggestion to improve the missing functionality.

            Overall end users is actually need these features, but unfortunately we couldn't get complete benefits from these features. We have to dependent on third-party plugins.....It is not a healthy solution to complete ALM product Atlassin is now offering to us.

            Please consider all end-users feedback and organize end-user summit to discuss their needs and feedback/suggestions.

            Ganga Selvarajah added a comment - Atlassian must re-think about JIRA, AGILE & CAPTURE future enhancements/missing functionality to be added to the system to provide complete ALM solution to the market. Team has some wonderful ideas and end-users time-time providing valuable user experience feedback and suggestion to improve the missing functionality. Overall end users is actually need these features, but unfortunately we couldn't get complete benefits from these features. We have to dependent on third-party plugins.....It is not a healthy solution to complete ALM product Atlassin is now offering to us. Please consider all end-users feedback and organize end-user summit to discuss their needs and feedback/suggestions.

              agniadzik Artur Gniadzik
              chris@atlassian.com Chris Mountford
              Votes:
              829 Vote for this issue
              Watchers:
              439 Start watching this issue

                Created:
                Updated:
                Resolved: