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; } } }

Sort Page Property Report Alphabetically

Lindsey_zl6ccn

I see a lot of questions with people complaining Page Property Macro is sorting alphabetically, but that's exactly what I want. It is sorted by "most recently updated".

I would like to see this report sorted by this first column in Alphabetical Order.

How is this possible?

Screen Shot 2022-04-26 at 9.02.06 AM.png

Accepted answers

All comments

Katerina Rudkovskaya _Stiltsoft_

Hi @Lindsey,

You can switch to the edit page mode and do it in a Page Properties Report macro browser:

Please notice that you can also try the Table Filter and Charts for Confluence app that helps to filter table data, summarize them and visualize with dynamically updated charts and much more.

BR,
Katerina

Lindsey_zl6ccn

Hello,

That is how I have it set up, but if I make an edit to one of the pages it will always put that one on top.

I want to keep it in alphabetical order, no matter the changes to the information, so that solution doesn't work.

Screen Shot 2022-04-27 at 8.38.41 AM.png

Katerina Rudkovskaya _Stiltsoft_

I cannot reproduce the issue. It seems that you've faced a bug.
You can try to contact Atlassian Support.

For now, using Table Transformer of the Table Filter and Charts app you can enter the following SQL query and it will sort the table correctly:

SELECT T1.'Title',T1.'Status',T1.'Task'
FROM T*
ORDER BY T1.'Title'

Katerina

Ariel Xu

@Lindsey Did you end up figuring out how to prevent displaying by last edited? I'm also still running into the issue which prevents the list from staying in alphabetical order.

Lindsey_zl6ccn

Nope. I was told to put in a bug ticket with Atlassian, but only our IT team can do that, so it died there. Then our company abandoned this reporting method so it didn't matter in the end.

Lindsey_zl6ccn

No, I never was able to get it to work. I was told to put in a support ticket through atlassian, but that has to go through our IT.

We ended up going in another direction, so it was abandoned and became not an issue (though unresolved).

Sam Stinton_x73psj

Just found a fix for this, rather than using the "renamed" title field, use Title to sort and it works:

Screenshot 2023-10-10 154704.png

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

page-property

page-properties-report