Skip to Content

Default language.

Information
This version of the product has reached end of support. The documentation is available for your convenience. However, you must be logged in to access it. You will not be able to leave comments.

Limiting query results by using email qualifications

You can limit the entries that a query returns by using the Qualification label. The syntax of the value given to the qualification is the same as what is used in the Advanced Search Bar in the . As a result, any search that executes in the Advanced Search Bar in the  will also work with the Qualification label.

Success

Tip

Create a user-defined instruction that runs the query. This allows the user to quickly execute queries based 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 Francie Frontline submitted, include the Qualification label with the following query value in your email message to the :

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

    In the qualification, the Submitter field name must be the same as the database name of the field. Also, field names are case sensitive, and must exactly match the database name of the field. 

    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*

AR System 22.1