public SelectExtender::distinct($distinct = TRUE) Sets this query to be DISTINCT. Parameters $distinct: TRUE to flag this query DISTINCT, FALSE to disable it. Return value \Drupal\Core\Database\Query\SelectInterface The called object. Overrides SelectInterface::distinct File core/lib/Drupal/Core/Database/Query/SelectExtender.php, line 323 Class SelectExtender The base extender class for Select queries. Namespace Drupal\Core\Database\Query Code public function distinct($distinct = TRU

public SelectExtender::countQuery() Get the equivalent COUNT query of this query as a new query object. Return value \Drupal\Core\Database\Query\SelectInterface A new SelectQuery object with no fields or expressions besides COUNT(*). Overrides SelectInterface::countQuery File core/lib/Drupal/Core/Database/Query/SelectExtender.php, line 436 Class SelectExtender The base extender class for Select queries. Namespace Drupal\Core\Database\Query Code public function countQuery() { return

public &SelectExtender::conditions() Gets a complete list of all conditions in this conditional clause. This method returns by reference. That allows alter hooks to access the data structure directly and manipulate it before it gets compiled. The data structure that is returned is an indexed array of entries, where each entry looks like the following: array( 'field' => $field, 'value' => $value, 'operator' => $operator, ); In the special case that $operator is NULL, the $fi

public SelectExtender::conditionGroupFactory($conjunction = 'AND') Creates an object holding a group of conditions. See andConditionGroup() and orConditionGroup() for more. Parameters $conjunction: AND (default): this is the equivalent of andConditionGroup(). OR: this is the equivalent of andConditionGroup(). Return value \Drupal\Core\Database\Query\ConditionInterface An object holding a group of conditions. Overrides ConditionInterface::conditionGroupFactory File core/lib/Drupal/Core/Dat

public SelectExtender::condition($field, $value = NULL, $operator = '=') Helper function: builds the most common 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 =. Do not use this method to test for NULL values. Instead, use QueryConditionInterface::isNull() or QueryConditionInterface::isNotNull(). Drupal considers LIKE case insensitive and the following is often used t

public SelectExtender::compiled() Check whether a condition has been previously compiled. Return value TRUE if the condition has been previously compiled. Overrides ConditionInterface::compiled File core/lib/Drupal/Core/Database/Query/SelectExtender.php, line 140 Class SelectExtender The base extender class for Select queries. Namespace Drupal\Core\Database\Query Code public function compiled() { return $this->query->compiled(); }

public SelectExtender::compile(Connection $connection, PlaceholderInterface $queryPlaceholder) Compiles the saved conditions for later retrieval. This method does not return anything, but simply prepares data to be retrieved via __toString() and arguments(). Parameters $connection: The database connection for which to compile the conditionals. $queryPlaceholder: The query this condition belongs to. If not given, the current query is used. Overrides ConditionInterface::compile File core/lib/Dru

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

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

public SelectExtender::addTag($tag) Adds a tag to a query. Tags are strings that identify a query. A query may have any number of tags. Tags are used to mark a query so that alter hooks may decide if they wish to take action. Tags should be all lower-case and contain only letters, numbers, and underscore, and start with a letter. That is, they should follow the same rules as PHP identifiers in general. Parameters $tag: The tag to add. Return value \Drupal\Core\Database\Query\AlterableInterfac