Get total row count in views-view-fields.html.twig

Question

How can I get the total rows number in views-view-fields.html.twig template file in Drupal 8? In Drupal 7, I can get it by the following code.

$view = views_get_current_view();
$view->total_rows;

Is there any variable to render the total number of rows in Drupal 8?

Answer 1

You can use simple code {{ view.total_rows }} in every file template views. Variable view is global.

Answer 2

In Drupal 8, views-view.html.twig contains few pre defined variables. Among them, there is a {{ rows }} variable that contains "The results of the view query, if any."

To get total number of row count, use {{ rows | length }}. It will print total number of rows count and if you want it in a variable, do as {% set count = rows | length %}

Answer 3

you can use {{ view.result | length }} in views-view-fields.html.twig

Answer 4

If you use an exposed filter and want to show the unfiltered number of total results (like "we are showing you 12 items out of total 345 items"), this gets slightly more complicated. In a preprocess_views_view or any other preprocess which gets the view as a variable, run

  // Pass original view row count to template
  $pager = \Drupal::service('pager_manager');
  $pager = $pager_manager->getPager();
  $request_stack = \Drupal::requestStack();
  $request = clone ($request_stack->getCurrentRequest());
  $request->query = new ParameterBag;
  $request_stack->push($request);
  $original_view = $variables['view'];
  $view = Views::getView($original_view->id());
  $view->setDisplay($original_view->current_display);
  $view->preExecute($original_view->args);
  $view->execute();
  $view->postExecute();
  $request_stack->pop();
  $pager_manager->createPager($pager->getTotalItems(), $pager->getLimit());
  $variables['total_rows'] = $view->total_rows;

Answer 5

One another way to get the total row counts is by directly querying the database for the results. You can use something like below:

$total_results = \Drupal::database()
  ->select('view_name')
  ->countQuery()
  ->execute()
  ->fetchField();