Trait QueryFilterTrait

Create query filter using various operators on fields Options array must contain fields as keys and operators like - 'gt' or '>' (greather than) - 'lt' or '<' (less than), - 'ge' or '>=' (greater or equal) - 'le' or '<=' (less or equal) with a date

It's also possible to specify an expected value or a list of values for a field

Options array examples:

// field1 greater than 10, field2 less then 5
['field1' => ['gt' => 10], 'field2' => ['lt' => 5]];

// field1 in [1, 3, 10]
['field1' => [1, 3, 10]];

// a comma separated string has the same effect as a list of values
['field1' => '1,3,10'];

// field1 equals 10, field2 equals 1
['field1' => 10, 'field1' => ['eq' => 1]];

// field1 greater or equal 5, field2 less or equal 4
['field1' => ['>=' => 10], 'field2' => ['<=' => 4]];

// field1 is null, field2 is not null, field3 is null
['field1' => ['null' => 1], 'field2' => ['null' => 0], 'field3' => null];

//

Parameters

Returns

Get query expression for an operator on a field with a value. Unrecognized operators are ignored and have no effect.

Parameters

Returns