Examples¶

Constraints¶

All possible constraint parameters can be found under constraint parameters.

Constraints on time¶

This constraint can only be applied to TIMESTAMP_MEASUREMENT, TIMESTAMP_CAPTURED and TIMESTAMP_CONVERTED.

From specific time¶

SELECT *

FROM LoggerName

WHERE TIMESTAMP_MEASUREMENT > to_date('01.01.2016','dd.mm.yyyy');

Time interval¶

SELECT *

FROM LoggerName

WHERE TIMESTAMP_MEASUREMENT > to_date('01.01.2016','dd.mm.yyyy')

AND TIMESTAMP_MEASUREMENT < to_date('11.01.2016','dd.mm.yyyy');

Further constraints¶

Constraint by name¶

This is always true for words and characters. It is important that the examined attribute is always enclosed in single quotes.

SELECT *

FROM LoggerName

WHERE PHYSICAL_PROPERTY_NAME = 'LOGGER_VOLTAGE';

Constraint by numbers (no date)¶

If you constrain by specific numbers, they are always without quotes.

SELECT *

FROM LoggerName

WHERE LIMIT_EXCEEDED = 0;