93 $alias =
function (
$column) use ($table_alias) {
94 return $table_alias ?
"{$table_alias}.{$column}" :
$column;
98 $wheres[] = parent::prepare($qb, $table_alias);
104 $wheres[] =
$access->prepare($qb, $table_alias);
108 $wheres[] =
$type->prepare($qb, $table_alias);
119 return $qb->
merge($wheres);
129 $where =
new static();
130 $where->guids = $options->guids;
131 $where->owner_guids = $options->owner_guids;
132 $where->container_guids = $options->container_guids;
133 $where->type_subtype_pairs = $options->type_subtype_pairs;
134 $where->created_after = $options->created_after;
135 $where->created_before = $options->created_before;
136 $where->updated_after = $options->updated_after;
137 $where->updated_before = $options->updated_before;
138 $where->last_action_after = $options->last_action_after;
139 $where->last_action_before = $options->last_action_before;
140 $where->access_ids = $options->access_ids;
Database abstraction query builder.
prepare(QueryBuilder $qb, $table_alias= '')
{}
Builds queries for filtering entities by their properties in the entities table.
between($x, $lower=null, $upper=null, $type=null)
Build a between clause.
compare($x, $comparison, $y=null, $type=null, $case_sensitive=null)
Build value comparison clause.
static factory(QueryOptions $options)
Build new clause from options.
const ELGG_VALUE_TIMESTAMP
Builds clauses for filtering entities by their type and subtype.
Builds a clause from closure or composite expression.
merge($parts=null, $boolean= 'AND')
Merges multiple composite expressions with a boolean.
Builds queries to restrict access.