This documentation applies to the 8.0 version of Remedy Action Request System, which is in "End of Version Support." You will not be able to leave comments.

To view the latest version, select the version from the Product version menu.

Using the query builder widget

The query builder widget provides an intuitive user interface which enables you to build simple queries.

The query builder widget allows you to use words instead of symbols to build expressions in a non-technical manner. It also presents only the appropriate data types and operators from which you can select. For example, instead of saying "Create Date < 01/01/2011", you can enter "Create Date less than 01/01/2011."

Query builder widget example

(Click the image to expand it.)

Note

A query builder widget appears in a form only if it is loaded into the form by the BMC Remedy AR System Server Administrator.

To build a query

  1. Open a form in which you want to perform a search.
    The query builder widget appears when the form opens. If it does not, click the appropriate button (for example, for advanced search) to open a query builder widget.
  2. Build a query to add to the table:
    1. In the left box of the query builder widget, select a field from the list of fields which can be queried upon. This list of fields is provided for this form by the query builder widget.

      Note

      All field types are available for the query builder widget except for currency and status history.

    2. In the center box, enter an operator using the list, which provides operators that are meaningful for the selected field.

      The following are the numeric and enumerated data type operators:
      • Is equal to - (for numeric and enumerated data types) Selects records in which the value in the chosen field matches exactly the value entered in the query.
      • Is not equal to - Selects records in which the value in the chosen field does not match the value entered in the query.
      • Is greater than - Selects records in which the value in the chosen field is greater than the value entered in the query.
      • Is greater than or equal to - Selects records in which the value in the chosen field is greater than or matches exactly the value entered in the query.
      • Is less than - Selects records in which the value in the chosen field is less than the value entered in the query.
      • Is less than or equal to - Selects records in which the value in the chosen field is less than or matches exactly the value entered in the query.
      • Is empty - Selects records in which the chosen field is empty
      • Is not empty - Selects records in which the chosen field contains some data

        The following are the date/time data type operators:
      • On - See Is equal to.
      • Not on - See Is not equal to.
      • Before - See Is less than.
      • After - See Is greater than.
      • On or Before - See Is less than or equal to.
      • On or After - See Is greater than or equal to.
      • Is empty
      • Is not empty

        The following are all other data type operators:
      • Contains - Finds entries that contain xx.
      • Starts with - Matches all entries that begin with xx.
      • Ends with - Matches all entries that end with xx.
    3. In the right box, type the value for which to search.
      For example, to find all current users with Create Date values that are less than 01/01/2011, you could use the query builder widget to construct the following queries:

      (Click the image to expand it.)
  3. Refresh the table.
    The table is refreshed based on the query created in the query builder widget.
  4. Click the plus sign to the right of fields to add a new set of input fields, then repeat steps 2 through 3 for each query you want to add to the table.

In the Match field, select All or Any to display the results that match all queries or any query.

This version of the documentation is no longer supported. However, the documentation is available for your convenience. You will not be able to leave comments.

Comments