Supported Queries for the Tables

The following list provides the supported queries for the assets, timeseries, timeseries_datapoints, sequences, relationships, datasets, events, labels, and files 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 Data Points
    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
    ).
    Labels
    number type (
    id
    ,
    assetid
    ,
    datasetid
    ), date and time (
    createdtime
    ,
    lastUpdatedTime
    ), Boolean (
    isStep
    ,
    isString
    ).
    Files
    number type (
    id
    ,
    assetid
    ,
    datasetid
    ), date and time (
    createdtime
    ,
    lastUpdatedTime
    ), Boolean (
    isStep
    ,
    isString
    ).
  • Join operations between the exposed
    FactoryTalk DataMosaix SaaS
     tables are supported.
  • Inner join statements are supported.
Provide Feedback
Have questions or feedback about this documentation? Please submit your feedback here.
Normal