Sort Page Property Report Alphabetically

Lindsey April 26, 2022

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

4 answers

3 votes
Katerina Rudkovskaya [Stiltsoft]
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
April 27, 2022

Hi @Lindsey,

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

2022-04-27_15h57_10.png

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 March 8, 2023

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. 

1 vote
Samuel_Stinton October 10, 2023

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

0 votes
Ariel Xu March 7, 2023

@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 March 13, 2023

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

0 votes
Lindsey April 27, 2022

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]
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
April 28, 2022

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'

2022-04-28_17h47_05.png2022-04-28_17h46_42.png2022-04-28_17h46_58.png

Katerina

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events