平时预览正常,就是隔一段时间就打不开了,是不是PI实时数据库内存原因或者数据量太大卡死了?
试试 between '${FORMAT(aa,"yyyy-MM-dd 01:00:00")}' and '${CONCATENATE(bb," ",cc)}'
between '${CONCATENATE(aa," 01:00:00")}' and '${CONCATENATE(bb," ",cc)}' order by
加默认参数,预览一下sql