Community Tip - Stay updated on what is happening on the PTC Community by subscribing to PTC Community Announcements. X
What is the query used to filter infotable for missing values in particular Columns.
Solved! Go to Solution.
Variant 1 - MissingValueFilter Snippet (Resources --> Infotable Functions --> MissingValueFilter)
// result: INFOTABLE
let result = Resources["InfoTableFunctions"].MissingValueFilter({
inclusive: undefined /* BOOLEAN {"defaultValue":true} */,
fieldName: undefined /* STRING */,
t: undefined /* INFOTABLE */
});
Variant 2 - Query for missing values Query Parameter for Query Services (ptc.com)
const query = {
"filters": {
"type": "MissingValue",
"fieldName": "OrderQuantity"
}
};
Variant 1 - MissingValueFilter Snippet (Resources --> Infotable Functions --> MissingValueFilter)
// result: INFOTABLE
let result = Resources["InfoTableFunctions"].MissingValueFilter({
inclusive: undefined /* BOOLEAN {"defaultValue":true} */,
fieldName: undefined /* STRING */,
t: undefined /* INFOTABLE */
});
Variant 2 - Query for missing values Query Parameter for Query Services (ptc.com)
const query = {
"filters": {
"type": "MissingValue",
"fieldName": "OrderQuantity"
}
};