错误 #24272
报警记录—创建报警记录,系统为iot,state为3,treatState为1,treateMode为2 成功后数据库查询不到生成的id
0%
描述
接口路径: /dmp-alarm/alarm/record/create?userId=c2e9e49079f24ef78da248d3bfc04bec&groupCode=apiauto&projectId=Pj6120000001
header:
header:{
"Content-Type":"application/json;charset=utf-8"
}
入参:
{
"itemCode": "1030",
"objId": "Eq61200000011506178412830339073",
"classCode": "WESSEE",
"category": "iot",
"state": 3,
"treatState":1,
"treatMode":2,
"name": "",
"triggerTime": 1678356113453,
"endTime":1678442513453,
"supplement":{},
"condition":{"rules": ["故障状态为故障时产生报警"]},
"endInfo": {
"onlineStatus": 33
},
"triggerInfo": {
"onlineStatus": 98
}
}
响应:
{"result":"success","message":null,"data":{"id":"14ab29e1-167f-4a1a-b2b2-67eaae764ab5"}}
预期结果:
sql可正常查询到此id14ab29e1-167f-4a1a-b2b2-67eaae764ab5
{"select id from dmp_alarm.alarm_record_202303 where group_code='apiauto' and project_id='Pj6120000001' and id='14ab29e1-167f-4a1a-b2b2-67eaae764ab5' and state=3 and treat_mode=2 and treat_state=1":"$.data.id"}
实际结果:
sql 查询结果为0