public SelectExtender::escapeField($string) Escapes a field name string. Force all field names to be strictly alphanumeric-plus-underscore. For some database drivers, it may also wrap the field name in database-specific escape characters. Parameters string $string: An unsanitized field name. Return value The sanitized field name string. Overrides SelectInterface::escapeField File core/lib/Drupal/Core/Database/Query/SelectExtender.php, line 275 Class SelectExtender The base extender class

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::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::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::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::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::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::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::addField($table_alias, $field, $alias = NULL) Adds a field to the list to be SELECTed. Parameters $table_alias: The name of the table from which the field comes, as an alias. Generally you will want to use the return value of join() here to ensure that it is valid. $field: The name of the field. $alias: The alias for this field. If not specified, one will be generated automatically based on the $table_alias and $field. The alias will be checked for uniqueness, so the req