[Solved] filtering a field for nulls

[Cecil]

How would I set up a filter that looked for null values in a numberic field?

filter currently looks like this:

'$and': [
                { 'CompanyId': null },
                { 'IsActive': true }
            ]

 

If I look for a value in CompanyId it works, but trying find items with null values (or "Not set") finds nothing.

[Rosen]

Hello Cecil,

We current version of Kendo UI we have added isnull and isnotnull filter operators. You should use them in order to filter only values which are null.

Regards,
Rosen
Telerik

 

 

[Cecil]

Is there a value such as {field: 'CompanyId', operator: 'isnull', value true}?

Because I know it's got to be looking for something.

[Rosen]

Hello Cecil,

You can omit the value as the operator itself is holding the context: { field: "CompanyId", operator: "isnull" }

Regards,
Rosen
Telerik