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

public SelectExtender::addJoin($type, $table, $alias = NULL, $condition = NULL, $arguments = array()) Join against another table in the database. This method does the "hard" work of queuing up a table to be joined against. In some cases, that may include dipping into the Schema API to find the necessary fields on which to join. Parameters $type: The type of join. Typically one one of INNER, LEFT OUTER, and RIGHT OUTER. $table: The table against which to join. May be a string or another SelectQ

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

public SelectExtender::addExpression($expression, $alias = NULL, $arguments = array()) Adds an expression to the list of "fields" to be SELECTed. An expression can be any arbitrary string that is valid SQL. That includes various functions, which may in some cases be database-dependent. This method makes no effort to correct for database-specific functions. Parameters $expression: The expression string. May contain placeholders. $alias: The alias for this expression. If not specified, one will

The base extender class for Select queries. Hierarchy class \Drupal\Core\Database\Query\SelectExtender implements SelectInterface File core/lib/Drupal/Core/Database/Query/SelectExtender.php, line 10 Namespace Drupal\Core\Database\Query Members Name Modifiers Type Description SelectExtender::$connection protected property The connection object on which to run this query. SelectExtender::$placeholder protected property The placeholder counter. SelectExtender::$qu

The placeholder counter. File core/lib/Drupal/Core/Database/Query/SelectExtender.php, line 34 Class SelectExtender The base extender class for Select queries. Namespace Drupal\Core\Database\Query Code protected $placeholder = 0;

The connection object on which to run this query. Type: \Drupal\Core\Database\Connection File core/lib/Drupal/Core/Database/Query/SelectExtender.php, line 24 Class SelectExtender The base extender class for Select queries. Namespace Drupal\Core\Database\Query Code protected $connection;

The Select query object we are extending/decorating. Type: \Drupal\Core\Database\Query\SelectInterface File core/lib/Drupal/Core/Database/Query/SelectExtender.php, line 17 Class SelectExtender The base extender class for Select queries. Namespace Drupal\Core\Database\Query Code protected $query;

A unique identifier for this query object. File core/lib/Drupal/Core/Database/Query/SelectExtender.php, line 29 Class SelectExtender The base extender class for Select queries. Namespace Drupal\Core\Database\Query Code protected $uniqueIdentifier;

public Select::__toString() Implements PHP magic __toString method to convert the query to a string. The toString operation is how we compile a query object to a prepared statement. Return value string A prepared statement query string for this object. Overrides Query::__toString File core/lib/Drupal/Core/Database/Query/Select.php, line 778 Class Select Query builder for SELECT statements. Namespace Drupal\Core\Database\Query Code public function __toString() { // For convenience, w