From ebfe7d8044ebbf021414cccc5ca0d1d3208e89b3 Mon Sep 17 00:00:00 2001 From: jpy <812110275@qq.com> Date: Sat, 27 May 2023 18:15:06 +0800 Subject: [PATCH] test --- screen-api/src/main/resources/mapper/HistoryFiveMinutelyMapper.xml | 2 +- 1 files changed, 1 insertions(+), 1 deletions(-) diff --git a/screen-api/src/main/resources/mapper/HistoryFiveMinutelyMapper.xml b/screen-api/src/main/resources/mapper/HistoryFiveMinutelyMapper.xml index 1acd877..4e0901b 100644 --- a/screen-api/src/main/resources/mapper/HistoryFiveMinutelyMapper.xml +++ b/screen-api/src/main/resources/mapper/HistoryFiveMinutelyMapper.xml @@ -14,7 +14,7 @@ `device` AS d WHERE d.mac = h.mac AND d.mac IN - (SELECT mac FROM device WHERE is_delete = '0' and monitor_point_id IN + (SELECT mac FROM device WHERE monitor_point_id IN <foreach item="monitorPointId" collection="monitorPointIds" index="index" open="(" separator="," close=")"> #{monitorPointId} </foreach> -- Gitblit v1.8.0