[CONFSERVER-39322] Page Properties Report sorting on column with Status Macro's is incorrect Created: 20/Sep/2015  Updated: 18/Oct/2018

Status: Gathering Impact
Project: Confluence Server
Component/s: Editor - Page / Comment Editor
Affects Version/s: 5.7.1, 6.2.0, 6.4.1
Fix Version/s: None

Type: Bug Priority: Low
Reporter: Maarten Cautreels (Digital Nomads) Assignee: Unassigned
Resolution: Unresolved Votes: 55
Labels: affects-server, editor, editor-macros, page-properties-report-macro
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Attachments: Zip Archive Confluence-space-export-111307-124.xml.zip     PNG File screenshot-actual.png     PNG File screenshot-expected.png    
Issue Links:
Part
is incorporated by CONFSERVER-42801 Umbrella Issue for Page Property and ... Closed
Symptom Severity: Severity 3 - Minor
UIS: 18
Support reference count: 6
Participants:
Last Touched By: SET Analytics Bot
Last commented: 1 week, 1 day ago

 Description   

Steps to Reproduce

  1. Create a page with a Page Properties Report
  2. Enable sorting for the Page Properties Report on a column which contains Status Macro's
    • Fe.: R | G | O | Y
  3. Enable "Reverse Sort"
    (See screenshot-actual.png)

Actual Result
The pages are sorted (propably on color instead of content) like this:

  1. Y
  2. O
  3. O
  4. O
  5. R
  6. R
  7. G
  8. G

Expected Result
I expect the pages to be sorted on the status in the following order:

  1. Y
  2. R
  3. R
  4. O
  5. O
  6. O
  7. G
  8. G

Note(s)
When I manually sort the table (by clicking the column header twice) I get the expected result. (See screenshot-expected.png)
I've included a space export so it's easier to reproduce.



 Comments   
Comment by Benn Ingersoll [ 26/May/2016 ]

I can confirm this issue affects version 5.9.7 as well.
A workaround used to be wrapping the Page Properties Report with a Table Plus macro (Bob Swift plugin) and doing the sorting within that macro, however, with the latest upgrade and the "generating page properties report..." message when a page loads, the Table Plus workaround no longer works. (Works when previewing the page, but when actually viewing it, it does not.)

Comment by Jameel Moses [ 09/Aug/2018 ]

Can confirm the same. Manually clicking the sort link on the column header sorts as expected, but not on page load even if Sort By includes the column header exactly

Comment by Thomas Sautelle [ 28/Sep/2018 ]

Still have this issue in confluence cloud

 

Comment by Ben McCoy [ 10/Oct/2018 ]

Confirmed that I have this issue in confluence cloud trying to sort on a numeric only ID field.

Generated at Thu Oct 18 06:14:14 UTC 2018 using Jira 7.13.0-m0003#713000-sha1:633a471f2aa3103167a647e64201095430fb1c30.