Select::countQuery

public Select::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/Select.php, line 703

Class

Select: Query builder for SELECT statements.

Namespace

Drupal\Core\Database\Query

Code

public function countQuery() {
  $count = $this->prepareCountQuery();
 
  $query = $this->connection->select($count, NULL, $this->queryOptions);
  $query->addExpression('COUNT(*)');
 
  return $query;
}

Links:

https://api.drupal.org/api/drupal/core%21lib%21Drupal%21Core%21Database%21Query%21Select.php/function/Select%3A%3AcountQuery/8.2.x

doc_Drupal

2025-01-10 15:47:30

Comments

Popular Articles

SelectInterface::countQuery public SelectInterface::countQuery() Get the equivalent COUNT query of this query as a new query object. Return value \Drupal\Core\Database\Query\Se

SearchQuery::countQuery public SearchQuery::countQuery() Builds the default count query for SearchQuery. Since SearchQuery always uses GROUP BY, we can default to a subquery

SelectExtender::countQuery public SelectExtender::countQuery() Get the equivalent COUNT query of this query as a new query object. Return value \Drupal\Core\Database\Query\Sel

select.select() select.select(rlist, wlist, xlist[, timeout]) This is a straightforward interface to the Unix select() system call. The first three arguments are

selection.select() selection.select(selector) For each selected element, selects the first descendant element that matches the specified selector string. If no eleme