Sort Page Property Report Alphabetically

[Lindsey]

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? 

[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]

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. 

[Samuel_Stinton]

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

[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]

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). 

[Lindsey]

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. 

[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