Or - 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

array,min:2

required

array

required

Any other filter

Example

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

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

SQL

select *
  from "comments"
 where (
       ("comments"."content" LIKE '%awesome%')
    or
       ("comments"."content" LIKE '%boring%')
 )

Modifiers

None available.

And Aliasing Targets

Introduction

Basics

Available Filters

Digging Deeper

Sorting

Or

Definition

Array/Object Structure

Example

SQL

Modifiers

​Definition

​Array/Object Structure

​Example

​SQL

​Modifiers

Definition

Array/Object Structure

Example

SQL

Modifiers