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).