Custom SQL statements for views

By Jetson on 8 Apr 2010 at 21:08 UTC

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

nevets commented 8 April 2010 at 21:50

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

Jetson commented 10 April 2010 at 03:43

i am trying to use ANDs and ORs

Anonymous (not verified) commented 9 April 2010 at 05:20

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

Jetson commented 10 April 2010 at 03:47

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

Anonymous (not verified) commented 12 April 2010 at 01:12