Enterprise - does where statement support or and null?

How can I put in GC the following where statement:

status = ‘Active’ or status is null?

Hello @GabrielD ,

Yes it is possible to have that. The trick here is to use the string as a value and the parenthesis. So more specifically for your example you should use:

$crud->where("(status='Active' OR status IS NULL)");

The parenthesis is very important or else you will have issues with the quick filters.

Hope it helped.

Regards
Johnny