Query definitions

A query consists of the following:

• Data field. A field from the database.
• Condition. A conditional operator to be performed on the data field.
• Value. A value to compare the data field with. This is not required for some conditional operators.

To define a query you must select a data field and one of the following operators:

• equals
• does not equal
• starts with
• does not start with
• includes
• does not include
• ends with
• does not end with
• is null
• is not null
• is blank
• is not blank
• is greater than
• is greater than or equal to
• is less than
• is less than or equal to
• is part of (verify if an IP address is within an IPv4 subnet)
• is not part of (verify if an IP address is not within an IPv4 subnet)

Not all operators are applicable to all data fields. Not all operators require a value.

Combinations of data field, operator, and values can be used to define queries.