Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.
By raincloud on
[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
You don't to delete your
You don't to delete your post, otherwise Google will be blind :)
Don't delete your post! It worked for me.
Don't delete your post! It worked for me.
me too
it helped me too.
Chiming in...
+1. Thanks for posting your solution.
Your post helped me too. No
Your post helped me to. No need to delete it, friend.
lunk_rat is Acquia Certified Grand Master
+1
It helped me too
Don't Delete...
Thanks lot... Its worked for me.....
:P
---
Kind regards,
Thank you,
Rakesh James
version of views I have is
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?
Instead of visiting that URL,
Instead of visiting that URL, try just clicking the 'Update preview' button on the edit page for your view (/admin/structure/views/view/NAMEOFYOURVIEW).
And you need to enable the option to see the query
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.
Very helpful
Make sure you run the view to get the SQL.
Thanks
It worked on me...
After set the, but sql not shown.
Always show: Query No query was run
No query was run message
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
It help me also, Thanks
It help me also, Thanks
Thanks it helped me also
Thanks it helped me also
Thanks,
Raghu.
+1
1st place in google with:
"how to see drupal query views" :P
The impossibility to delete
The impossibility to delete your post saved me time to find the answer.
You need to enable the option
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
It helped.
It helped.
Thank You,
Shashwat Purav
Google considers you an
Google considers you an authority on "how to display the SQL query". Saved my time. Thank you.
thanks
Thanks it's help me too!
Thanks....
It saved my time!
This helps. Thanks.
This helps. Thanks.
you saved my day !! thanks ..
you saved my day !!
thanks .. don't delete it :)
Show the SQL query
enable "Show the SQL query" into views setting . It's works
Custom query
Can any one please help me with this issue https://www.drupal.org/node/2307135