nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Table filter and Content Report Table is sorting strangely

Anders Kjöllerström_exlz9z

I'm trying to get a list of pages with descending sort order. I've identified that this is not possible in the native Content Report Table. So I've placed a content report inside a Table filter, sorting it on Title. This is the sort order I get:

Notice that it is not sorted by Title, Creator or Modified date.

In the tree structure these pages sort just fine, but only ascending as per default. So there should not be an issue with the ASCII.

What is going on here? I'm the space admin.

thanks Anders

Accepted answers

Katerina Kovriga {Stiltsoft}

Hi @Anders Kjöllerström ,

I've checked the Content Report Table macro in our test Server instance where its columns are sortable - the sorting goes exactly as described into your case: pages with plain names are sorted just fine, but Meeting notes are presented as they are in the Page Tree.

The Table Filter macro just catches the initial Confluence sorting and allows it to be set as a default one.

I can suggest using the following workaround for your case: wrap the Content Report Table macro into the Table Transformer macro and then into the Table Filter macro.

For Server and Data Center it can be done directly:

Fri 9-2.png And for Cloud via the Table Toolbox macro:

Fri 9-1.png

Then we go to the Table Transformer macro and split the Title column to get only dates from the Meeting notes pages:

Fri 9-3.png

SELECT T1.'Title'->split(" Meeting notes ")->0 AS 'Modified Title for Sorting',
T1.'Title', T1.'Creator', T1.'Modified'
FROM T1

Fri 9-4.png

Then we go to the Table Filter macro and set the default sorting for the new column:

Fri 9-5.png

Now our Meeting notes pages are sorted by dates correctly.

The last step is to hide our additional column: Filters -> Hide Columns and Filtration -> Set filters' default values:

Fri 9-6.png

Fri 9-7.png

Fri 9-8.png

Hope this works.

All comments

Katerina Kovriga {Stiltsoft}

Hi @Anders Kjöllerström ,

The Table Filter macro just catches the initial Confluence sorting and allows it to be set as a default one.

I can suggest using the following workaround for your case: wrap the Content Report Table macro into the Table Transformer macro and then into the Table Filter macro.

For Server and Data Center it can be done directly:

Fri 9-2.png And for Cloud via the Table Toolbox macro:

Fri 9-1.png

Then we go to the Table Transformer macro and split the Title column to get only dates from the Meeting notes pages:

Fri 9-3.png

SELECT T1.'Title'->split(" Meeting notes ")->0 AS 'Modified Title for Sorting',
T1.'Title', T1.'Creator', T1.'Modified'
FROM T1

Fri 9-4.png

Then we go to the Table Filter macro and set the default sorting for the new column:

Fri 9-5.png

Now our Meeting notes pages are sorted by dates correctly.

The last step is to hide our additional column: Filters -> Hide Columns and Filtration -> Set filters' default values:

Fri 9-6.png

Fri 9-7.png

Fri 9-8.png

Hope this works.

Alexander Bondarev_x6gjf3

@Katerina Kovriga _Stiltsoft_ , wow! I have to reproduce it! Thanks!

Anders Kjöllerström_exlz9z

@Katerina Kovriga _Stiltsoft_ Thank you so much!

Very helpful and easy to follow, even for a noob such as myself.

When I try, for some reason, the modified column only executes on some of the lines.

Some of the meeting notes pages were named programatically, some were named by typing manually. I cannot see that there is any difference in what and how characters are used. Could this be it?

I've assumed that the title is just a String, and that this could not affect the outcome...

Katerina Kovriga {Stiltsoft}

And will anything change if you delete the spaces from the query?

SELECT T1.'Title'->split(" Meeting notes ")->0 AS 'Modified Title for Sorting',
T1.'Title', T1.'Creator', T1.'Modified'
FROM T1

SELECT T1.'Title'->split("Meeting notes")->0 AS 'Modified Title for Sorting',
T1.'Title', T1.'Creator', T1.'Modified'
FROM T1

We'll see if the difference is in some invisible characters that differ from the regular spaces.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

cloud

confluence-cloud

report