Create a new grouping for the WHERE or HAVING clause.

Parameters

string $type: Either 'AND' or 'OR'. All items within this group will be added to the WHERE clause with this logical operator.

string $group: An ID to use for this group. If unspecified, an ID will be generated.

string $where: 'where' or 'having'.

Return value

string The group ID generated.

4 calls to views_plugin_query::set_where_group()

views_plugin_query_default::add_having in plugins/views_plugin_query_default.inc

Add a simple HAVING clause to the query.

views_plugin_query_default::add_having_expression in plugins/views_plugin_query_default.inc

Add a complex HAVING clause to the query.

views_plugin_query_default::add_where in plugins/views_plugin_query_default.inc

Add a simple WHERE clause to the query.

views_plugin_query_default::add_where_expression in plugins/views_plugin_query_default.inc

Add a complex WHERE clause to the query.

File

plugins/views_plugin_query.inc, line 169

Class

views_plugin_query

The base query class, which is the underlying layer in a View.

Code

public function set_where_group($type = 'AND', $group = NULL, $where = 'where') {
    // Set an alias.
    $groups =& $this->{$where};
    if (!isset($group)) {
        $group = empty($groups) ? 1 : max(array_keys($groups)) + 1;
    }
    // Create an empty group.
    if (empty($groups[$group])) {
        $groups[$group] = array(
            'conditions' => array(),
            'args' => array(),
        );
    }
    $groups[$group]['type'] = strtoupper($type);
    return $group;
}