InfoTableFunctions Query

ThingWorx Model Definition in Composer > Modeling > Code Snippets > InfoTableFunctions Query

Description

This service applies the given query to an infotable.

Inputs

Parameter Name	Description	Base Type
t	The infotable containing the data.	INFOTABLE
query	The query to perform on the infotable. For more information on writing query criteria, see Query Parameter for Query Services.	QUERY

Output

Parameter Name	Description	Base Type
result	A new infotable with rows from the input table that match the query. The Data Shape will match the shape of the input table.	INFOTABLE

Example

This example uses the Application Log as a source of an infotable with extra rows beyond the data of interest. Later, it constructs a query to filter important rows, and applies the filter using this service.

// result: INFOTABLE dataShape: "LogEntry"
var inputInfotable = Logs["ApplicationLog"].QueryLogEntries({
maxItems: undefined /* NUMBER */,
searchExpression: undefined /* STRING */,
fromLogLevel: undefined /* STRING */,
instance: undefined /* STRING */,
endDate: undefined /* DATETIME */,
origin: undefined /* STRING */,
thread: undefined /* STRING */,
ascendingSearch: undefined /* BOOLEAN */,
oldestFirst: undefined /* BOOLEAN */,
toLogLevel: undefined /* STRING */,
user: undefined /* USERNAME */,
sortFieldName: undefined /* STRING */,
startDate: undefined /* DATETIME */
});

var query = {
"filters": {
"fieldName": "level",
"type": "LIKE",
"value": "*Error*"
}
};

var params = {
t: inputInfotable /* INFOTABLE */,
query: query /* QUERY */
};

// result: INFOTABLE
var result = Resources["InfoTableFunctions"].Query(params);

Was this helpful?