Community Tip - Stay updated on what is happening on the PTC Community by subscribing to PTC Community Announcements. X
Hi,
What is the format of the input for the source and query fields for the QueryDataTableEntries service of the DataTable? Please give examples.
Thanks and Regards,
Jyothi
Hi,
A query example:
var query = {
filters: {
type: "And",
filters: [
{
type: "LIKE",
fieldName: "ID",
value: "%" + id + "%"
},
{
type: "LIKE",
fieldName: "EntityType",
value: entityType
}
]
}
};
The source depends on how you add entry to table. By default, it's the login username. You can check it in your DataTable / Entity Information / Home Mashup.
QueryDataTableEntries service:
var params = {
maxItems: undefined /* NUMBER */,
values: undefined /* INFOTABLE*/,
query: query /* QUERY */,
source: "A_String" /* STRING */,
tags: undefined /* TAGS */
};
// result: INFOTABLE
var result = Things[DataTableName].QueryDataTableEntries(params)
Regards,
Quang-Dung