Administer > Database administration > Data persistence > Queries > Use the not symbol with logical or relational operators

Use the not symbol with logical or relational operators

Applies to User Roles:

System Administrator

Example: Retrieve all device records, excluding those that begin with the letter C, in the Vendor Name field.

Note: If your database has not first been set up to enable case-insensitive searching, this query returns records that begin with a lowercase letter c.

In this example, we use the not relational operator to exclude records in the device.qbe form.

To use the not symbol with logical or relational operators:

  1. Click Tailoring > Database Manager.
  2. Type =device in the Form field, and then click Search.
  3. With the device form open, type C or ~C in the Vendor Name field, and then click Find.

    Note: Using the tilde (~) character is platform-dependent.

  4. Click any record in the list of returned records to view the details.

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

Related topics

Logical operators
Relational operators
Retrieving records by using the record list method
Using ranges in queries

Retrieve all records in a table
Retrieve records within a range