Comparison Operators

Comparison operators compare values across all attribute types.

note

You must use the comparison operator symbol (for example, >) rather than the name of the symbol (GREATER THAN) in the query. Using names of the operators is not supported.

Equals To

Use = to check if the value of an attribute equals a specified value.

FIND Finding AS f WHERE f.riskRating = "Critical"

The above query returns all findings with a risk rating of "Critical".

Not Equals To

Use != or <> to check if the value of an attribute does not equal a specified value. != and <> can be used interchangeably when querying for "Not Equals To".

FIND Finding AS f WHERE f.severity != "Critical"

FIND Finding AS f WHERE f.severity <> "Critical"

The above queries return all findings where the severity is not "Critical".

Greater Than

Use > to check if the value of an attribute is greater than a specified value.

FIND Finding AS f where f.severity > "High"

The above query returns all findings with severity levels ranked higher than "High".

Greater Than or Equals To

Use >= to check if the value of an attribute is greater than or equal to a specified value.

FIND Finding AS f WHERE f.riskScore >= 7

The above query returns all findings with a risk score of 7 or higher.

Less Than

Use < to check if the value of an attribute is less than a specified value.

FIND Finding AS f WHERE f.riskRating < "Critical"

The above query returns all findings with a risk rating lower than "Critical"

Less Than or Equals To

Use <= to check if the value of an attribute is less than or equal to a specified value.

FIND Finding AS f WHERE f.riskRating <= "Medium"

The above query returns all findings with risk rating of "Medium".