4 Replies Latest reply on Jan 17, 2018 3:32 PM by benr 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?