SelectExtender::isNotNull($field) Sets a condition that the specified field be NOT NULL. Parameters $field: The name of the field to check. Return value \Drupal\Core\Database\Query\ConditionInterface The called object. Overrides ConditionInterface::isNotNull File core/lib/Drupal/Core/Database/Query/SelectExtender.php, line 451 Class SelectExtender The base extender class for Select queries. Namespace Drupal\Core\Database\Query Code function isNotNull($field) { $this->query->i

public SelectExtender::innerJoin($table, $alias = NULL, $condition = NULL, $arguments = array()) Inner Join against another table in the database. Parameters $table: The table against which to join. May be a string or another SelectQuery object. If a query object is passed, it will be used as a subselect. Unless the table name starts with the database / schema name and a dot it will be prefixed. $alias: The alias for the table. In most cases this should be the first letter of the table, or the

public SelectExtender::havingNotExists(SelectInterface $select) Sets a HAVING condition that the specified subquery returns no values. Parameters \Drupal\Core\Database\Query\SelectInterface $select: The subquery that must contain results. Return value $this Overrides SelectInterface::havingNotExists File core/lib/Drupal/Core/Database/Query/SelectExtender.php, line 208 Class SelectExtender The base extender class for Select queries. Namespace Drupal\Core\Database\Query Code public fun

public SelectExtender::havingIsNull($field) Sets a condition in the HAVING clause that the specified field be NULL. Parameters $field: The name of the field to check. Return value $this Overrides SelectInterface::havingIsNull File core/lib/Drupal/Core/Database/Query/SelectExtender.php, line 184 Class SelectExtender The base extender class for Select queries. Namespace Drupal\Core\Database\Query Code public function havingIsNull($field) { $this->query->havingIsNull($field);

public SelectExtender::havingIsNotNull($field) Sets a condition in the HAVING clause that the specified field be NOT NULL. Parameters $field: The name of the field to check. Return value $this Overrides SelectInterface::havingIsNotNull File core/lib/Drupal/Core/Database/Query/SelectExtender.php, line 192 Class SelectExtender The base extender class for Select queries. Namespace Drupal\Core\Database\Query Code public function havingIsNotNull($field) { $this->query->havingIsNot

public SelectExtender::havingExists(SelectInterface $select) Sets a HAVING condition that the specified subquery returns values. Parameters \Drupal\Core\Database\Query\SelectInterface $select: The subquery that must contain results. Return value $this Overrides SelectInterface::havingExists File core/lib/Drupal/Core/Database/Query/SelectExtender.php, line 200 Class SelectExtender The base extender class for Select queries. Namespace Drupal\Core\Database\Query Code public function hav

public &SelectExtender::havingConditions() Gets a list of all conditions in the HAVING clause. This method returns by reference. That allows alter hooks to access the data structure directly and manipulate it before it gets compiled. Return value array An array of conditions. Overrides SelectInterface::havingConditions See also \Drupal\Core\Database\Query\ConditionInterface::conditions() File core/lib/Drupal/Core/Database/Query/SelectExtender.php, line 155 Class SelectExtender The ba

public SelectExtender::havingCondition($field, $value = NULL, $operator = '=') Helper function to build most common HAVING conditional clauses. This method can take a variable number of parameters. If called with two parameters, they are taken as $field and $value with $operator having a value of IN if $value is an array and = otherwise. Parameters $field: The name of the field to check. If you would like to add a more complex condition involving operators or functions, use having(). $value: T

public SelectExtender::havingCompile(Connection $connection) Compiles the HAVING clause for later retrieval. Parameters $connection: The database connection for which to compile the clause. Overrides SelectInterface::havingCompile File core/lib/Drupal/Core/Database/Query/SelectExtender.php, line 177 Class SelectExtender The base extender class for Select queries. Namespace Drupal\Core\Database\Query Code public function havingCompile(Connection $connection) { return $this->query-

public SelectExtender::havingArguments() Gets a list of all values to insert into the HAVING clause. Return value array An associative array of placeholders and values. Overrides SelectInterface::havingArguments File core/lib/Drupal/Core/Database/Query/SelectExtender.php, line 162 Class SelectExtender The base extender class for Select queries. Namespace Drupal\Core\Database\Query Code public function havingArguments() { return $this->query->havingArguments(); }