MLS Finance Statements Sorting by Date lexically, not correctly
Posted: Sun May 15, 2011 5:37 pm
MLS 3.3.1
When in MLS and viewing financial statements the sorting does not work properly. The sorting algorithm used appears to sort lexically (by the text of the date field) rather than by the actual date. This could be fixed either by using a proper date format (YYYY-MM-DD hh:mm:ss) or else by changing the sorting algorithm to treat the field as dates.
Steps to duplicate:
Finances: Finance Statements
Click on the Date column's header. Sorting happens showing dates like the following:
10 Apr 2011
10 Dec 2010
10 May 2010
10 May 2011
10 May 2011
1 2011
12 Jul 2009
......
9 Nov 2008
Clicking on the column a second time sorts in the reverse (and still incorrect) order. Because of this finding the latest financial statements (just did a Send/Receive and was notified that there were some) is fairly painful since it could require searching the entire list of years of reports.
When in MLS and viewing financial statements the sorting does not work properly. The sorting algorithm used appears to sort lexically (by the text of the date field) rather than by the actual date. This could be fixed either by using a proper date format (YYYY-MM-DD hh:mm:ss) or else by changing the sorting algorithm to treat the field as dates.
Steps to duplicate:
Finances: Finance Statements
Click on the Date column's header. Sorting happens showing dates like the following:
10 Apr 2011
10 Dec 2010
10 May 2010
10 May 2011
10 May 2011
1 2011
12 Jul 2009
......
9 Nov 2008
Clicking on the column a second time sorts in the reverse (and still incorrect) order. Because of this finding the latest financial statements (just did a Send/Receive and was notified that there were some) is fairly painful since it could require searching the entire list of years of reports.