Mercurial > dive4elements > gnv-client
comparison gnv-artifacts/doc/conf/queries.properties @ 469:62fc63d0f71d
Added a new State in Product Verticalprofile in Timeseriespoints.
Now it will be displayed the Years where measurements happened and than only the dates of the chosen Year will be fetched and displayed.
gnv-artifacts/trunk@532 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author | Tim Englich <tim.englich@intevation.de> |
---|---|
date | Tue, 12 Jan 2010 12:42:53 +0000 |
parents | 363236fc462d |
children | 64e65daa65e9 |
comparison
equal
deleted
inserted
replaced
468:7ba4c7222265 | 469:62fc63d0f71d |
---|---|
259 WHERE TS.TIMESERIESID = TSV.TIMESERIESID and \ | 259 WHERE TS.TIMESERIESID = TSV.TIMESERIESID and \ |
260 M.MEASUREMENTID = TSV.MEASUREMENTID and \ | 260 M.MEASUREMENTID = TSV.MEASUREMENTID and \ |
261 M.FEATUREID = ? and \ | 261 M.FEATUREID = ? and \ |
262 TS.PARAMETERID IN ( ? ) | 262 TS.PARAMETERID IN ( ? ) |
263 | 263 |
264 | |
265 verticalprofile_year=select distinct \ | |
266 to_char(tsv.TIMEVALUE,'YYYY') KEY, \ | |
267 to_char(tsv.TIMEVALUE,'YYYY') VALUE \ | |
268 from MEDIAN.TIMESERIES ts, \ | |
269 MEDIAN.TIMESERIESVALUE tsv, \ | |
270 MEDIAN.MEASUREMENT m \ | |
271 where ts.TIMESERIESID = tsv.TIMESERIESID and \ | |
272 m.MEASUREMENTID = tsv.MEASUREMENTID and \ | |
273 m.FEATUREID = ? and \ | |
274 ts.PARAMETERID IN ( ? ) \ | |
275 order by to_char(tsv.TIMEVALUE,'YYYY') | |
276 | |
264 verticalprofile_date=select distinct \ | 277 verticalprofile_date=select distinct \ |
265 tsv.TIMEVALUE KEY, \ | 278 tsv.TIMEVALUE KEY, \ |
266 tsv.TIMEVALUE VALUE \ | 279 tsv.TIMEVALUE VALUE \ |
267 from MEDIAN.TIMESERIES ts, \ | 280 from MEDIAN.TIMESERIES ts, \ |
268 MEDIAN.TIMESERIESVALUE tsv, \ | 281 MEDIAN.TIMESERIESVALUE tsv, \ |
269 MEDIAN.MEASUREMENT m \ | 282 MEDIAN.MEASUREMENT m \ |
270 where ts.TIMESERIESID = tsv.TIMESERIESID and \ | 283 where ts.TIMESERIESID = tsv.TIMESERIESID and \ |
271 m.MEASUREMENTID = tsv.MEASUREMENTID and \ | 284 m.MEASUREMENTID = tsv.MEASUREMENTID and \ |
272 m.FEATUREID = ? and \ | 285 m.FEATUREID = ? and \ |
273 ts.PARAMETERID IN ( ? ) \ | 286 ts.PARAMETERID IN ( ? ) and \ |
287 to_char(tsv.TIMEVALUE,'YYYY') IN (?) \ | |
274 order by tsv.TIMEVALUE | 288 order by tsv.TIMEVALUE |
275 | 289 |
276 verticalprofile_chart_data= SELECT M.ZLOCATION XORDINATE, \ | 290 verticalprofile_chart_data= SELECT M.ZLOCATION XORDINATE, \ |
277 TSV.DATAVALUE YORDINATE, \ | 291 TSV.DATAVALUE YORDINATE, \ |
278 TS.PARAMETERID GROUP1, \ | 292 TS.PARAMETERID GROUP1, \ |