Creating Notifier Queries

Follow the steps below to create a new notification query from scratch.

Instead of creating a new query, you can also:

  • Use a standard Notifier Queries included in the application
  • Copy a standard Notifier Query and then modify the copy
  • Use a standard inquiry in VA Inquiries
  • Copy a standard inquiry in VA Inquiries
  • Create a new inquiry from scratch using VA Inquiries
Tip: When creating a query, you can select Options > Viewpoint Views to open the WF Notifier Viewpoint Tables form. This form lists all views associated with each module in the system. More

To create a new Notifier query:

  1. Open the WF Notifier Queries form.
  2. Enter a name for the query in the Query Name field.
  3. Enter a title for the query in the Title field.
  4. Check the Event Query box if this is an event-driven query. More
  5. Enter a description of the query in the Description field.
  6. Enter the SELECT clause in the Select Clause field. More - Including an example
  7. Enter the FROM and WHERE clause in the From Where Clause field. More - Including an example
  8. Click Test Query to have the system search the query for errors.
  9. Add any local variables that you included in the SQL query to the Query Parameters tab. When the Notifier Query is associated with a Notifier Job, you will be able to define these local variables using the Parameters tab on the WF Notifier Job Manager form. More
  10. Save the query. The Email Fields tab displays all of the bracketed fields from the select clause.
    Note: The fields on this tab specify the data contained in email messages created by the Notifier job. These fields must be unique. If there are multiple occurrences of these fields, edit them in the Select Clause field to make each one unique. Make sure to edit only those fields in brackets. The system updates the Email Fields section once you save the record.
  11. If you are creating an event-driven query, check the Is Key Field box on the Email Fields tab for each key field. For more information, see Event-Driven Queries.
  12. Once you create the query, use the WF Notifier Job Manager form to associate it with a Notifier Job.