Administer > Database administration > Data persistence > Queries > Use the equal to relational operator

Use the equal to relational operator

Applies to User Roles:

System Administrator

Example: Retrieve all device records where the value of the Location field is equal to DEFAULT HQ.

In this example, we execute an equal to (=) search from the device form and then displays a record list containing all exact matches.

To use the equal to relational operator:

  1. Click Tailoring > Database Manager.
  2. Type =device in the Form field.
  3. Click Search.
  4. Type =DEFAULT HQ in the Location field on the device form.
  5. Click Find.
  6. Click any record to view the details.

Note: A device is also referred to as an Asset or Configuration Item (CI).

Related topics

Equal to relational operator
Record retrieval
Relational operators
The Database Manager utility

Retrieve all records in a table
Retrieve records within a range