select b.saved_time,a.point_type,b.value,a.point_name,a.point_namec from "public"."clean_config" a left join "public"."raw_data_5minute" b on a.point_name=b.opc_id where b.saved_time>='${start}'::date and b.saved_time<'${DATEDELTA(end,1)}' and a.building='${comboBox1C}' and a.floor='${comboBox2C}' and a.area='${comboBox3C}' and a.point_type='${comboBox4C}' and a.point_name in ('${comboBox5C}') and b.value!=0 and a.ver='ph1' order by a.point_namec ,a.point_namec,b.saved_time
|
1min目标场景问卷
立即参与
