The user is unable to filter issues in Jira by the fixed version in ascending order.

Rajesh January 10, 2025

The user is attempting to filter issues by fixed version and needs the result sorted in ascending order. However, after running the query, the result are not being filtered by the fixed version name in ascending order. Why is this happening.

 

project = ABC AND issuetype = Epic AND labels = 360digital AND assignee in ("1234567") ORDER BY fixVersion ASC

1 answer

0 votes
Steve Sauser
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
January 10, 2025

@Rajesh Versions are textual driven in Jira.  If your versions don't have a taxonomy to order them via numerical + textual, then the order using either ASC or DESC will use an Alpha ordering.  

Example: 

  • If your taxonomy is "Date + Textual" then your date will be the first portion of the ordering evaluation.  
    • 01/17/2025 - Text
    • 01/24/2025 - Text
      • These 2 would order in this same order as I listed above.  
    • Add a Version called "Textual Driven Version" and you would now see this order: 
      • 01/17/2025 - Text
      • 01/24/2025 - Text
      • Textual Driven Version

Release Date is not available in an issue JQL because the value of Release Date is not available to the issue directly; it is only contained within the Version itself.  

Screenshot demonstrating date + text mixed with just textual

image.png

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events