$columnSchemaClass public property (available since version 2.0.11) Column schema class public string $columnSchemaClass = 'yii\db\ColumnSchema'

where() public method Sets the WHERE part of the query. See yii\db\QueryInterface::where() for detailed documentation. See also: andWhere() orWhere() public $this where ( $condition )$condition string|array The conditions that should be put in the WHERE part. return $this The query object itself

orWhere() public method Adds an additional WHERE condition to the existing one. The new condition and the existing one will be joined using the 'OR' operator. See also: where() andWhere() public $this orWhere ( $condition )$condition string|array The new WHERE condition. Please refer to where() on how to specify this parameter. return $this The query object itself

orFilterWhere() public method Adds an additional WHERE condition to the existing one but ignores empty operands. The new condition and the existing one will be joined using the 'OR' operator. This method is similar to orWhere(). The main difference is that this method will remove empty query operands. As a result, this method is best suited for building query conditions based on filter values entered by users. See also: filterWhere() andFilterWhere() public $this orFilterWhere ( array $co

orderBy() public method Sets the ORDER BY part of the query. See also addOrderBy(). public $this orderBy ( $columns )$columns string|array|yii\db\Expression The columns (and the directions) to be ordered by. Columns can be specified in either a string (e.g. "id ASC, name DESC") or an array (e.g. ['id' => SORT_ASC, 'name' => SORT_DESC]). The method will automatically quote the column names unless a column contains some parenthesis (which means the column contains a DB expression).

offset() public method Sets the OFFSET part of the query. public $this offset ( $offset )$offset integer The offset. Use null or negative value to disable offset. return $this The query object itself

normalizeOrderBy() protected method Normalizes format of ORDER BY data protected array normalizeOrderBy ( $columns )$columns array|string|yii\db\Expression The columns value to normalize. See orderBy() and addOrderBy().

limit() public method Sets the LIMIT part of the query. public $this limit ( $limit )$limit integer The limit. Use null or negative value to disable limit. return $this The query object itself

isEmpty() protected method Returns a value indicating whether the give value is "empty". The value is considered "empty", if one of the following conditions is satisfied: it is null, an empty string (''), a string containing only whitespace characters, or an empty array. protected boolean isEmpty ( $value )$value mixed return boolean If the value is empty

indexBy() public method Sets the indexBy() property. public $this indexBy ( $column )$column string|callable The name of the column by which the query results should be indexed by. This can also be a callable (e.g. anonymous function) that returns the index value based on the given row data. The signature of the callable should be: function ($row) { // return the index value corresponding to $row } return $this The query object itself