如何把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语法支持遍历