SQL/SWQL macros (variables) in Alerts are printed as is in alert if resultset is empty

demollib

Hi,

do you know how to avoid this?

I want to print in the email alert something from the sql select but only if the select succeeds, otherwise the variable should be empty. Look at this picture i made a simple sql macro with a false condition. This is the outcome in re sent email and in the simulate button too.

I have this macro in the alert message (HTML)

${N=SWQL;M=SELECT Status FROM Orion.NPM.CustomPollerStatusOnNode WHERE NodeID = 159}

the result works as expected with the text: power-on

if i change the condition to something that does not exist i would expect an empty result

${N=SWQL;M=SELECT Status FROM Orion.NPM.CustomPollerStatusOnNode WHERE NodeID = 999999}

instead i am getting the exact sql statement as a result text...

adam.beedell

It needs to evaluate to something or it'll come back with the macro text. (chuck in a CASE or UNION)

If it's still not evaluating that's a confusing pain