comparison gnv-artifacts/doc/conf/queries.properties @ 306:e7f1c79bf9cd

Bugfix for issue91, wrong depth will be drawn in TimeseriesCharts in Meshes gnv-artifacts/trunk@364 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author Tim Englich <tim.englich@intevation.de>
date Tue, 24 Nov 2009 13:29:36 +0000
parents af474a541f74
children 251f16a083f8
comparison
equal deleted inserted replaced
305:91c37bf28c0e 306:e7f1c79bf9cd
176 MEDIAN.MESHPOINT mp, \ 176 MEDIAN.MESHPOINT mp, \
177 MEDIAN.MESH m \ 177 MEDIAN.MESH m \
178 where (m.OBJECTID = ? AND \ 178 where (m.OBJECTID = ? AND \
179 msv.PARTID >= m.PARTIDMIN AND \ 179 msv.PARTID >= m.PARTIDMIN AND \
180 msv.PARTID <= m.PARTIDMAX ) AND \ 180 msv.PARTID <= m.PARTIDMAX ) AND \
181 msv.FEATUREID in ( ? ) AND \ 181 msv.FEATUREID = mp.FEATUREID AND \
182 msv.PARAMETERID in ( ? ) AND \ 182 msv.PARAMETERID in ( ? ) AND \
183 mp.FEATUREID in ( ? ) AND \ 183 mp.FEATUREID in ( ? ) AND \
184 msv.TIMEVALUE >= ? AND \ 184 msv.TIMEVALUE >= ? AND \
185 msv.TIMEVALUE <= ? \ 185 msv.TIMEVALUE <= ? \
186 order by mp.FEATUREID, \ 186 order by mp.FEATUREID, \
207 msv.PARTID >= m.PARTIDMIN AND \ 207 msv.PARTID >= m.PARTIDMIN AND \
208 msv.PARTID <= m.PARTIDMAX ) AND \ 208 msv.PARTID <= m.PARTIDMAX ) AND \
209 m.SOURCEID = SI.SOURCEID AND \ 209 m.SOURCEID = SI.SOURCEID AND \
210 ML.MESHID = MEDIAN.MESHPOINT.MESHID AND \ 210 ML.MESHID = MEDIAN.MESHPOINT.MESHID AND \
211 ML.KPOSITION = MEDIAN.MESHPOINT.KPOSITION AND \ 211 ML.KPOSITION = MEDIAN.MESHPOINT.KPOSITION AND \
212 msv.FEATUREID in ( ? ) AND \ 212 msv.FEATUREID = MEDIAN.MESHPOINT.FEATUREID AND \
213 msv.PARAMETERID in (? ) AND \ 213 msv.PARAMETERID in (? ) AND \
214 MEDIAN.MESHPOINT.FEATUREID in ( ? ) AND \ 214 MEDIAN.MESHPOINT.FEATUREID in ( ? ) AND \
215 msv.TIMEVALUE >= ? AND \ 215 msv.TIMEVALUE >= ? AND \
216 msv.TIMEVALUE <= ? \ 216 msv.TIMEVALUE <= ? \
217 order by MEDIAN.MESHPOINT.FEATUREID, \ 217 order by MEDIAN.MESHPOINT.FEATUREID, \

http://dive4elements.wald.intevation.org