Skip to main content
DanZAnswer
15-Moonstone
Apr 3, 2024 12:36 PM UTC

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
Apr 3, 2024 12:36 PM UTC

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