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,369,959
Community Members
 
Community Events
168
Community Groups

Can you keep a sort on a column for a table?

Using the up/down arrows to sort on a column but the sort won't "keep" - any suggestions? 

4 answers

10 votes
Deleted user Mar 15, 2021

It's nuts that saving a sorted table requires a paid add-in, how is this not a normal table setting?

Hi Lorraine,

Table Filter macro can do the trick.  There are two approaches:

  1. You can sort the table wrapped with Table Filter macro in page edit mode by Ctrl+Click on table heading. After you save the page, the applied sorting order will be saved. But each time you add new rows to the table you'll need to resort the table again.
  2. Or you can set default sorting order in the Table Filter macro. In this case you will always see correctly sorted table.

@Lorraine Horine I literally just purchased this macro for the exact same reasons. The Table Filter macro works a charm for us -- one of the biggest gripes people had with Confluence tables was the sorting in both view and edit modes. Table Filter makes it easier to do this -- you can only sort by one column, but it is miles better than the lack of sorting present by default.

Plus there are plenty of other neat features like being able to add filters onto the table in view mode and export in PDF.

Tip: hold SHIFT button while clicking table headings to sort by multiple columns.

Like # people like this

@Andrey Khaneev _StiltSoft_ many thanks -- this will help a lot :)

Like # people like this

Thanks for this post.  The Table Filter macro is great.  :)

Like # people like this

It's a bit hacky, but you can sort the table how you want in view-mode, copy the rows, then edit the page and paste them into the table. Saving this will set the table's default sort.

0 votes
weweave UG Marketplace Partner Apr 18, 2020

We would like to let you know that we developed the app "DataTables for Confluence" (see https://marketplace.atlassian.com/apps/1220302/datatables-for-confluence) for Confluence Cloud which supports table state saving, i.e. filtering, paging and sorting is automatically restored when the user reloads the page. The app also supports filtering tables by multiple columns (see https://weweave.net/blog/datatables-for-confluence-supports-multi-column-table-sorting/).

Suggest an answer

Log in or Sign up to answer
TAGS

Atlassian Community Events