Page History

Versions Compared

Key

This line was added.
This line was removed.
Formatting was changed.

...

Code Block

theme	Eclipse
language	javascript
title	Coalesce Operator
linenumbers	true

coalesce = COALESCE({ATTR=['sensorid'], 
        AGGREGATIONS=[['AVG','temperature','temperatur']},tempSensor1)

coalesce = COALESCE({predicate='temperature>=10', 
        AGGREGATIONS=[['last','temperature','temperature'], ['AVG,'temperature','avgTemp']},tempSensor1)

New Version

A new version of the coalesce operator can combine attr and predicates:

...