Blog

We use the Views UI a lot to create custom pages, blocks, etc. Sometimes it does not give us exactly what we want and we would like to modify the generated sql query. It's possible to achieve this through the 'views_query_alter' hook. For example, we can do something like:


function example_module_views_query_alter(&$view, &$query) {
  if($view->name == 'view_to_modify') {
    $query->where[0]['clauses'][] = 'node.nid IN (10, 20, 30, 40, 50)';
    ...
  }
}

That modifies the WHERE part of the sql query of the particular view. It helps to print out the 'query' variable before making any modifications to it.