Alter views limit using hook_views_query_alter

Question

I've used display specified number of items for set limit in views. I want to change limit and also display all items using hook_views_query_alter(). I've tried this:

function test_views_query_alter(&$view, &$query) {
  if ($view->name == 'sample') {
    $query->set_limit(20);
    //~ $view->set_items_per_page(20);
  }
}

But i've no luck. How to solve this?

Answer 1

Try using the following:

function YOUR_MODULE_NAME_views_query_alter(&$view, &$query) { 
    $view->set_items_per_page(2);     
}

Answer 2

Drupal 8.

I created views in rest mode for send 10 items per page. But the native pager was not works for me. So, I implemented hook_views_query_alter() for set up custom pager settings with limit and offset.

1) Create custom_rest_api.views_executable.inc file for implement the hook

2) Set views offset and page limit

/**
 * @file
 * Containts custom_rest_api.views_executable.inc.
 */

use Drupal\views\Plugin\views\query\QueryPluginBase;
use Drupal\views\ViewExecutable;

/**
 * Implements hook_views_query_alter().
 */
function custom_rest_api_views_query_alter(ViewExecutable $view,     QueryPluginBase $query) {
   if ($view->id() == "news" && !empty($view->args)) {
   $number = (int) ($view->args[0]);
   $number--;

   $limit = 10;
   $offset = $limit * $number;

   $view->setOffset($offset);
   $view->getPager()->setItemsPerPage($limit);
 }
}