4 Replies Latest reply on Nov 25, 2015 8:15 AM by qn RSS
    benr 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?