Dataset Query Language (DQL)
DQL or Dataset Query Language is using a mixture of SQL and SER syntax and allows executing queries on datasets (matrices) just like on a table in a database.
Category: Technical Reference
TableLookup()
TableLookup() returns the result of a table lookup, which will be either a single value or a tag, depending on the lookup value. If any lookup value is outside the range of the dataset, the corresponding result will be an error value. It enables linear interpolation between two values to find and calculate a result.
RawTimeOf()
RawTimeOf() returns the original timestamp of each datum expressed as the number of seconds since Unix epoch (1970 Jan 1 00:00:00).
ComposeBinary()
ComposeBinary() returns the number which was built from the bits which were provided by the parameters.
ContinuousSmall_Sampled()
ContinuousSmall_Sampled() can be used to find the nth smallest value in a time range.
ContinuousLarge_Sampled()
ContinuousLarge_Sampled() can be used to find the nth largest value in a time range.
Small_Sampled()
Small_Sampled() can be used to find the nth smallest value in a time range.
Large_Sampled()
Large_Sampled() can be used to find the nth largest value in a time range.
ServerConfig.xml
These are the default settings in the configuration file: C:\Program Files\P2 Energy Solutions\P2 Explorer\Configuration\ServerConfig.xml
Python Script
The Python Script component is conceptually similar to the R Script component, where you can configure input pins, write a script to use these inputs and perform some logic, and set the output value. That output value would then be forwarded to the next node in the UDP graph.