Correct way to programmatically get $total_rows for a View

D34dMan created an issue. See original summary.

When inspecting views.tokens.inc it shows that the token "total-rows" is returned as count($view->result);. This makes me wonder if $view->total_rows has any significance at all.

use Drupal\views\Views;
$view = Views::getView('export_patient_csv');
$view->get_total_rows = TRUE;
$view->execute('patient');
$rows = $view->total_rows;
dpm($rows, 'rows');

This is basically what you need :)

Thanks for the quick response, much appreciated.

However, i tried the suggestion and its still giving back 2^62.

Here is the code i used for testing in devel/php.

use Drupal\views\Views;

$view = Views::getView('export_patient_csv');
$view->get_total_rows = TRUE;
$view->execute('patient');
$rows = $view->total_rows;
dpm($rows, '$view->total_rows');

$view = Views::getView('export_patient_csv');
$view->setItemsPerPage(0);
$view->execute('patient');
$total_rows = count($view->result);
dpm($total_rows, 'count($view->result)');

And the output was

$view->total_rows => 4.6116860184274E+18
count($view->result) => 522

$view->get_total_rows says in todo to move it to count query. That inspired me to try the query way of getting the count.

The following code gives back the correct count.

use Drupal\views\Views;
$view = Views::getView('export_patient_csv');
$view->build('patient');
$q = $view->query->query()->countQuery()->execute()->fetchAssoc();
$count = reset($q);
dpm($count, '$view->query->query()->countQuery()->execute()->fetchAssoc()');

You can also use fetchField(); to save yourself the reset() function call afterwards :)

$total_rows = $view->query->query()->countQuery()->execute()->fetchField();

Hi all I, How to sort the workflow,

Hi all, How to sort the workflow,

Pleased to confirm that this solution also works in Drupal 9, 9.3.3: https://www.drupal.org/project/drupal/issues/2797565#comment-11907615

I haven't tried the others yet. But thank you to the solution provider, the question asker and everyone else who contributed.

The last responses provided are truly the correct ones. Just adding here for anyone coming from search engines that in case your View is an indexed view using search_api (ex. Solr), then the correct approach is this one:

  $view = Views::getView('the_id_of_the_view');
  $view->build('the_display_of_the_view');
  $total_rows = $view->query->query()->getResults()->getResultCount();