Not In

Definition

Filter::field('name', [FilterType::NOT_IN]);

string

required

array,min:1

required

string|int|float

required

$filter = [
    'type'   => '$notIn',
    'target' => 'name',
    'value'  => ['Nuno', 'Maduro',]
];

$sql = Person::filter([$filter])->toRawSql();

select * from "people" where "people"."name" not in ('Nuno', 'Maduro')

select *
from "people"
where (
    "people"."name" not in ('Nuno', 'Maduro')
    and
    "people"."name" is not null
)