Comparison Operators

 

Standard Comparison Operators
Operator Description
And The value in the database must match both stanzas entered.
Or The value in the database must match one of the arguments. You cannot use an OR operator between stanzas.
= The value in the database must be equal to the argument entered.
!= The value in the database must not be equal to the argument entered.
> The value in the database must be greater than the argument entered
<  The value in the database must be less than the argument entered.
>= The value in the database must be greater than or equal to the argument entered.
<= The value in the database must be less than or equal to the argument entered.

 

Attribute Type Comparison Operators

SIQL query comparison operators vary by attribute type. The following table lists the comparison operators by attribute type.

Function Name Description
String

=

!=

~ (contains)

!~ (does not contain)

is null

is empty

is not null

is not empty
Number

=

!=

>

<

>=

<=

~ (in list comparison)

!~ (not in list comparison)

is null

is not null
Boolean

=

!=

is null

is not null
UUID

=

!=

~ (in list comparison)

!~ (not in list comparison)

is null

is not null
Array

~

!~

is null

is not null

is empty

is not empty

 

Set Operation Comparison Operators

You can use the following set operations to perform comparisons on the complex tree structures of network and service objects. Set operations are commonly used in SIQL to compare an IP address against a device or device group.

Function Name Description Example
IS SUBSET OF Checks whether the data type is contained within the given attribute in a stanza. device{managementIp IS SUBSET OF '192.168.20.0/24'}
IS SUPERSET OF Check whether the data type contains the given attribute in a stanza. device{managementIp IS SUPERSET OF '192.168.20.0/24'}
EQUALS Checks whether the data type equals the given attribute in a stanza. device{managementIp EQUALS '192.168.20.12'}
INTERSECTS Checks whether the data type intersects the given attribute in a stanza. device{managementIp INTERSECTS '192.168.20.0/24'}
IS DISJOINT FROM Checks whether the data type has no relation to the given stanza. device{managementIp IS DISJOINT FROM '193.168.20.12/32'}