search_criteria
class search_criteria
| internal |
Filtering criteria for Item main table columns.
Used by the Query Builder to construct SQL WHERE clauses.
Represents filtering criteria for item searches (Main Table columns). Supports multiple conditions on the same field (e.g., ranges).
Examples: $criteria->where('timecreated', operator::GTE, $start); $criteria->where('timecreated', operator::LTE, $end); $criteria->where_in('status', ['published', 'draft']);
Properties
| array | $filters |
Methods
where(string $field, operator $op, mixed $value, mixed $value2 = null)
Add a condition.
where_in(string $field, array $values)
Add WHERE IN condition.
where_not_in(string $field, array $values)
Add WHERE NOT IN condition.
raw(string $field, string $sql)
Add raw SQL condition.
bool
has_filters()
Check if there are any filters defined.
Details
at line 58
search_criteria
where(string $field, operator $op, mixed $value, mixed $value2 = null)
Add a condition.
at line 78
search_criteria
where_in(string $field, array $values)
Add WHERE IN condition.
at line 98
search_criteria
where_not_in(string $field, array $values)
Add WHERE NOT IN condition.
at line 119
search_criteria
raw(string $field, string $sql)
Add raw SQL condition.
USE CAREFULLY. Prefer structured queries.
at line 134
bool
has_filters()
Check if there are any filters defined.