如何把mysql查询的数据全都显示在消息模板里面

[PrincessTG]

我使用的是mysql监控，查询出来的数据有多条。类似这样：

[PrincessTG]

"NUMBER":2,
"ALERT_SILENCE":0,
"failureCause":"{"msg":"groovy.util.ResourceException: 我是错误2}",
"ALERT_CONDITION":"1",
"traceKey":"PB20240314046369",
"TOP_N_DOCUMENTS":[
{
"failureCause":"{"msg":"groovy.util.ResourceException: 我是错误2}",
"traceKey":"PB20240314046369",
"taskType":"edi-2016-quote",
"startTime":"2024-03-19T19:52:08"
},
{
"failureCause":"{"msg":"groovy.util.ResourceException: Cannot open 我是错误1}",
"traceKey":"PB20240314046369",
"taskType":"edi-2016-quote",
"startTime":"2024-03-19T19:35:45"
}
],
"ALARM_ID":1,
"taskType":"edi-2016-quote",
"THRESHOLD":"1",
"TIME_WINDOW":"1",
"OPERATOR":"GTE",
"headFields":"",
"startTime":"2024-03-19T19:52:08",
"CURRENT_TIME":"2024-03-19 17:51:55",
"EXPRESSION":"failureCause.indexOf("Exception") !== -1;",
"ALARM_NAME":"测试1"

[PrincessTG]

可以将TOP_N_DOCUMENTS里的数据，分条显示在消息模板里面吗？如果可以，我应该如何来配置我的消息模板

[LittleShrimp1987]

可以，自己定制消息模板，freemarker语法支持遍历