> ## Documentation Index
> Fetch the complete documentation index at: https://docs.eloquentfiltering.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Not Between Columns

export const type_0 = "$notBetweenColumns"

## Definition

```php theme={null}
Filter::field('price', [FilterType::NOT_BETWEEN_COLUMNS]);
```

## Array/Object Structure

<ParamField body="type" type="string" required>
  <code>
    {type_0}
  </code>
</ParamField>

<ParamField body="target" type="string" required />

<ParamField body="value" type="array,size:2" required />

<ParamField body="value.*" type="string" required />

## Example

```php theme={null}
$filter = [
    'type'   => '$notBetweenColumns',
    'target' => 'price',
    'value'  => [
        'min_allowed_price',
        'max_allowed_price',
    ],
];
```

```php theme={null}
$sql = Product::filter([$filter])->toRawSql();
```

### SQL

```sql theme={null}
select
  *
from
  "products"
where
  "products"."price" not between "products"."min_allowed_price"
  and "products"."max_allowed_price"
```

## Modifiers

None available.