I’m trying to customise my alert template message based on the values returned by my query. However, the problems right now:-
- I’m unable to fetch the column (type text) that I want to use in the message template
- I’m unable to use the column value that I want to embed into my message template
Initially I was using Legacy Alerting System, but that doesn’t achieve what I want. Upgraded to Unified Alerting System also doesn’t resolve my issue.
This is my current query