• Type: Bug
• Resolution: Fixed
• Priority: Medium
• Fix Version/s: 5.10.4, 1000.245.0
• Affects Version/s: 5.5, 5.9.0-OD-55, 5.10
• Component/s: Editor - Page / Comment Editor
• Labels:

  • Macros-Page-Properties-Page-Properties-Report
  • affects-cloud
  • affects-server
  • editor
  • editor-macros
  • page-properties-report-macro
  • tables
  • team-galaxy
• Environment:

  Confluence OnDemand

1. 

   date_sort.png

   3 kB

   06/May/2014 2:53 PM

2. 

   Testtable-sorted-german-user-profile.png

   48 kB

   12/Jan/2016 4:01 PM

3. 

   Testtable-sorted-english-user-profile.png

   44 kB

   12/Jan/2016 4:01 PM

4. 

   Macro_settings_Sort_column.png

   3 kB

   21/Mar/2016 7:21 PM

5. 

   sorted_dates_wrong.png

   23 kB

   21/Mar/2016 7:23 PM

6. 

   Sorting_by_arrows_ok.png

   20 kB

   21/Mar/2016 7:25 PM

7. 

   string_dates_dont_sort.png

   7 kB

   22/Mar/2016 2:02 PM

8. 

   Sorting_work_around.png

   23 kB

   05/Apr/2016 6:34 PM

9. 

   My_page_properties.png

   19 kB

   06/Apr/2016 2:47 PM

10. 

    my_page_properties_report.png

    7 kB

    06/Apr/2016 2:51 PM

11. 

    screenshot-1.png

    3 kB

    07/Jul/2016 8:47 AM

12. 

    ConfDates.JPG

    12 kB

    07/Jul/2016 8:52 AM

13. 

    screenshot-2.png

    22 kB

    10/Oct/2016 10:00 PM

14. 

    image-2016-10-11-10-01-08-126.png

    7 kB

    11/Oct/2016 5:01 PM

15. 

    image-2016-10-11-10-01-43-148.png

    25 kB

    11/Oct/2016 5:01 PM

16. 

    image-2016-10-11-10-02-21-596.png

    30 kB

    11/Oct/2016 5:02 PM

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

Katherine Yabut made changes - 13/Nov/2018 4:46 AM

Workflow

Original: JAC Bug Workflow v3 [ 2903933 ]

New: CONFSERVER Bug Workflow v4 [ 2998438 ]

Owen made changes - 11/Oct/2018 9:10 AM

Workflow	Original: JAC Bug Workflow v2 [ 2780123 ]	New: JAC Bug Workflow v3 [ 2903933 ]
Status	Original: Resolved [ 5 ]	New: Closed [ 6 ]

Owen made changes - 29/Aug/2018 11:13 PM

Workflow

Original: JAC Bug Workflow [ 2737316 ]

New: JAC Bug Workflow v2 [ 2780123 ]

Owen made changes - 02/Jul/2018 7:16 AM

Workflow

Original: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2390282 ]

New: JAC Bug Workflow [ 2737316 ]

Katherine Yabut made changes - 22/Jun/2017 6:50 AM

Workflow

Original: Confluence Workflow - Public Facing - Restricted v5 [ 2269195 ]

New: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2390282 ]

Katherine Yabut made changes - 31/May/2017 5:32 AM

Workflow

Original: Confluence Workflow - Public Facing - Restricted v5.1 - TEMP [ 2215199 ]

New: Confluence Workflow - Public Facing - Restricted v5 [ 2269195 ]

Katherine Yabut made changes - 31/May/2017 4:55 AM

Workflow

Original: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2166024 ]

New: Confluence Workflow - Public Facing - Restricted v5.1 - TEMP [ 2215199 ]

Katherine Yabut made changes - 31/May/2017 1:58 AM

Workflow

Original: Confluence Workflow - Public Facing - Restricted v5 [ 1923072 ]

New: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2166024 ]

Katherine Yabut made changes - 03/Apr/2017 3:57 AM

Workflow

Original: Confluence Workflow - Public Facing - Restricted v3 [ 1725847 ]

New: Confluence Workflow - Public Facing - Restricted v5 [ 1923072 ]

jonah (Inactive) made changes - 02/Apr/2017 8:31 AM

Description

Original: h3. 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. !date_sort.png! h3. Environment * Confluence * Page Properties Macros 4.3.1 h3. Steps to Reproduce # Create a few pages with a table including a date in one column with typing {{//}} # Add a common label to those pages. # Create a new page with Page Properties Report Macro and include the date column h3. Expected Results - With date format MM/DD/YYYY attempt to sort; should sort in logical order. h3. 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

New: {panel:bgColor=#e7f4fa}   *NOTE:* This bug report is for *Confluence Server*. Using *Confluence Cloud*? [See the corresponding bug report|http://jira.atlassian.com/browse/CONFCLOUD-33566].   {panel} h3. 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. !date_sort.png! h3. Environment * Confluence * Page Properties Macros 4.3.1 h3. Steps to Reproduce # Create a few pages with a table including a date in one column with typing {{//}} # Add a common label to those pages. # Create a new page with Page Properties Report Macro and include the date column h3. Expected Results - With date format MM/DD/YYYY attempt to sort; should sort in logical order. h3. 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

Load more older history items