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.

Comments

Post new comment

Your name:

E-mail:

The content of this field is kept private and will not be shown publicly.

Homepage:

Comment: *

Word verification: * (verify using audio)

Type the characters you see in the picture above; if you can't read them, submit the form and a new image will be generated. Not case sensitive.