Administer > Database administration > Data persistence > Queries > Use the less than relational operator

Use the less than relational operator

Applies to User Roles:

System Administrator

Example: Retrieve all device records where the value of the IP Address field is less than 196.

In this example, we execute a less than (<) search from the device form and then displays a record list containing all matches with a value less than the number 196.

To use the less than relational operator:

  1. Click Tailoring > Database Manager.
  2. Type =device in the Form field.
  3. Click Search.
  4. Type <196 in the Serial number field on the device form.
  5. Press Enter.
  6. Click any record to view the details.

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

Related topics

Less than relational operator
Record retrieval
Relational operators
Retrieving records by using the record list method
The Database Manager utility

Retrieve all records in a table
Retrieve records within a range