How to sort the columns?

Alwin Bauer December 2, 2015

This question is in reference to Atlassian Documentation: Page Properties Report Macro

By default the macro sorts the columns in alphabetical order, but this is only rarely correct. How to sort the columns?

4 answers

1 vote
Andrey Khaneev _StiltSoft_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
May 18, 2018

You can use Table Filter macro to set default sorting: it works with Status macro as well and it is possible to sort on multiple columns at once.

1 vote
Anne EQS
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
January 27, 2016

Use the param 'Columns to show' (in the macro display options of the Page Properties Report macro) for sorting the order of the columns. When you add all the column headers in teh required order there, the table is displayed accordingly.

 

In your case specify:

Title, Curren status, Team, Deadline

or

Title, Team, Curren status, Deadline

Milo Grika June 5, 2017

Except for the Title column which still comes first regardless.

0 votes
Menno Bieringa May 18, 2018

Actually, this thing really doesn't seem to work.
Not with even with plain text content.

I'm using the Confluence Cloud version.
I've specified the columns explicitly, which works
I've specified the sorting column (which is 1 word, no spaces or anything tricky) but no love.

 

 

Wolfgang Hafenscher October 31, 2018

Also getting really frustrated with that. We are not able to sort by column "Status" on the initial page load (see sample image below for our configuration and table preview).

When clicking the headers afterwards, sorting works perfectly fine, just not on the initial page load. Which is really annoying as this page is supposed to give a quick overview of different pages sorted by state.

 

[Untitled].png

 

Edit: Seems to be an open bug since more than two years https://jira.atlassian.com/browse/CONFSERVER-39322
Please comment on the linked jira item to increase traction.

0 votes
Rachel Robins
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
December 7, 2015

Hi Alabaue, I'm not sure exactly what you are trying to sort, or the problem you're experiencing in your macro - but there are a few things to consider.  

There are two ways to sort columns in the Page Properties Report macro.  You can define a column to sort by (in the macro's Sort by field), and sort this ascending or descending (using the Reverse sort checkbox) - this sets the default sort when the page is displayed, or you can sort the macro by clicking the column headings. 

If the Page Properties Report macro is showing 10 items from a possible 15, clicking the column headings to sort the columns will only sort the 10 items that are visible, not all returned items. 

If you want to be able to sort by a date column, using date lozenges in your pages will mean your dates sort correctly (type // to trigger the date picker). 

Hope this helps

 

Alwin Bauer December 7, 2015

Hi Rachel, I would like to sort the columns in the table. In the example, shown in the documentation, it is 'Title' (given as the first column), 'Curren status', 'Deadline', 'Team'. How do you do it, when you need it in the order: 'Title' (given as the first column), 'Curren status', 'Team', 'Deadline' or 'Title' (given as the first column), 'Team', 'Curren status', 'Deadline' Thank you for your inputs.

Rachel Robins
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
December 8, 2015

Ah, unfortunately the macro doesn't allow you to define multiple columns to sort by - just one.

Dominik Meinhold September 13, 2018

Awesome, thanks for the tip!

 

It might be worth it to add this to the help page.

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events