V1118_1_详情也列表和仪表盘展示复选框功能扩展优化.sql 576 Bytes

Raw Blame History Permalink

INSERT INTO `cloud_backend_monitor`.`sys_ddic`(`ddicId`, `ddicCode`, `ddicName`, `ddicDesc`, `ddicSort`, `ddicCategory`,
                                               `createTime`)
VALUES ('3a83b4dafeff44fe85e32ae824146b91', 'topoBindKpiIds', '拓扑绑定指标', '拓扑绑定指标', 1, '0', '2021-11-18 14:55:53');

INSERT INTO sys_ddic (ddicId, ddicCode, ddicName, ddicDesc, ddicSort, ddicCategory, createTime)
select UUID(), kpiId, kpiName, kpiType, 0 as ddicSort, 'topoBindKpiIds' as ddicCategory, NOW() as createTime
from b_kpi
where kpiIdent = 1
   or isWarning = 1