Skip to main content
B
benr1-Visitor
1-Visitor
July 9, 2015
Solved

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

  • July 9, 2015
  • 4 replies
  • 2929 views

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?

    Best answer by benr

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

    query = {

         "filters": {

              "fieldName": "AssignedUser",

              "type": "MISSINGVALUE"

         }

    };

    4 replies

    B
    benr1-VisitorAuthorAnswer
    1-Visitor
    July 9, 2015

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

    query = {

         "filters": {

              "fieldName": "AssignedUser",

              "type": "MISSINGVALUE"

         }

    };

      A
      am-31-Visitor
      1-Visitor
      October 27, 2015

      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.

      P
      paic1-Visitor
      1-Visitor
      October 27, 2015

      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)

      Terms & ConditionsAccessibility statement