BSH-Talk, 6. März 2019 DataDIVER - Präsentation, Monika Willer 10 DataDIVER: Vertikalprofil SQL-Abfrage QUERY: verticalprofile_instantaneouspoint_chart_data SELECT M.ZLOCATION XORDINATE, ROUND(MSV.DATAVALUE,4) YORDINATE, MSV.PARAMETERID GROUP1, IP.FEATUREID GROUP2, 1 GROUP3, 3 DATAID, IP.FEATUREID, IP.SERIESID FROM MEDIAN.INSTANTANEOUSPOINT_SDO IP, MEDIAN.MEASUREMENT M, MEDIAN.MEASUREDSCALARVALUE MSV WHERE IP.FEATUREID = M.FEATUREID AND M.MEASUREMENTID = MSV.MEASUREMENTID AND IP.FEATUREID IN (6789219) AND MSV.PARAMETERID in (2 , 30) AND M.ZLOCATION >= -46.55 AND M.ZLOCATION <= -0.991 ORDER BY IP.TIMEVALUE, MSV.PARAMETERID, M.ZLOCATION Select: 9 Parameter From: 3 Tabellen Where: 6 Bedingungen