Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Celebration

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,560,523
Community Members
 
Community Events
185
Community Groups

Severity Fields in a Project don't Sort Correctly

We have n number of issues in a project and we are using JQL to get the issues in order but 

we are getting like 

Ticket number  Severity

Ep-01                 s2

Ep-02                 S1

Ep-03                  s3 like this

2 answers

1 accepted

1 vote
Answer accepted
Trudy Claspill
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
Apr 05, 2023

Hello @Manoj Dasari 

What type of field is the Severity field?

Its a Select list (Single choice)

Trudy Claspill
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
Apr 06, 2023

If Severity is the one and only field declared in your ORDER BY clause, it appears that the issues will be sorted based on the order of the options in the Context definition, with DESC being from the bottom of the list options to the top, and ASC being from the top of the list options to the bottom.

The ORDER BY clause will not cause the results to be sorted based on an alphabetic sorting of the list option values.

Compare the images below.

The first one shows the Context definition order of the list options along side an issue search that is ordering the issues by that field.Screen Shot 2023-04-06 at 11.34.53 PM.png

 

In the second image I have change the order of the options in the Context definition and re-executed the search. The order of the search results has changed to match the order of the the options in the Context definition.

Screen Shot 2023-04-06 at 11.36.14 PM.png

1 vote
Nic Brough -Adaptavist-
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
Apr 05, 2023

Welcome to the Atlassian Community!

What is the "order by" clause in your JQL?

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
PERMISSIONS LEVEL
Site Admin
TAGS
AUG Leaders

Atlassian Community Events