[solved] goto admin/structure/views/settings

Btw I wished I could delete my own posts - the solution was found on these forums anyway.

Original:
In Drupal 6 I can always see the results and SQL query at the bottom of the view. But in Views 3 only the results are displayed, but theSQL query is not. Is there a method to see the actual query of the view ?

Comments

Alconaft43’s picture

You don't to delete your post, otherwise Google will be blind :)

jebbushell’s picture

Don't delete your post! It worked for me.

moinakbarali’s picture

it helped me too.

fureigh’s picture

+1. Thanks for posting your solution.

lunk rat’s picture

Your post helped me to. No need to delete it, friend.

pankaj01’s picture

It helped me too

rakesh.gectcr’s picture

Thanks lot... Its worked for me.....

:P

---
Kind regards,

Thank you,
Rakesh James

vamirbekyan’s picture

version of views I have is 7.x-3.0-rc1 and I do not see any option at the below url to enable seeing sql.
what am I doing wrong?

fureigh’s picture

Instead of visiting that URL, try just clicking the 'Update preview' button on the edit page for your view (/admin/structure/views/view/NAMEOFYOURVIEW).

DanChadwick’s picture

You need to enable the option to display the SQL query on the (very well hidden) Views settings page (admin/structure/views/settings). It's easy to jump to looking at the list of views without noticing the setting tab.

nicholasdynan’s picture

Make sure you run the view to get the SQL.

jeuelc’s picture

It worked on me...

yixia’s picture

Always show: Query No query was run

sassafrass’s picture

I have the same issue. Even after I enable show sql queries in the settings AND get results, I always get a "No query was run" message instead of the actual sql query that was run. ?

Lynn Haas

blackdiamond’s picture

It help me also, Thanks

raghu.pandiri’s picture

Thanks it helped me also

Thanks,
Raghu.

m4r71n’s picture

1st place in google with:
"how to see drupal query views" :P

batigolix’s picture

The impossibility to delete your post saved me time to find the answer.

anil_89’s picture

You need to enable the option to display the SQL query on the (very well hidden) Views settings page (admin/structure/views/settings). It's easy to jump to looking at the list of views without noticing the setting tab.
where you will many setting related to view

Shashwat Purav’s picture

It helped.

Thank You,
Shashwat Purav

abautu’s picture

Google considers you an authority on "how to display the SQL query". Saved my time. Thank you.

navalogan’s picture

Thanks it's help me too!

swati007’s picture

It saved my time!

paulmatunog’s picture

This helps. Thanks.

huslabs’s picture

you saved my day !!
thanks .. don't delete it :)

mayur.pimple’s picture

enable "Show the SQL query" into views setting . It's works

docans’s picture

Can any one please help me with this issue https://www.drupal.org/node/2307135