Hello,
I've been trying to write some alerts that will use a string contained in the user notes field and I've run in to a bit of a problem. When I build the alert with the alert manager, as soon as I pick the user notes field, there is no operator available, just a free form text field (see below).
If I investigate the SQL for this alert, it appears that nothing is actually used from that text field, I end up with the following in the where clause of the SQL trigger:
AND (APM_AlertsAndReportsData.UserNotes = )
My question is, how is the user notes field intended to be used within the context of an alert trigger? Or, is it only meant for use within the message that is sent in the alert. I realize to resolve this I can create a SQL alert but, would like to know if there is something I am missing here. Thanks for your help.
