Mercurial > dive4elements > gnv-client
comparison gnv-artifacts/src/test/ressources/queries.properties @ 196:60c61f323f16
Bugfix for TIMESERIESPOINT the first and the last value weren't used in the Query which was integrated from the
Prototyp to the Project ussue54
gnv-artifacts/trunk@249 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Tim Englich <tim.englich@intevation.de> |
|---|---|
| date | Tue, 20 Oct 2009 10:07:22 +0000 |
| parents | d436c8b27ae3 |
| children | bab92ad1165d |
comparison
equal
deleted
inserted
replaced
| 195:63f65fb9f210 | 196:60c61f323f16 |
|---|---|
| 75 FROM MEDIAN.TIMESERIESVALUE tv, \ | 75 FROM MEDIAN.TIMESERIESVALUE tv, \ |
| 76 MEDIAN.TIMESERIES t \ | 76 MEDIAN.TIMESERIES t \ |
| 77 WHERE tv.TIMESERIESID = t.TIMESERIESID AND \ | 77 WHERE tv.TIMESERIESID = t.TIMESERIESID AND \ |
| 78 t.PARAMETERID IN ( ? ) AND \ | 78 t.PARAMETERID IN ( ? ) AND \ |
| 79 tv.MEASUREMENTID IN ( ? ) AND \ | 79 tv.MEASUREMENTID IN ( ? ) AND \ |
| 80 tv.TIMEVALUE > ? AND \ | 80 tv.TIMEVALUE >= ? AND \ |
| 81 tv.TIMEVALUE < ? \ | 81 tv.TIMEVALUE <= ? \ |
| 82 ORDER BY tv.MEASUREMENTID , \ | 82 ORDER BY tv.MEASUREMENTID , \ |
| 83 tv.TIMESERIESID , \ | 83 tv.TIMESERIESID , \ |
| 84 t.PARAMETERID , \ | 84 t.PARAMETERID , \ |
| 85 tv.TIMEVALUE | 85 tv.TIMEVALUE |
| 86 | 86 |