How to override Views' SQL query with a custom SQL query?

Comments

merlinofchaos’s picture

merlinofchaos commented
Status: Active » Closed (works as designed)

This is currently not a feature supported by Views.

keef.mac’s picture

keef.mac commented

I am very interested in this.

I am looking to display one of 3 CCK fields in a content type depending on a variable entered by a user.
(basic multi-currency feature based on user selection of currency type in profile)

Any hints or directions on how to do this would be greatly appreciated?

sapark’s picture

sapark commented

http://drupal.org/node/409808
Views Modify Query

bg1’s picture

bg1 commented

Has this situation changed? Or is there another way to accomplish this? I have a view that has a nodereferrer field that can return a number of values and I want to sort those nodereferrer values. I have not been able to find a way to sort these in the queries generated by the Views module, so I am thinking that if I can get Views to use my customer query, then I could solve this very easy.

Thanks in advance for any guidance.