Logical operators - AWS IoT SiteWise

Logical operators

AWS IoT SiteWise supports the following logical operators.

Operator

Signature

Description

AND

a AND b

TRUE if both values are true

OR

a OR b

TRUE if one value is true

NOT

NOT expression

TRUE if an expression is false, and FALSE if an expression is true

IN

x IN expression

TRUE if value in expression

BETWEEN

BETWEEN a AND b

TRUE if value between upper and lower limit, and includes both limits

LIKE

LIKE pattern

TRUE if value is in pattern

LIKE supports wildcards. See below for examples:

  • % substitutes one or more characters in a string.

  • _ substitutes one character in a string.

  • ESCAPE is used with a character to designate an escape character in the LIKE pattern.

Examples of all logical operators:

Function

Example

AND

 
SELECT a.asset_name 
   FROM asset AS a, latest_value_time_series AS t 
   WHERE t.int_value > 30 AND t.event_timestamp > TIMESTAMP '2025-05-15 00:00:01'

OR

 
SELECT a.asset_name 
   FROM asset AS a
   WHERE a.asset_name like 'abc' OR a.asset_name like 'pqr'

NOT

 
SELECT ma.asset_id AS a_id
   FROM asset AS ma
   WHERE (ma.asset_id NOT LIKE 'some%patterna%' escape 'a') AND ma.asset_id='abc'

IN

 
SELECT a.asset_name 
   FROM asset AS a
   WHERE a.asset_name IN ('abc', 'pqr')

BETWEEN

 
SELECT asset_id, int_value, event_timestamp AS i_v 
   FROM raw_time_series
   WHERE event_timestamp BETWEEN TIMESTAMP '2025-04-15 00:00:01' and TIMESTAMP '2025-05-15 00:00:01'

LIKE

  • % pattern:

    SELECT POWER(rw.int_value, 5) AS raised_value
   FROM raw_time_series AS rw
   WHERE rw.asset_id LIKE 'some%pattern%' AND rw.int_value > 30

  • _ pattern:

    SELECT asset_id, property_id
  FROM asset_property
  WHERE string_attribute_value LIKE 'Floor_'

  • ESCAPE pattern:

    SELECT asset_id 
  FROM asset 
  WHERE asset_name LIKE 'MyAsset/_%' ESCAPE '/'