• Icon: Suggestion Suggestion
    • Resolution: Duplicate
    • 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.

      When using the query

      order by Sprint

      it shows me the following error:

      Field 'Sprint' does not support sorting.

      Can we allow sorting by sprint (taking into account the dates of sprint).

      Use case: you can create the "to do" list for users or specific user taking into account the sprint of the issues and not just priority of fix version.

            [JSWSERVER-7860] Allow ordering by sprint in Jira Search

            Another nail in the coffin for JIRA. This sort of amateurish design (followed by a complete lack of action) is dreadful.

            More helpfully, you need to check the customfield table to see what the correct ID is to use:

            select id from customfield where cfname = 'Sprint';
            

            e.g. this returned 10005 for us so we used customfield_100005. Many thanks Gregory!

            Adrian Bridgett added a comment - Another nail in the coffin for JIRA. This sort of amateurish design (followed by a complete lack of action) is dreadful. More helpfully, you need to check the customfield table to see what the correct ID is to use: select id from customfield where cfname = 'Sprint'; e.g. this returned 10005 for us so we used customfield_100005. Many thanks Gregory!

            Many thanks for reporting this issue. We see it as a valid feature request however we cannot provide any guidance at this time as to when, or if, we'll be implementing it.

            Regards,
            JIRA Agile Team

            Michael Tokar added a comment - Many thanks for reporting this issue. We see it as a valid feature request however we cannot provide any guidance at this time as to when, or if, we'll be implementing it. Regards, JIRA Agile Team

            Our team members and our clients have been asking us for this a few times - is this scheduled to be done any time soon?

            Thank you

            Nadia Tosheva added a comment - Our team members and our clients have been asking us for this a few times - is this scheduled to be done any time soon? Thank you

            Gregory Demotchkine added a comment - - edited

            Hi Jason, if you want a quick fix:
            I've solved this issue by creating a calculated field, which retrieves the sprint name or ID as you like it, and then you can order by your custom 'Calculated sprint'

            free addin:
            https://marketplace.atlassian.com/plugins/com.innovalog.jmcf.jira-misc-custom-fields

            Use a custom fied: Calculated Number Field

            in description enter the formula
            <!-- @@Formula: issue.get("customfield_10500").iterator().next().getId() -->

            Gregory Demotchkine added a comment - - edited Hi Jason, if you want a quick fix: I've solved this issue by creating a calculated field, which retrieves the sprint name or ID as you like it, and then you can order by your custom 'Calculated sprint' free addin: https://marketplace.atlassian.com/plugins/com.innovalog.jmcf.jira-misc-custom-fields Use a custom fied: Calculated Number Field in description enter the formula <!-- @@Formula: issue.get("customfield_10500").iterator().next().getId() -->

            Hi GreenHopper team,

            Do you know if this will be looked at in the upcoming releases?

            Deleted Account (Inactive) added a comment - Hi GreenHopper team, Do you know if this will be looked at in the upcoming releases?

            This is a major problem.
            We are using sprints as iterations. We really need to be able to sort by sprint, assignee

            Gregory Demotchkine added a comment - This is a major problem. We are using sprints as iterations. We really need to be able to sort by sprint, assignee

              Unassigned Unassigned
              63a7223e2adf Roman
              Votes:
              27 Vote for this issue
              Watchers:
              21 Start watching this issue

                Created:
                Updated:
                Resolved: