Limiting query results by using email qualifications

As an administrator, you can limit the entries that a query returns by using the Qualification label in the email with the query that you send to the Email Engine. The syntax of the value given to the qualification is the same as what is used in the Advanced Search Bar in the Mid Tier. As a result, any search that executes in the Advanced Search Bar in the Mid Tier will also work with the Qualification label.

Tip

Create a query instruction specific to the user based on the on instructions that the administrator has predefined.

To include qualifications in an incoming email message

  1. Create an email.

  2. To execute a query that returns all tickets that an employee submitted, use the Qualification label with the following query value in your email message to the Email Engine:
    For example, Francie Frontline is an employee who has submitted a few tickets.
    In the qualification, the Submitter field name must be the same as it is stored in the database. Also, field names are case sensitive, and must exactly match the field name stored in the database. 

    Schema: HD Incident
    Server: polycarp
    Login: Francie Frontline
    Password: <userPassword>
    Action: Query
    Qualification: 'Submitter' = "Francie Frontline"

    You can also query entries by using field IDs instead of the database name of the field. For example, the following Qualification label will produce the same results when the Submitter field has a field ID of 2.

    Qualification: '2' = "Francie Frontline"

    In your qualification, you can include relational operators. The following qualification retrieves an entry whose employee ID is 9 and that was submitted by Francie Frontline.

    Qualification: 'Employee_Id' = 9 AND 'Submitter' = "Francie Frontline"

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*