Function Formula
- Last UpdatedDec 04, 2023
- 1 minute read
The Tank function uses the following formula. You must use the following form for the Input functions.
Formula
=TANK(<TankName>,< PropertyName>,< Unit>, <StartDateTime>, <EndDateTime>, <InnerObject : allow null>,<ConnectionName>)
Example
= TANK ("TBA230A", "MassVolume", "MassDefUnit", , "2014-03-11", "2014-03-15", ,"CONN1")
Parameters
|
Parameter |
Description |
|
TankName |
The name of the event tank. |
|
PropertyName |
The name of the property. You can only use parameter values that are defined in the TankPropertyList.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. |
|
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. |