Eloquent Filtering Laravel Package

title: 'Not Between' version: 'v2' icon: 'arrows-left-right-to-line' iconType: 'solid'

Definition

Filter::field('age', [FilterType::NOT_BETWEEN]);

Array/Object Structure

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

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

Example

$filter = [
    'type'   => '$notBetween',
    'target' => 'age',
    'value'  => [18, 65,],
];

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

SQL

select * from "people" where "people"."age" not between 18 and 65

Modifiers

None available.