Function Formula
- Last UpdatedDec 04, 2023
- 1 minute read
The Stream function uses the following formula. You must use the following form for the Input functions.
Formula
=STREAM(<StreamName>,< PropertyName>,< Unit>,< Aggregate>, <StartDateTime>, <EndDateTime>, <InnerObject : allow null>,<ConnectionName>)
Example
=STREAM("21HAH10CF901", "MassFlowrate", "MassDefUnit", "SUM", "2014-03-11", "2014-03-15", ,"CONN1")
Parameters
|
Parameter |
Description |
|
StreamName |
The name of the event stream. |
|
PropertyName |
The name of the property. You can only use parameter values that are defined in the StreamPropertyList.xml file. |
|
Unit |
The unit of a value. Depending on the PropertyName the unit value will be different, so you must only use input values in unit list. |
|
Aggregate |
The function of the result value. You can specify AVG or SUM for the value of this parameter which depends on the PropertyName parameter. |
|
StartDateTime |
Starting date/time. (Greater than or Equal to) |
|
EndDateTime |
Ending date/time. (Less than) |
|
InnerObject |
You can get a value of specified inner objects in a complex property like Products or Components. If you do not set any value, the whole string value of the property will return. |
|
Connection Name (Optional parameter) |
Name of the connection which contains database details. If the connection name is not specified then the default database connection will be used. |