Mercurial > dive4elements > river
comparison flys-artifacts/src/main/java/de/intevation/flys/artifacts/model/SQOverview.java @ 3287:30f157c7e466
SQ: Filter out meassures which don't have a 'Siebsatz'
flys-artifacts/trunk@4953 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
---|---|
date | Thu, 12 Jul 2012 13:58:30 +0000 |
parents | 4903e491992e |
children | ec9aab93f292 |
comparison
equal
deleted
inserted
replaced
3286:f062b5a90e26 | 3287:30f157c7e466 |
---|---|
89 "SELECT" + | 89 "SELECT" + |
90 " s.km AS km," + | 90 " s.km AS km," + |
91 " m.datum AS datum " + | 91 " m.datum AS datum " + |
92 "FROM messung m " + | 92 "FROM messung m " + |
93 " JOIN station s" + | 93 " JOIN station s" + |
94 " on m.stationid = s.stationid " + | 94 " ON m.stationid = s.stationid " + |
95 " JOIN gewaesser g " + | 95 " JOIN gewaesser g " + |
96 " on s.gewaesserid = g.gewaesserid " + | 96 " ON s.gewaesserid = g.gewaesserid " + |
97 "WHERE" + | 97 "WHERE" + |
98 " m.gsiebsatzid IS NOT NULL AND" + | |
98 " g.name = :name " + | 99 " g.name = :name " + |
99 " order by" + | 100 "ORDER by" + |
100 " s.km, m.datum"; | 101 " s.km, m.datum"; |
101 | 102 |
102 protected String riverName; | 103 protected String riverName; |
103 | 104 |
104 protected KMIndex<List<Date>> entries; | 105 protected KMIndex<List<Date>> entries; |
105 | 106 |