And - Eloquent Filtering

Definition

The condition filters $or, and $and are not required to be defined when allowing filters.These filters are always allowed, due to these filters essentially being wrappers around other filters.

Array/Object Structure

value

array,min:2

required

value.*

array

required

Any other filter

Example

$filter = [
    'type'  => '$and',
    'value' => [
        [
            'type'   => '$like',
            'target' => 'content',
            'value'  => 'is awesome',
        ],
        [
            'type'   => '$like',
            'target' => 'content',
            'value'  => 'is not boring',
        ]
    ]
];

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

SQL

select *
  from "comments"
 where (
       ("comments"."content" LIKE '%is awesome%')
    and
       ("comments"."content" LIKE '%is not boring%')
 )

Modifiers

None available.

Doesnt Has Morph Or

​Definition

​Array/Object Structure

​Example

​SQL

​Modifiers

Definition

Array/Object Structure

Example

SQL

Modifiers