SF.net SVN: ledger-smb:[5836] branches/1.3

[..hidden..]

Revision: 5836
          http://sourceforge.net/p/ledger-smb/code/5836
Author:   einhverfr
Date:     2013-05-20 08:24:19 +0000 (Mon, 20 May 2013)
Log Message:
-----------
Adding secondary ordering for eca history to make it easier to read.

Modified Paths:
--------------
    branches/1.3/Changelog
    branches/1.3/sql/modules/Company.sql

Modified: branches/1.3/Changelog
===================================================================
--- branches/1.3/Changelog	2013-05-20 08:04:02 UTC (rev 5835)
+++ branches/1.3/Changelog	2013-05-20 08:24:19 UTC (rev 5836)
@@ -12,6 +12,7 @@
 * Project, serial number, and notes now appear initially (Chris T, 824)
 * Fixed double-counting first date's balance on gl report (Chris T)
 * Fixed user creation failing on some timezones with some datestyles (Chris T)
+* Added secondary partnumber ordering to eca history report (Chris T)
 
 Changelog for 1.3.32
 * Fixed em-dash handling for pdfs (Chris T)

Modified: branches/1.3/sql/modules/Company.sql
===================================================================
--- branches/1.3/sql/modules/Company.sql	2013-05-20 08:04:02 UTC (rev 5835)
+++ branches/1.3/sql/modules/Company.sql	2013-05-20 08:24:19 UTC (rev 5836)
@@ -168,7 +168,7 @@
           and (a.transdate <= $12 or $12 is null)
           and (eca.startdate >= $14 or $14 is null)
           and (eca.startdate <= $15 or $15 is null)
- ORDER BY eca.meta_number;
+ ORDER BY eca.meta_number, p.partnumber;
 $$ LANGUAGE SQL;
 
 COMMENT ON FUNCTION eca_history

This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.