diff options
| author | wangwenrui <wangwenrui> | 2019-01-31 15:20:47 +0800 |
|---|---|---|
| committer | wangwenrui <wangwenrui> | 2019-01-31 15:20:47 +0800 |
| commit | 647db8fb9eb74cc4145d53976582c539c5aa6f18 (patch) | |
| tree | 720c10cf7332b4cf7fa122e894cd53697a3c92cb | |
| parent | fb0627eb59f8b49e84eaef0b92a9e50636c4cbac (diff) | |
解决异常网元按最近检查时间过滤查询无数据的bug
| -rw-r--r-- | src/nis/nms/web/actions/detection/DetectionWarningAction.java | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/src/nis/nms/web/actions/detection/DetectionWarningAction.java b/src/nis/nms/web/actions/detection/DetectionWarningAction.java index 9574043..93dbaa5 100644 --- a/src/nis/nms/web/actions/detection/DetectionWarningAction.java +++ b/src/nis/nms/web/actions/detection/DetectionWarningAction.java @@ -499,7 +499,7 @@ public class DetectionWarningAction extends BaseAction { + " diw.PERFORMACE_DATA performacedate,\n" + " nt.ipn ipn\n"
+ " from (select seq_id, detection_set_info_id, max(data_check_time) dct\n"
+ " from detection_info_warning\n" + " where valid = 1\n"
- + " and data_check_time >= (sysdate - 2/24)\n"
+ + (dct == null || "".equals(dct)? " and data_check_time >= (sysdate - 2/24)\n":" and data_check_time >= to_date('" + dct + "','yyyy-mm-dd')\n")
+ " group by seq_id, detection_set_info_id) dnew\n" + " left join detection_info_warning diw\n"
+ " on dnew.seq_id = diw.seq_id\n"
+ " and dnew.detection_set_info_id = diw.detection_set_info_id\n"
|