changeset 7667:a6363e080e2c

Order by years in SQ-relation datacage.
author Tom Gottfried <tom.gottfried@intevation.de>
date Fri, 06 Dec 2013 14:51:48 +0100
parents c36aae57ad43
children e0219f4079a8
files artifacts/doc/conf/meta-data.xml
diffstat 1 files changed, 1 insertions(+), 0 deletions(-) [+]
line wrap: on
line diff
--- a/artifacts/doc/conf/meta-data.xml	Fri Dec 06 14:27:03 2013 +0100
+++ b/artifacts/doc/conf/meta-data.xml	Fri Dec 06 14:51:48 2013 +0100
@@ -1922,6 +1922,7 @@
           JOIN sq_relation_value sqv ON sqv.sq_relation_id = sq.id
           JOIN measurement_station ms ON sqv.measurement_station_id = ms.id
           WHERE r.id = ${river_id}
+          ORDER BY start_time, stop_time
         </dc:statement>
         <dc:if test="dc:has-result()">
           <sq_relations>

http://dive4elements.wald.intevation.org