In my advanced alert, I am trying to build a custom SQL variable that returns data for the specific object I'm alerting on but every time I get the alert, it returns the first value that would show if I ran the Select statement against the database. It is not refining it to the alerted on object. Can I use variables in the Select statement or how do I refine the results of the Advanced Alert Custom SQL variable to only the object that is being alerted on and not just execute the Select statement?
Thanks,
Jason Henson
Loop1 Systems
www.Loop1Systems.com