How to get rows with blank datetime fields in an infotable
I'm trying to get rows in an infotable that have empty datetime fields. The following is the code for the query, but I'm unable to get any results. When I log the values of the empty datetime fields with logger, it says the value is undefined. I've tried using various falsy values as the value, but it did not work.
let query = {
"filters": {
"type": "EQ",
"fieldName": "SomeDate",
"value": "" // <--- have tried various falsy values (false, 0, -0, "", '', null, undefined, NaN)
}
};
result = Resources["InfoTableFunctions"].Query({
t: result /* INFOTABLE */ ,
query: query /* QUERY */
});

