Logical operators - Amazon IoT SiteWise
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

Logical operators

Amazon 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 '/'