1 Reply Latest reply on Oct 5, 2009 4:58 PM by ceige

    Advanced Alerts and SQL

      I see a lot of posts about using SQL in advanced alerts.  I do not see anything that says exactly how that is done.  Where in the advanced alert do you get to define the SQL you want to use?

        • Re: Advanced Alerts and SQL
          ceige

          You can create Advanced SQL variables to retrieve information from the database to be included in your notifications...  As far as writing a query as an alert trigger/reset/suppression this is not an available option.  Though, when you create an advanced alert the logic you are using in your conditions is translated in to an sql query on the back end and stored in the AlertDefinitions Table so once you have selected your alert crietria you can use that table and more specifically the Trigger/reset/suppression field in that table, to see the query that was created in your alert.