cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Need to share some code when posting a question or reply? Make sure to use the "Insert code sample" menu option. Learn more! X

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

benr
1-Newbie

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

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?

1 ACCEPTED SOLUTION

Accepted Solutions
benr
1-Newbie
(To:benr)

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

query = {

     "filters": {

          "fieldName": "AssignedUser",

          "type": "MISSINGVALUE"

     }

};

View solution in original post

4 REPLIES 4
benr
1-Newbie
(To:benr)

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

query = {

     "filters": {

          "fieldName": "AssignedUser",

          "type": "MISSINGVALUE"

     }

};

am-3
1-Newbie
(To:benr)

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
1-Newbie
(To:am-3)

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
1-Newbie
1-Newbie
(To:am-3)

Maybe QueryNamedPropertyHistory ?

Top Tags