Skip to main content
Best answer by DanZ

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"
 }
};

1 reply

DanZ15-MoonstoneAnswer
15-Moonstone
April 3, 2024

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"
 }
};