iailab-module-model/iailab-module-model-biz/src/main/resources/mapper/mcs/StScheduleSuggestDao.xml | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 |
iailab-module-model/iailab-module-model-biz/src/main/resources/mapper/mcs/StScheduleSuggestDao.xml
@@ -10,7 +10,7 @@ ROW_NUMBER() OVER ( PARTITION BY schedule_obj ORDER BY schedule_time DESC ) AS rn FROM t_st_schedule_suggest WHERE schedule_obj in ('BFG_ALARM', 'COG_ALARM', 'LDG1_ALARM', 'LDG2_ALARM', 'LDGt_ALARM') ('BFG_ALARM', 'COG_ALARM', 'LDG1', 'LDG2', 'LDGt') and schedule_time >= DATE_SUB(NOW(), INTERVAL 15 MINUTE )) SELECT * FROM t_st_schedule_suggest