Mercurial > dive4elements > gnv-client
diff gnv-artifacts/doc/conf/queries.properties @ 336:1b9ca0f2d498
Added marker for different data sources in sql queries.
gnv-artifacts/trunk@402 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Ingo Weinzierl <ingo.weinzierl@intevation.de> |
|---|---|
| date | Tue, 08 Dec 2009 11:18:27 +0000 |
| parents | 3eff9241ea1e |
| children | c94936b1f4ba |
line wrap: on
line diff
--- a/gnv-artifacts/doc/conf/queries.properties Tue Dec 08 08:39:03 2009 +0000 +++ b/gnv-artifacts/doc/conf/queries.properties Tue Dec 08 11:18:27 2009 +0000 @@ -274,7 +274,8 @@ TSV.DATAVALUE YORDINATE, \ TS.PARAMETERID GROUP1, \ TSV.TIMEVALUE GROUP2, \ - 1 GROUP3 \ + 1 GROUP3, \ + 1 DATAID \ from MEDIAN.TIMESERIES TS, \ MEDIAN.TIMESERIESVALUE TSV, \ MEDIAN.MEASUREMENT M \ @@ -409,7 +410,8 @@ msv.DATAVALUE YORDINATE, \ msv.PARAMETERID GROUP1, \ msv.TIMEVALUE GROUP2, \ - 1 GROUP3 \ + 1 GROUP3, \ + 2 DATAID \ from MEDIAN.MESHLAYER ml, \ MEDIAN.MESHPOINT mp, \ MEDIAN.MESH m, \ @@ -552,7 +554,8 @@ MSV.DATAVALUE YORDINATE, \ MSV.PARAMETERID GROUP1, \ IP.TIMEVALUE GROUP2, \ - 1 GROUP3 \ + 1 GROUP3, \ + 3 DATAID \ FROM MEDIAN.INSTANTANEOUSPOINT IP, \ MEDIAN.MEASUREMENT M, \ MEDIAN.MEASUREDSCALARVALUE MSV \ @@ -742,7 +745,8 @@ MSV.DATAVALUE YORDINATE, \ MSV.PARAMETERID GROUP1, \ ZLOCATION GROUP2, \ - 1 GROUP3 \ + 1 GROUP3, \ + 3 DATAID \ FROM MEDIAN.INSTANTANEOUSPOINT, \ MEDIAN.MEASUREMENT M, \ MEDIAN.MEASUREDSCALARVALUE MSV \ @@ -811,7 +815,8 @@ MEDIAN.MESHPOINT.KPOSITION GROUP2, \ msv.TIMEVALUE GROUP3, \ MEDIAN.MESHPOINT.JPOSITION, \ - MEDIAN.MESHPOINT.IPOSITION \ + MEDIAN.MESHPOINT.IPOSITION, \ + 2 DATAID \ from MEDIAN.MESHLAYER ml, \ MEDIAN.MESHPOINT, \ MEDIAN.MESH m, \ @@ -939,7 +944,8 @@ MSV.PARAMETERID PARAMETER, \ MEDIAN.MESHPOINT.JPOSITION, \ MEDIAN.MESHPOINT.IPOSITION, \ - MEDIAN.MESHPOINT.KPOSITION \ + MEDIAN.MESHPOINT.KPOSITION, \ + 2 DATAID \ from MEDIAN.MESHLAYER ml, \ MEDIAN.MESHPOINT, \ MEDIAN.MESH m, \ @@ -999,7 +1005,8 @@ MSV.DATAVALUE YORDINATE, \ MEDIAN.MESHFACE.JPOSITION, \ MEDIAN.MESHFACE.IPOSITION, \ - MEDIAN.MESHFACE.KPOSITION \ + MEDIAN.MESHFACE.KPOSITION, \ + 2 DATAID \ from MEDIAN.MESHLAYER ML, \ MEDIAN.MESHFACE, \ MEDIAN.MESH M, \ @@ -1061,4 +1068,4 @@ FROM MEDIAN.FEATUREAREA \ WHERE (FEATURETYPE = 7 OR FEATURETYPE = 8) AND \ FEATUREID = ? \ - ORDER BY NAME \ No newline at end of file + ORDER BY NAME