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.
The following list provides the supported data types for the dynamic entities (space, data model, container, views instances) 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 bynumeric, boolean, string, text, int64, float64, float32, boolean, timestamp, date, Enum. For more details on entity schema, refer to the following table:
    Supported Data Types for Dynamic Entities
    Table Details
    Column Details
    Space
    varchar (
    name
    ,
    description
    ), date and time (
    createdTime
    ,
    lastUpdatedTime
    ), Boolean (
    isGlobal
    ).
    Data model
    varchar (
    name
    ,
    description
    ,
    space
    ,
    externalId
    ), date and time (
    createdTime
    ,
    lastUpdatedTime
    ).
    Container
    varchar (
    name
    ,
    externalId
    ,
    space
    ,
    usedFor
    ), date and time (
    createdTime
    ,
    lastUpdatedTime
    ).
    View
    varchar (
    name
    ,
    space
    ,
    externalId
    ,
    usedFor
    ), date and time (
    createdTime
    ,
    lastUpdatedTime
    ).
NOTE:
By default, the data points for the last 24 hours will be returned but the user can also use the timestamputc column to fetch any relevant time range data points.
Provide Feedback
Have questions or feedback about this documentation? Please submit your feedback here.
Normal