Custom SQL statements for views

Posted by Jetson on April 8, 2010 at 9:08pm

Hi-

A Drupal neu-b here - i love drupal a lot!

can anyone tell me if it is possible to edit the SQL statements created by views - i'm thinking especially of the WHERE clause

thanks!

jeff
los angeles

Comments

Posted by nevets on April 8, 2010 at 9:50pm

What are you trying to achieve, ie what is the view not doing that you want it to?

Posted by Jetson on April 10, 2010 at 3:43am

i am trying to use ANDs and ORs

Posted by pferlito on April 9, 2010 at 5:20am

You can use hook_views_query_alter to alter the query that Views generates.

Ferlito/van der Wyk | Drupal web design & development

Posted by Jetson on April 10, 2010 at 3:47am

where can i find more info about how to use hooks? not sure how to form a SQL Select in the hook?

Posted by pferlito on April 12, 2010 at 1:12am

Ferlito/van der Wyk | Drupal web design & development