Data Types

In the Values section featured already some data types. Each literal has a specific data type. Here you see the full list:

Boolean

Literal	Description
true	Value for true / fulfilled
false	Value for false / not fulfilled

Examples

true

AVG($PowerConsumption) > 1000

Number

A decimal number

Examples

42.0

$Event::Value * 1.5

Time

A time which consists of date and day time.

Besides of event times, we can also use one of following supported literals:

Literal	Description
now	The current time. This produces e.g. 2023-09-25 23:26
lastHour	The last full hour. E.g. 2023-09-25 23:00
lastZeroHour	The last zero hour (midnight). E.g. 2023-09-25 00:00
startOfLastMonth	The first day of the previous month. E.g. 2024-05-01 00:00
endOfLastMonth	The last day of the previous month. E.g. 2024-05-31 00:00
startOfMonthBeforeLast	The first day of the penultimate month E.g. 2024-04-01 00:00
endOfMonthBeforeLast	The last day of the penultimate month E.g. 2024-04-30 00:00
startOfCurrentMonth	The first day of the current month. E.g. 2024-06-01 00:00
endOfCurrentMonth	The last day of the current month. E.g. 2024-06-30 00:00

Examples

$Event::Timestamp

now - 24h

Timespan

A timespan.

A timespan literal is a combination of a number and a time unit. Following time units are supported:

Literal	Description
d	Days
h	Hours
min	Minutes
s	Seconds

Examples

7d

24h

30min

Text

A text element

Everything that begins and ends with a single or double quotation mark is considered a text element. This also includes elements that cannot be assigned to one of the other data types. For example, if $Event was used but no such variable was defined, it would also be considered a text element.

Remark: we recommend to use one of the quoted forms, which makes it crystal clear for the readers that this is a text.

Examples

'foo'

"bar"

foo

Event

An event, which consists of:

Attributes	Description
Value	The value of the event, which is of type Number
Timestamp	The timestamp of the event, which is of type Time
DeviceName	The name of the device which is the source of this event. It is of the of type Text
DeviceId	The ID of the device, which is the source of this event. It is of the of type Text

Examples:

$Event::DeviceName

Building

The building related to the event, so that building related data can be accessed via Attribute Accessor, see:Attribute Accessor.

Attributes	Description
Id	The value of the event, which is of type Text
RegistrationTimestamp	The timestamp when the building was registered, i.e. the on-boarding timestamp on the customer side. It is of type Time
DeviceTypes	The set of device types (which relates to the "source" entries in the events). It is a Vector of type Text.

Examples:

Building::DeviceTypes