public SelectExtender::orderBy($field, $direction = 'ASC') Orders the result set by a given field. If called multiple times, the query will order by each specified field in the order this method is called. If the query uses DISTINCT or GROUP BY conditions, fields or expressions that are used for the order must be selected to be compatible with some databases like PostgreSQL. The PostgreSQL driver can handle simple cases automatically but it is suggested to explicitly specify them. Additionally,

public SelectExtender::notExists(SelectInterface $select) Sets a condition that the specified subquery returns no values. Parameters \Drupal\Core\Database\Query\SelectInterface $select: The subquery that must not contain results. Return value \Drupal\Core\Database\Query\ConditionInterface The called object. Overrides ConditionInterface::notExists File core/lib/Drupal/Core/Database/Query/SelectExtender.php, line 467 Class SelectExtender The base extender class for Select queries. Namesp

public SelectExtender::orderRandom() Orders the result set by a random value. This may be stacked with other orderBy() calls. If so, the query will order by each specified field, including this one, in the order called. Although this method may be called multiple times on the same query, doing so is not particularly useful. Note: The method used by most drivers may not scale to very large result sets. If you need to work with extremely large data sets, you may create your own database driver by

public SelectExtender::preExecute(SelectInterface $query = NULL) Generic preparation and validation for a SELECT query. Return value TRUE if the validation was successful, FALSE if not. Overrides SelectInterface::preExecute File core/lib/Drupal/Core/Database/Query/SelectExtender.php, line 297 Class SelectExtender The base extender class for Select queries. Namespace Drupal\Core\Database\Query Code public function preExecute(SelectInterface $query = NULL) { // If no query object is p

public SelectExtender::orConditionGroup() Creates a new group of conditions ORed together. Return value \Drupal\Core\Database\Query\ConditionInterface Overrides ConditionInterface::orConditionGroup File core/lib/Drupal/Core/Database/Query/SelectExtender.php, line 532 Class SelectExtender The base extender class for Select queries. Namespace Drupal\Core\Database\Query Code public function orConditionGroup() { return $this->conditionGroupFactory('OR'); }

public SelectExtender::isPrepared() Indicates if preExecute() has already been called on that object. Return value TRUE is this query has already been prepared, FALSE otherwise. Overrides SelectInterface::isPrepared File core/lib/Drupal/Core/Database/Query/SelectExtender.php, line 290 Class SelectExtender The base extender class for Select queries. Namespace Drupal\Core\Database\Query Code public function isPrepared() { return $this->query->isPrepared(); }

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::join($table, $alias = NULL, $condition = NULL, $arguments = array()) Default Join against another table in the database. This method is a convenience method for innerJoin(). 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 th

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

public SelectExtender::nextPlaceholder() Returns the next placeholder ID for the query. Return value The next available placeholder ID as an integer. Overrides PlaceholderInterface::nextPlaceholder File core/lib/Drupal/Core/Database/Query/SelectExtender.php, line 52 Class SelectExtender The base extender class for Select queries. Namespace Drupal\Core\Database\Query Code public function nextPlaceholder() { return $this->placeholder++; }