Skip to main content
Share / Export

Configuring WF Notifier Queries

WF Notifier Queries define the SQL that retrieves rows for a notifier (columns available in the email, parameters, and whether only new rows trigger a send).

Before you start​

  • Know the tables/columns you need and any filter parameters.
  • Have permission to configure WF notifier queries.

Steps​

  1. Open WF Notifier Queries.
  2. Write the SQL, focusing the SELECT list on columns the email should expose.
  3. Add parameters with @ names and define them on the Query Parameters tab with clear descriptions.
  4. Check Event query if the notifier should fire only when new records exist (avoids re-sending the same set).
  5. Save for use in Job Manager scheduling.

Notes​

  • Descriptive parameter names make job setup easier.
  • Review queries when the underlying process (for example unapproved AP) changes.