-
Bug
-
Resolution: Fixed
-
Low
-
5.8.4, 5.9.1, 5.10.4, 6.14.1, 6.14.2, 6.14.3, 6.15.4, 6.15.6, 6.15.7, 7.2.1, 7.4.6, 7.9.3
-
17
-
Severity 3 - Minor
-
22
-
NOTE: This bug report is for Confluence Server. Using Confluence Cloud? See the corresponding bug report.
Summary
Dates are not sorted correctly when user is on European browser (such as Deutsch).
Environment
Tested in:
- Confluence server 6.15.6
Steps to Reproduce
- Make sure that browser is on English language
- Create a page with random dates in a table
- Save, and try to sort it
- Tables are sorted correctly
- Go to user profile > setting > edit > set language as Deutsch
- Go back to the page > try to sort the dates
Expected Results
Dates are sorted correctly
Actual Results
Dates are not sorted correctly. In fact, it's sorted in a random way. see f0S76Dx2jG.gif
Notes
This issue is different than CONF-34002 since CONF-34002 is an improvement request for dates to be able to be sorted.
Date sorting feature doesn't sort plain text dates since plain text dates could be ambiguous to users with different system & profile locales.
- causes
-
-
- Closed
-
-
PSR-702 Loading...
- is cloned from
-
CONFSERVER-34002 Dates aren't sorted correctly
- Closed
- is duplicated by
-
-
- Closed
-
-
-
- Closed
-
- is related to
-
-
- Closed
-
- relates to
-
-
- Closed
-
-
-
- Closed
-
-
- Closed
-
- Gathering Interest
-
- Gathering Interest
-
[CONFSERVER-38083] Dates aren't sorted correctly in European time format (dd.mm.yyyy)
Hi Zac Xu,
at the moment we are using confluence 7.14.1 and languagesettings on german.
Table1: If we create tables and fill dates with the datepicker we cant sort any column from the table.
Table2: If we fill in the date manual in the digitalformat "day.month.year" the sort function is completely wrong.
Table1:
<p class="auto-cursor-target"><br /></p> <table><colgroup><col /><col /></colgroup> <tbody> <tr> <th scope="col">date</th> <th scope="col">order</th></tr> <tr> <td> <div class="content-wrapper"> <p><time datetime="2022-01-01" /> </p></div></td> <td>1</td></tr> <tr> <td> <div class="content-wrapper"> <p><time datetime="2022-01-31" /> </p></div></td> <td>3</td></tr> <tr> <td> <div class="content-wrapper"> <p><time datetime="2022-01-13" /> </p></div></td> <td>2</td></tr> <tr> <td> <div class="content-wrapper"> <p><time datetime="2022-02-03" /> </p></div></td> <td>5</td></tr> <tr> <td> <div class="content-wrapper"> <p><time datetime="2022-02-01" /> </p></div></td> <td>4</td></tr> <tr> <td> <div class="content-wrapper"> <p><time datetime="2022-03-10" /> </p></div></td> <td>7</td></tr> <tr> <td> <div class="content-wrapper"> <p><time datetime="2022-02-17" /> </p></div></td> <td>6</td></tr> <tr> <td><br /></td> <td><br /></td></tr> <tr> <td><br /></td> <td><br /></td></tr> <tr> <td><br /></td> <td><br /></td></tr> <tr> <td><br /></td> <td><br /></td></tr> <tr> <td><br /></td> <td><br /></td></tr> <tr> <td><br /></td> <td><br /></td></tr></tbody></table> <p class="auto-cursor-target"><br /></p>
Table2
<p class="auto-cursor-target"><br /></p> <table><colgroup><col /><col /></colgroup> <tbody> <tr> <th scope="col">date</th> <th scope="col">order</th></tr> <tr> <td>01.01.2021</td> <td>1</td></tr> <tr> <td>31.01.2021</td> <td>3</td></tr> <tr> <td>02.02.2021</td> <td>4</td></tr> <tr> <td>27.03.2021</td> <td>6</td></tr> <tr> <td>09.02.2021</td> <td>5</td></tr> <tr> <td>08.01.2021</td> <td>2</td></tr> <tr> <td><br /></td> <td><br /></td></tr> <tr> <td><br /></td> <td><br /></td></tr> <tr> <td><br /></td> <td><br /></td></tr> <tr> <td><br /></td> <td><br /></td></tr> <tr> <td><br /></td> <td><br /></td></tr> <tr> <td><br /></td> <td><br /></td></tr> <tr> <td><br /></td> <td><br /></td></tr> <tr> <td><br /></td> <td><br /></td></tr> <tr> <td><br /></td> <td><br /></td></tr> <tr> <td><br /></td> <td><br /></td></tr> <tr> <td><br /></td> <td><br /></td></tr></tbody></table> <p class="auto-cursor-target"><br /></p>
Hi it1829750478 ,
Your screenshots seems not uploaded. Could you please create a sample page and upload its storage format so that we could reproduce this issue in order to fix it.
Cheers,
Hi de8df2978224
Could you please create a sample page and upload its storage format so that we could reproduce this issue in order to fix it.
Cheers,
Zac
Hi 1807a2aba4e6 ,
When you mentioned dynamic "page-report" , are you referring to "page properties report"?
I tested page properties report on my side and cannot reproduce this issue.
Could you please create a support request with more information like how we could reproduce this issue so we could investigate further. Thanks.
Best regards,
Zac
Confluence 7.15.0 on Windows Server
Yep, weird, at some point I thought it was fixed as some tables DO sort correctly, but others....
What seems to work are tables that are created statically in a Confluence page.
Page-report tables seem to fail, at least I I quickly checked again. The code is more or less the same, e.g. like
<span hd-id="0" hd-pid="97613588" hd-pv="51"><time datetime="2022-01-13" class="date-past handy-date-time"><input type="text" class="handy-date-input"><span class="handy-date-value">13 Jan 2022</span></time></span>
A bit useless as I mostly use dynamic tables and need to sort by soon-expiry dates, etc.....very very annoying
Wont work for us on 7.14.1.
Neither English (US) nor Deutsch, we cant sort anything. The sort function is not working for the whole table if we add dates with datepicker. Both columns arent sortable.
Language: English (US)
Language: Deutsch
A fix for this issue is available to Server and Data Center customers in Confluence 7.13.1
Upgrade now or check out the Release Notes to see what other issues are resolved.
>At least they "managed" to put it to the "short" term backlog.
Only for Confluence server, a soon-to-be EOL product... 🤦♂️
Hi it1829750478 ,
For table 1, empty cell sorting bug was known and fixed in 7.14.2, you could find more detail on ticket: https://jira.atlassian.com/browse/CONFSERVER-74697
For table 2, the date sorting feature was implemented against consistent datetime attributes in semantic <time> tags like
<time datetime="2022-02-17">Users could insert it by using datepicker in editor. Plain text is sorted alphabetically. We don't parse plain text dates because it's ambiguous to users with different system and profile locales settings.
Cheers,
Zac