Uploaded image for project: 'Confluence Data Center'
  1. Confluence Data Center
  2. CONFSERVER-39322

Page Properties Report sorting on column with Status Macro's is incorrect

      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.

            [CONFSERVER-39322] Page Properties Report sorting on column with Status Macro's is incorrect

            It has been 3 years since this has been open, please fix this

            Madeline Rosenberg added a comment - It has been 3 years since this has been open, please fix this

            This was "In Progress" and now "Short Term Backlog"? Why?

            Roberto Martignano added a comment - This was "In Progress" and now "Short Term Backlog"? Why?

            It seems that in general the sorting does not really work as expected if the column to be sorted contains macros. CONFSERVER-32353 has been reported for this earlier, but was closed due to "more important issues".

            I can confirm that sorting does not work at all for columns using the "user profile macro" (https://confluence.atlassian.com/conf73/user-profile-macro-991928241.html) in Confluence version 7.3.5. But a click on the column heading on the rendered page does sort correctly. So obviously the page properties report macro has its own sorting logic which is just not correct.

            svenackermann added a comment - It seems that in general the sorting does not really work as expected if the column to be sorted contains macros.  CONFSERVER-32353 has been reported for this earlier, but was closed due to "more important issues". I can confirm that sorting does not work at all for columns using the "user profile macro" ( https://confluence.atlassian.com/conf73/user-profile-macro-991928241.html ) in Confluence version 7.3.5. But a click on the column heading on the rendered page does sort correctly. So obviously the page properties report macro has its own sorting logic which is just not correct.

            Please fix this. This is causing quite severe usability issues for some of our workflows.

            Pieter Smith added a comment - Please fix this. This is causing quite severe usability issues for some of our workflows.

            Metod Kana added a comment -

            sorting doesn't work at all! i created a new property just for sorting and confluence doesn't even manage to sort by number...

            Metod Kana added a comment - sorting doesn't work at all! i created a new property just for sorting and confluence doesn't even manage to sort by number...

            Anton added a comment -

            Please, increase the priority.

            Anton added a comment - Please, increase the priority.

            Stefan added a comment -

            Got the exact same issue. Please fix! 

            Stefan added a comment - Got the exact same issue. Please fix! 

            Rose Wells added a comment -

            Will there be any traction on this issue soon? The default sort not working properly is very annoying

            Rose Wells added a comment - Will there be any traction on this issue soon? The default sort not working properly is very annoying

            I'd like to have default sort by status column as well, but it is not working. Only manual sort.

            Michał Kuczkowski added a comment - I'd like to have default sort by status column as well, but it is not working. Only manual sort.

            Tony added a comment -

            I have the same issue, would be very helpful to have a fix.

            Tony added a comment - I have the same issue, would be very helpful to have a fix.

              aknight@atlassian.com Alex K
              33acf969ce41 Maarten Cautreels
              Affected customers:
              116 This affects my team
              Watchers:
              75 Start watching this issue

                Created:
                Updated: