Definition

Filter::field('price', [FilterType::NOT_BETWEEN_COLUMNS]);

Array/Object Structure

target
string
required
value
array,size:2
required
value.*
string
required

Example

$filter = [
    'type'   => '$notBetweenColumns',
    'target' => 'price',
    'value'  => [
        'min_allowed_price',
        'max_allowed_price',
    ],
];
$sql = Product::filter([$filter])->toRawSql();

SQL

select
  *
from
  "products"
where
  "products"."price" not between "products"."min_allowed_price"
  and "products"."max_allowed_price"

Modifiers

None available.