Uploaded image for project: 'Confluence Cloud'
  1. Confluence Cloud
  2. CONFCLOUD-33566

Page properties report doesn't sort by date properly

XMLWordPrintable

      NOTE: This bug report is for Confluence Cloud. Using Confluence Server? 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. date_sort.png
          date_sort.png
          3 kB
        2. Testtable-sorted-german-user-profile.png
          Testtable-sorted-german-user-profile.png
          48 kB
        3. Testtable-sorted-english-user-profile.png
          Testtable-sorted-english-user-profile.png
          44 kB
        4. Macro_settings_Sort_column.png
          Macro_settings_Sort_column.png
          3 kB
        5. sorted_dates_wrong.png
          sorted_dates_wrong.png
          23 kB
        6. Sorting_by_arrows_ok.png
          Sorting_by_arrows_ok.png
          20 kB
        7. string_dates_dont_sort.png
          string_dates_dont_sort.png
          7 kB
        8. Sorting_work_around.png
          Sorting_work_around.png
          23 kB
        9. My_page_properties.png
          My_page_properties.png
          19 kB
        10. my_page_properties_report.png
          my_page_properties_report.png
          7 kB
        11. screenshot-1.png
          screenshot-1.png
          3 kB
        12. ConfDates.JPG
          ConfDates.JPG
          12 kB
        13. screenshot-2.png
          screenshot-2.png
          22 kB
        14. image-2016-10-11-10-01-08-126.png
          image-2016-10-11-10-01-08-126.png
          7 kB
        15. image-2016-10-11-10-01-43-148.png
          image-2016-10-11-10-01-43-148.png
          25 kB
        16. image-2016-10-11-10-02-21-596.png
          image-2016-10-11-10-02-21-596.png
          30 kB

              ndang Nguyen Dang
              18c18c0fff23 boleary
              Votes:
              51 Vote for this issue
              Watchers:
              47 Start watching this issue

                Created:
                Updated:
                Resolved: