Sorting by date in the Page Properties Report

[thomasfogh]

This question is in reference to Atlassian Documentation: Page Properties Report Macro

I am using Page Properties Report for creating an overview on some start dates and due dates.

The problem is that when I click on eg. the "Due date" heading in the list/report to sort by Due date, then it seems to sort alphabetically and not by date - see the image below:

PageProperties_WrongSorting.png

As you can see it first sorts by number - 07 before 11, 11 before 25 etc. and then it looks at the name of the month. It does not make sense.

The dates are filled in the originating pages using the date picker "//" and we like that format.

BUT - How can I get sorting to work here? It should sort by the date value.

It is really hard getting an overview when dates are sorted alphabetically.

Thanks,

Thomas

[Panos]

Since this looks like cql, try using ORDER BY clause as per https://developer.atlassian.com/confdev/confluence-rest-api/advanced-searching-using-cql#AdvancedSearchingusingCQL-ORDERBY by editing the page source

[Charlie Deuter]

Broken Link.

[thomasfogh]

I am not a developer just a  regular user of the macro - so this was really a cry for help to the developer of the macro to fix the sorting on dates issue. Thanks, Thomas