Developing (v7+)

Echo Out an SQL Query

Permalink August 17, 2010 at 10:52 AM

I am attempting to edit a Custom Search Block, to filter by page custom attributes.

I have altered the pages, but am unable to pull any results back when, attempting to use anything other then filterByCollectionTypeHandle

I would like to be able to see my query, to see what I am building up, but a forum search has been un-fruitfull maybe someone can help me.

How do I see my current SQL queries?

andrew replied on Aug 18, 2010 at 1:46 pm Permalink Best Answer Reply

If $pl is the object that you're performing your custom search query on, do this:

$pl->debug();

at any point before calling $pl->get() or $pl->getPage().

TheRealSean replied on Aug 19, 2010 at 6:06 am Permalink Reply

Thank you that has done the trick, I had attempted to use that but was using it in the wrong location.