function QueryAggregateInterface::execute

Executes the aggregate query.

$result = $query->aggregate('nid', 'count')
    ->condition('status', 1)
    ->groupby('type')
    ->executeAggregate();

Will return:

$result[0] = array(
    'count_nid' => 3,
    'type' => 'page',
);
$result[1] = array(
    'count_nid' => 1,
    'type' => 'poll',
);
$result[2] = array(
    'count_nid' => 4,
    'type' => 'story',
);

Return value

array A list of result row arrays. Each result row contains the aggregate results as keys and also the groupBy columns as keys:

Overrides QueryInterface::execute

File

core/lib/Drupal/Core/Entity/Query/QueryAggregateInterface.php, line 152

Class

QueryAggregateInterface

Defines a interface for aggregated entity queries.

Namespace

Code

public function execute();