Mercurial > dive4elements > river
diff flys-artifacts/src/main/java/de/intevation/flys/artifacts/model/SQOverview.java @ 3389:816ceb0418b9
Q is not taken from MESSUNG.Q but from MESSUNG.Q_BPEGEL
flys-artifacts/trunk@5017 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
|---|---|
| date | Mon, 16 Jul 2012 09:12:56 +0000 |
| parents | 36f3b53d5cfc |
| children | 35a6c9a49a76 |
line wrap: on
line diff
--- a/flys-artifacts/src/main/java/de/intevation/flys/artifacts/model/SQOverview.java Mon Jul 16 06:31:18 2012 +0000 +++ b/flys-artifacts/src/main/java/de/intevation/flys/artifacts/model/SQOverview.java Mon Jul 16 09:12:56 2012 +0000 @@ -95,7 +95,7 @@ " JOIN gewaesser g " + " ON s.gewaesserid = g.gewaesserid " + "WHERE" + - " m.q IS NOT NULL AND" + + " m.q_bpegel IS NOT NULL AND" + " g.name = :name " + "ORDER by" + " s.km, m.datum";