Eloquent Filtering Laravel Package

title: 'Not In' version: 'v2' icon: 'brackets-square' iconType: 'solid'

Definition

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

Array/Object Structure

import TypeParameterField from '/snippets/type-parameter-field.mdx';

import TargetParameterField from '/snippets/target-parameter-field.mdx';

Example

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

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

SQL

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

Modifiers

Null

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