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
