Alex Rivera | Logout

How to display the query executed by the Drupal view

Asked 2010-02-25T22:39:15.187
9

I want to display the query that is executed in the drupal view. Currently in the view editor it shows the query however I have a need to use that query in my code to download an excel version of the view.

Is there a way to get the executed query the same way it's shown in the "editor" window of the views menu? I want this at the time the the view is shown.

What I plan to do here is to capture the query in the footer, and have that query posted to a process which will send back an XLS resultset. So i'd like the exact query the view is using to display the results.

Edit
Report

1 Answer

2

The devel module can log queries for you.

answered 2010-02-25T22:55:57.850

Your Answer