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.

Logical operators

Operator

Description

Example

AND

TRUE if both values are true

a AND b

If either a or b is FALSE, the previous expression evaluates to false. For an AND operator to evaluate to true, both a and b must be true.


SELECT a.asset_name 
FROM asset as a, latest_value_time_series as t 
WHERE t.int_value > 30 AND t.event_timestamp > 1234567890