How can you query for undefined values in a data table?

[benr]

If I create a query like this:

query = {

     "filters": {

          "fieldName": "AssignedUser",

          "type": "EQ",

          "value": userName

     }

};

...then I can run that against a data table as long as userName has a value. But if I want to find rows where AssignedUser is undefined, then I can't just make userName undefined, and making it "undefined" would search for that literal string value.

I remember some special syntax where "type" was "ISUNDEFINED" or something similar. Can someone provide the correct query?

[benr · Accepted solution]

I think I found it - this seems to do what I want.

query = {

     "filters": {

          "fieldName": "AssignedUser",

          "type": "MISSINGVALUE"

     }

};

[am-3]

Hi ,

Nice. But The above query returns the records matching the AssignedUser value as "MissingValue".

Is it possible to fetch the particular column alone? Say the username field alone satisfying the above query.

[paic]

You can limit the output of the Query by using a DataShape.

These particular services won't allow for 'picking' specific columns. (A few have it like UNION)

[qn]

Maybe QueryNamedPropertyHistory ?