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

Page properties report doesn't sort by date properly

XMLWordPrintable

      NOTE: This bug report is for Confluence Server. Using Confluence Cloud? See the corresponding bug report.

      Summary

      Page properties report macro is not sorting DD/MM/YYYY in the proper order; that is, going by month year first, then month, then day. Instead, it is sorting in alpha-numeric order.

      Environment

      • Confluence
      • Page Properties Macros 4.3.1

      Steps to Reproduce

      1. Create a few pages with a table including a date in one column with typing //
      2. Add a common label to those pages.
      3. Create a new page with Page Properties Report Macro and include the date column

      Expected Results

      • With date format MM/DD/YYYY attempt to sort; should sort in logical order.

      Actual Results

      • In some cases, will sort alpha-numeric order instead.
      • In the original example, it was the simple DD MMM YYYY, however, I have also seen the issue only when switching browser language to German and allowing confluence to switch to German

        1. ConfDates.JPG
          12 kB
          Johannes Bach
        2. date_sort.png
          3 kB
          boleary
        3. image-2016-10-11-10-01-08-126.png
          7 kB
          Aaron Newton
        4. image-2016-10-11-10-01-43-148.png
          25 kB
          Aaron Newton
        5. image-2016-10-11-10-02-21-596.png
          30 kB
          Aaron Newton
        6. Macro_settings_Sort_column.png
          3 kB
          MarcelW
        7. my_page_properties_report.png
          7 kB
          MarcelW
        8. My_page_properties.png
          19 kB
          MarcelW
        9. screenshot-1.png
          3 kB
          Johannes Bach
        10. screenshot-2.png
          22 kB
          Aaron Newton
        11. sorted_dates_wrong.png
          23 kB
          MarcelW
        12. Sorting_by_arrows_ok.png
          20 kB
          MarcelW
        13. Sorting_work_around.png
          23 kB
          MarcelW
        14. string_dates_dont_sort.png
          7 kB
          MarcelW
        15. Testtable-sorted-english-user-profile.png
          44 kB
          Anne EQS
        16. Testtable-sorted-german-user-profile.png
          48 kB
          Anne EQS

          Form Name

            [CONFSERVER-33566] Page properties report doesn't sort by date properly

            Thomas Volpini added a comment -

            For everyone still hoping for a fix: I raised another issue which led to this new ticket: https://jira.atlassian.com/browse/CONFSERVER-60052

            Thomas Volpini added a comment - For everyone still hoping for a fix: I raised another issue which led to this new ticket: https://jira.atlassian.com/browse/CONFSERVER-60052

            Timen Nieuwhuis added a comment -

            A year later but the bug still isn't fixed on Confluence Server.
            The sorting goes wrong when the user has a the language set in the browser, in our case DUTCH.

            Timen Nieuwhuis added a comment - A year later but the bug still isn't fixed on Confluence Server. The sorting goes wrong when the user has a the language set in the browser, in our case DUTCH.

            Tim McGrath added a comment -

            Still doesn't work.

            Other similar bugs are open for Confluence Cloud and Server. Atlassian please address this.

            Tim McGrath added a comment - Still doesn't work. Other similar bugs are open for Confluence Cloud and Server. Atlassian please address this.
            Katherine Yabut made changes -
            Workflow Original: JAC Bug Workflow v3 [ 2903933 ] New: CONFSERVER Bug Workflow v4 [ 2998438 ]
            Owen made changes -
            Workflow Original: JAC Bug Workflow v2 [ 2780123 ] New: JAC Bug Workflow v3 [ 2903933 ]
            Status Original: Resolved [ 5 ] New: Closed [ 6 ]

            Michael Brooks added a comment -

            This is not resolved.  It's still a problem.  And, because it's marked resolved, we can't vote on it.  Please remove the resolved tag so we can vote this up.  It's a bug, and a big one, that needs to be fixed.

            Michael Brooks added a comment - This is not resolved.  It's still a problem.  And, because it's marked resolved, we can't vote on it.  Please remove the resolved tag so we can vote this up.  It's a bug, and a big one, that needs to be fixed.

            Joyce added a comment -

            +1 from Continental

            Bug still exists in 6.5.1, clearly not resolved!!!

            Joyce added a comment - +1 from Continental Bug still exists in 6.5.1, clearly not resolved!!!
            Owen made changes -
            Workflow Original: JAC Bug Workflow [ 2737316 ] New: JAC Bug Workflow v2 [ 2780123 ]
            Owen made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2390282 ] New: JAC Bug Workflow [ 2737316 ]

            Trevor Foley added a comment -

            This issue is still not solved; why are they resolved?

            Trevor Foley added a comment - This issue is still not solved; why are they resolved?

              ndang Nguyen Dang
              18c18c0fff23 boleary
              Affected customers:
              51 This affects my team
              Watchers:
              61 Start watching this issue

                Created:
                Updated:
                Resolved: