Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Deleted user
Level
0 / 0 points
Next:
badges earned

Your Points Tracker
Challenges
Leaderboard
  • Global
  • Feed

Badge for your thoughts?

You're enrolled in our new beta rewards program. Join our group to get the inside scoop and share your feedback.

Join group
Recognition
Give the gift of kudos
You have 0 kudos available to give
Who do you want to recognize?
Why do you want to recognize them?
Kudos
Great job appreciating your peers!
Check back soon to give more kudos.

Past Kudos Given
No kudos given
You haven't given any kudos yet. Share the love above and you'll see it here.

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

How do we do multiple sorting in JIRA issue navigator?

I'm trying to sort data in the issue navigator based on minimum three fields, just using column headers and not via Advanced Search.

If I click on the column headers one by one, the order I do that (sorting) gets changed.

3 answers

1 accepted

4 votes
Answer accepted

Click on the headers you want in the reverse order.

ie if you want headers A then B then C

click on

C then B then A.

Simples ;)

I believe this can be done with JQL only. Switch to the Advanced view and you'll see your query's JQL. Modify or add ORDER BY clause as described in the JQL documentation - e.g. "order by created, priority desc"

Thanks and I understand that this works. But one of our clients is very particular that they don't want to use the Advanced search option.

Tried this on a trial and error basis: Switch to Advanced searching, tried clicking on the headers of various columns.

My requirement was to order the results by reporter first, then by assignee and finally 'Due date'. If I click on the headers in this sequence my JQL Query shows 'ORDER BY due DESC, assignee ASC, reporter ASC'; So, I do my sequence just opposite to my requirement and it works. Not sure whether there is any other way to do my sorting - Sort by A, then by B and finally by C.

Like Maysarah Abu-Laban likes this

Use this 

ORDER BY due DESC, assignee  ASC, reporter ASC
Like # people like this

Hi @Maysarah Abu-Laban

What if I want different statuses to have different order on one board, this one did not work in filter:

ORDER BY status ("DONE", "In Progress") ASC, status ("TODO", "Released") DESC

what is wrong here?

Thank you a lot!

cannot be done this way

Hi! This does not work for the case of:

  • ORDER BY duedate ASC, Rank ASC

as I get the error about ranking

Screenshot from 2021-04-05 14-09-07.png

Has anyone else had the same?

Use this 

ORDER BY due DESC, assignee  ASC, reporter ASC

Suggest an answer

Log in or Sign up to answer
TAGS

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you