You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
One of my users built a JQL where the order is by assignee ASC.
Ex.: project = ABC ORDER BY assignee ASC
The results are showing names in this order:
Why is Adam showing up before Ada?
My explanation is that Jira uses each letter sequentially regardless if it’s part of the first name or last name.
In this case, M comes before T.
Can anyone confirm my theory?
I hypothesize when the JQL has an ORDER BY assignee ASC it is ordering by the user's account ID value and not on the user's display name.
You could confirm that by including more users in your search (to have more data) and then identifying their account ID values to check the sorting.
One quick way to find the account ID values is using JQL...
Thanks for sharing :)
Aren't account IDs a random chain of characters that are not necessarily sequential? Even then, there would still be a logic to order results.
How would the system order tickets from these users?
We get plenty of data (assignees) when generating our JQL since it calls all tickets in the project and we didn't see anything that would give us a clue as there are no users with similar first names like these 2 users.
Let's see if someone else has a hypothesis.