Function Formula
- Last UpdatedDec 04, 2023
- 1 minute read
The TankList function uses the following formula. You must use the following form for the Input functions, and then press Ctrl + Shift + Enter keys.
Formula
=TANKLIST(<TankName>,< PropertyNames>,<StartDateTime>, <EndDateTime>, <OutputDirection>, <DisplayDates>,<ConnectionName>)
Example
= TANKLIST ("SAMPLE_TANK", "MassVolume", "2014-03-11", "2014-03-15", "Vertical", TRUE,"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. You can set several properties to the parameter using a semicolon (;). |
|
StartDateTime |
Starting date/time. (Greater than or Equal to) |
|
EndDateTime |
Ending date/time. (Less than) |
|
OutputDirection |
The direction of the result range. You can only use Vertical or Horizontal. |
|
DisplayDates |
If the result includes starting date/time and ending date/time. |
|
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. |