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,463,430
Community Members
 
Community Events
176
Community Groups

Table not sorting correctly for multiple words

I have a table of people in my company with the following columns: First Name, Last Name, Title, Reports To, and Location. The columns with a single word, like First Name and Last Name sort fine. But the columns with multiple words only sort on the first word, and then they appear to be ordered by first name after that. If I sort on Title, for example, "Chief Commercial Officer" (Kane) comes before "Chief Architect" (Peter), and the titles "Customer Success Manager" (Daniel), "Customer Support Associate" (Marcus), and "Customer Success Specialist" (Zechariah) appear in that order. The first names in my examples above are not actual data in the Title column. I am just including it here so you can see the conclusion I have drawn about how I think the sort is actually working. Similarly, under Location, we have a bunch of Remote folks who are listed as "Remote - PA", "Remote - CA", "Remote - WA", "Remote - TX", etc. That is the order the first 4 appear in when I sort on the Location column. It is correctly sorting all of the remote folks after Boston and before San Diego, but where they are within Remote is not correct. I have multiple folks in "Remote - CA" for example, and they do not appear together. Within the block of folks who have "Remote" as the first word in the Location column, however, everyone is sorted by their first name. I think this is a bug, but I don't know if I'm doing something wrong, or if anyone else has experienced similar behavior in a Confluence table.

1 answer

1 accepted

0 votes
Answer accepted
Andy Gladstone Community Leader Mar 21, 2022

@Diane Kramer this does seem to be a bug and is likely the result of the methodology that Atlassian is applying when sorting items alphabetical order which assumes a space is the end of the sort term. 

I looked in https://jira.atlassian.com/browse/CONFCLOUD to see if this bug has been reported and do not see any mention of it - I recommend you report it there.

Thank you, @Andy Gladstone, I reported the bug to Atlassian.

Any news on this? I looked at jira.atlassian.com but can't seem to find the report.

Edit: found it at https://jira.atlassian.com/browse/CONFCLOUD-73756

Suggest an answer

Log in or Sign up to answer
TAGS

Atlassian Community Events