What is the query used to filter infotable for missing values in particular Columns.

[AP_10343008]

What is the query used to filter infotable for missing values in particular Columns.

[DanZ · Accepted 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"
    }
};