1 views_plugin_query_default.inc | views_plugin_query_default::add_having_expression($group, $snippet, $args = array()) |
Add a complex HAVING clause to the query. The caller is responsible for ensuring that all fields are fully qualified (TABLE.FIELD) and that the table and an appropriate GROUP BY already exist in the query. Internally the database "having" method is used.
Parameters
$group: The HAVING group to add these to; groups are used to create AND/OR sections. Groups cannot be nested. Use 0 as the default group. If the group does not yet exist it will be created as an AND group.
$snippet: The snippet to check. This can be either a column or a complex expression like "COUNT(table.field) > 3"
$args: An associative array of arguments. Placeholders must be unique when using this method multiple times on a single query.
See also
https://www.php.net/manual/en/pdo.prepare.php
QueryConditionInterface::where()
File
- core/
modules/ views/ plugins/ views_plugin_query_default.inc, line 987 - Defines the default query object.
Class
- views_plugin_query_default
- Object used to create a SELECT query.
Code
function add_having_expression($group, $snippet, $args = array()) {
// Ensure all variants of 0 are actually 0. Thus '', 0 and NULL are all
// the default group.
if (empty($group)) {
$group = 0;
}
// Check for a group.
if (!isset($this->having[$group])) {
$this->set_where_group('AND', $group, 'having');
}
// Add the clause and the args.
$this->having[$group]['conditions'][] = array(
'field' => $snippet,
'value' => $args,
'operator' => 'formula',
);
}