Supported Queries for the Tables

Supported Queries for the Tables

The following list provides the supported queries for the assets, timeseries, timeseries_datapoints, sequences, relationships, datasets, and events table:
  • The system supports `SELECT` statements on all columns like `Id`, `Name`, and so on.
  • It supports operations such as filtering and joining between tables. This includes the use of `WHERE` clauses with various operators such as `=`, `IN`, `LIKE`,'AND', and 'OR'. The 'LIKE' operator is supported by string and text type columns and not supported by numeric, boolean and other type of columns. For more information, refer to the following table:
    Columns Not Supported by LIKE Operator
    Table Details
    Column Details
    assets
    number (id, parentid, rootid, datasetid), date and time (createdTime, lastUpdatedTime).
    timeseries
    number type (id, assetid, datasetid), date and time (createdtime, lastUpdatedTime), boolean (isStep, isString).
    timeseries_datapoints
    number (timeseriesid, valuenumeric) date and time (timestamputc), boolean (isStep, isString).
    sequences
    number type (id, assetid, datasetid), date and time (createdtime, lastUpdatedTime), boolean (isStep, isString).
    relationships
    number type (id, assetid, datasetid), date and time (createdtime, lastUpdatedTime), boolean (isStep, isString).
    datasets
    number type (id, assetid, datasetid), date and time (createdtime, lastUpdatedTime), boolean (isStep, isString).
    events
    number type (id, assetid, datasetid), date and time (createdtime, lastUpdatedTime), boolean (isStep, isString).
  • Join operations between the exposed DataMosaix tables are supported.
  • Inner join statements are supported.
Provide Feedback
Have questions or feedback about this documentation? Please submit your feedback here.