• Icon: Suggestion Suggestion
    • Resolution: Won't Fix
    • None
    • None
    • 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.

      The JQL query language lacks the possibility to return a limited number of issues from a search, compare with SQL LIMIT or TOP statements.

      This would be very valuable when you want to get e.g. the 10 highest ranked stories.

            [JRASERVER-31384] Add JQL LIMIT support

            Hello everyone, 

            You can add limit the search results with the GO! JQL plugin. 

            JQL: issue in limitedResults("priority = Blocker", "20")

            Here is the documentation.

            I hope it helps, bests! 

            Sena Demir _ALMBASE_ added a comment - Hello everyone,  You can add limit the search results with the  GO! JQL plugin.  JQL: issue in limitedResults("priority = Blocker", "20") Here is the documentation . I hope it helps, bests! 

            Jahir H. added a comment -

            We need LIMIT or TOP in JQL

            Jahir H. added a comment - We need LIMIT or TOP in JQL

            Could someone take a look at this suggestion again? 

            Atsumi Stepp added a comment - Could someone take a look at this suggestion again? 

            bc32e99a92d8 Please reopen this suggestion so we can vote on it again. Many people here have provided their use cases.

            Javidan Amiraliyev added a comment - bc32e99a92d8 Please reopen this suggestion so we can vote on it again. Many people here have provided their use cases.

            Yes - very suprised that LIMIT is still not available? Limiting indeed - need to put in a quick fix on the filter of the board, as the JQL there today stopped working an getting error that more than 5000 items are on the board. Checked filter and it is correct...

            David Drury added a comment - Yes - very suprised that LIMIT is still not available? Limiting indeed - need to put in a quick fix on the filter of the board, as the JQL there today stopped working an getting error that more than 5000 items are on the board. Checked filter and it is correct...

            Hello everyone, 

            You can add limit the search results with the GO! JQL plugin. It is for Jira Server and Jira Data Center.

            The Jira Cloud version will be released soon. Here is the documentation.

            I hope it helps, bests! 

            Sena Demir _ALMBASE_ added a comment - Hello everyone,  You can add limit the search results with the  GO! JQL plugin. It is for Jira Server and Jira Data Center. The Jira Cloud version will be released soon. Here is the documentation. I hope it helps, bests! 

            If y'all at Jira would like to think about this again, I'd be soooooo happy!

            On a more serious note, while yes, this is useful for visualizations, it's far more useful for basic automation - especially when it comes to just-in-time planning and alerting.

            I understand if the development effort is too difficult or complex, but it would be nice to think if something could be done...

            Brian Orlando added a comment - If y'all at Jira would like to think about this again, I'd be soooooo happy! On a more serious note, while yes, this is useful for visualizations, it's far more useful for basic automation - especially when it comes to just-in-time planning and alerting. I understand if the development effort is too difficult or complex, but it would be nice to think if something could be done...

            Jorge added a comment -

            We need this, please add.

            Jorge added a comment - We need this, please add.

            Tiger added a comment -

            This would be very useful. I need to pick an issue from every Sprint, any issue (but just one), as a representative of that Sprint to drive some graphical report because the issue contains the start date and end date of its respective Sprint. The report does not have access to any of the global Jira environment variables, so using the actual issues is the only way.

            Wish you had the support for this.

            Tiger added a comment - This would be very useful. I need to pick an issue from every Sprint, any issue (but just one), as a representative of that Sprint to drive some graphical report because the issue contains the start date and end date of its respective Sprint. The report does not have access to any of the global Jira environment variables, so using the actual issues is the only way. Wish you had the support for this.

            this is a basic functionality for a query language .. Splunk, Kibana, SQL do it .. why can't Jira do it ?

            Claver Medina added a comment - this is a basic functionality for a query language .. Splunk, Kibana, SQL do it .. why can't Jira do it ?

              Unassigned Unassigned
              bc32e99a92d8 Svante Gustafsson Björkegren
              Votes:
              1 Vote for this issue
              Watchers:
              83 Start watching this issue

                Created:
                Updated:
                Resolved: