> ## 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 In

export const type_1 = "$notIn:null"

export const type_0 = "$notIn"

## Definition

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

## 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,min:1" required />

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

## Example

```php theme={null}
$filter = [
    'type'   => '$notIn',
    'target' => 'name',
    'value'  => ['Nuno', 'Maduro',]
];
```

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

### SQL

```sql theme={null}
select * from "people" where "people"."name" not in ('Nuno', 'Maduro')
```

## Modifiers

### Null

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

```sql theme={null}
select *
from "people"
where (
    "people"."name" not in ('Nuno', 'Maduro')
    and
    "people"."name" is not null
)
```