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

            [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.

            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!!!

            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?

            Liesa Bernauer added a comment -

            The format while adding the date using the date picker and the rendering on the page afterwards are two different things. 

            The rendering depends on the language the user has configured in his browser (as it is simply a html5 time tag).

            I think there is no config option for the input format but I am not sure about that.

             

            Liesa Bernauer added a comment - The format while adding the date using the date picker and the rendering on the page afterwards are two different things.  The rendering depends on the language the user has configured in his browser (as it is simply a html5 time tag). I think there is no config option for the input format but I am not sure about that.  

            Scott Stephens added a comment -

            Yes how can we configure the date format when using the // to call the insert.  

            Scott Stephens added a comment - Yes how can we configure the date format when using the // to call the insert.  

            Aaron Newton added a comment -

            Forgive me if this is covered elsewhere (I tried to search for the answer here), but how can one specify the format for the date macro? Mine are showing up as:

             

            But my preferences in Confluence are 

             

            and

            Mostly it's annoying when creating a date, as in the US we type in MM/DD/YYYY, and the // widget wants you to type in //DD/MM/YYYY and so it's easy to produce an error.

            Aaron Newton added a comment - Forgive me if this is covered elsewhere (I tried to search for the answer here), but how can one specify the format for the date macro? Mine are showing up as:   But my preferences in Confluence are    and Mostly it's annoying when creating a date, as in the US we type in MM/DD/YYYY, and the // widget wants you to type in //DD/MM/YYYY and so it's easy to produce an error.

            Aaron Newton added a comment -

            No! I went into the "insert more content" menu looking for some sort of date type but couldn't find one. Didn't know about //. Thanks! Might consider adding that somewhere in the editor's UI (even if it's in a menu or something).

            Aaron Newton added a comment - No! I went into the "insert more content" menu looking for some sort of date type but couldn't find one. Didn't know about //. Thanks! Might consider adding that somewhere in the editor's UI (even if it's in a menu or something).

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

                Created:
                Updated:
                Resolved: