Mercurial > dive4elements > river
diff artifacts/src/main/java/org/dive4elements/river/artifacts/model/sq/MeasurementFactory.java @ 7704:a877d2680a4a
SQ relation: only take sieve which have values at all.
| author | Sascha L. Teichmann <teichmann@intevation.de> |
|---|---|
| date | Tue, 17 Dec 2013 17:59:37 +0100 |
| parents | 7efeaa2058e1 |
| children | 0737573aa9ac |
line wrap: on
line diff
--- a/artifacts/src/main/java/org/dive4elements/river/artifacts/model/sq/MeasurementFactory.java Tue Dec 17 17:21:37 2013 +0100 +++ b/artifacts/src/main/java/org/dive4elements/river/artifacts/model/sq/MeasurementFactory.java Tue Dec 17 17:59:37 2013 +0100 @@ -116,7 +116,7 @@ "COALESCE(gs.RSIEB15, 0) + COALESCE(gs.RSIEB16, 0) +" + "COALESCE(gs.RSIEB17, 0) + COALESCE(gs.RSIEB18, 0) +" + "COALESCE(gs.RSIEB19, 0) + COALESCE(gs.RSIEB20, 0) +" + - "COALESCE(gs.RSIEB21, 0) + COALESCE(gs.REST, 0)) >= 0 " + + "COALESCE(gs.RSIEB21, 0) + COALESCE(gs.REST, 0)) > 0 " + "ORDER BY " + "m.DATUM, g.UFERABST, g.GLOTRECHTEID, gp.LFDNR"; @@ -154,7 +154,7 @@ } rawWriter.writeNext(nextLine); } - } + } // class CSVTransformer public static class FractionsTransformer extends CSVTransformer {