Sorting alphanumeric data in short text field

XMLWordPrintable

    • 2

      Update, 23 August 2024

      Hi everyone,

      Thank you for raising and voting on this suggestion. Your feedback is invaluable in shaping and enhancing Jira for all users. Given the high volume of feature suggestions for Jira, we must prioritize those that provide the most value to the majority of our users. After a thorough review by the team, we have decided that we will not be able to implement this suggestion in the immediate future.

      Please remember that jira.atlassian.com is only one of many inputs for our roadmap. We’re continuously learning, analyzing and interviewing customers to make Jira better. We encourage you to also share your feedback through Atlassian Community. Please also check out latest updates and upcoming plans from the Jira Cloud roadmap and the Atlassian Cloud release notes blog.

      We understand that our decision may be disappointing. Please don't hesitate to contact me if you have any questions or feedback.

      Regards,
      Matt Canham

      Product Manager, Jira Cloud

      Issue Summary

      This is reproducible on Data Center: (yes) / (no)

      When we are trying to sort the alphanumeric data in descending order in a short text field, the result of sorting is text-based.

      Meaning if we have two entries in the short text field- CZ-70022 and CZ-8122, and we sort them in descending order, we get the result where CZ-70022 comes after CZ-8122. It is because the system is performing the sorting character-wise, in which CZ-8 looks greater than CZ-7. Hence, CZ-70022 becomes after CZ-8122

      Steps to Reproduce

      1. Create a new custom field of type short text(AAII) or find the existing field of the same type
      2. Enter some alphanumeric data in the field like CZ-8122, CZ-70022, CZ-9922, CZ-0222, CZ-0122
      3. Run the JQL: order by created DESC

      Expected Results

      The system should sort data alphanumerically rather than sorting it character-wise/text-based.

      Actual Results

      Workaround

      Currently, there is no known workaround for this behavior. A workaround will be added here when available

            Assignee:
            Unassigned
            Reporter:
            Vijaita Gandhi (Inactive)
            Votes:
            2 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: