Page Properties Report Sort By not working in the way I expect

[Daisuke Yoshida]

Hi I am using Page Properties Report to display a list of releases we are working on. 

From the edit mode I set it as Order By SW Release Date, but it doesn't seem to apply the change as the item Jan 27 appears before Dec 6 2024. 

Could someone please help ? 

[Stiltsoft support]

Hi @Daisuke Yoshida ,

If it happens so that you have our app that is Table Filter, Charts & Spreadsheets for Confluence, you may sort your report using our Table Filter or Table Transformer macro.

The macros will recognize the date format that is used in the report and sort your data accordingly.

[Shawn Doyle - ReleaseTEAM]

Hi @Daisuke Yoshida 

I was not able to reproduce this on my instance.  I have been able to sort by date.  While it does look like you are using the built-in data function to assign the dates, can you share how you are adding the dates to the child pages?

[Daisuke Yoshida]

Hi Shawn,

It looks like this. It looks to me that if there SW Release Date is left blank then the order is not as expected. 

[Shawn Doyle - ReleaseTEAM]

I don't see any pattern of the date being sorted in your screenshots.  I agree it looks like if any page has the date blank the sort is being ignored.  I will test this on my instance, you may have found a bug.