[TYPO3-mvc] How to debug query object

Søren Malling soren.malling at gmail.com
Fri May 28 14:32:52 CEST 2010


Hi,

I'm building my own call in my repository, but I'm having some issues
with getting the wanted data in return.

One issue is, that I can't seem to find the repository in my sql log,
so i thought i would like to see the raw produced sql query, is that
possible? Or in what way should i start debugging it?

The function is this

        /**
         * Find members by telephone and name (for searching)
         * @param string $query
         */
        public function findByTelephoneAndName($seachQuery) {
                $query = $this->createQuery();
                $query = $query->matching(
                                        $query->logicalOr(

$query->like('firstname', '%'.$searchQuery.'%'),

$query->like('lastname', '%'.$searchQuery.'%'),

$query->like('telephone', '%'.$searchQuery.'%')
                                        )
                                )->setLimit((integer) 10);
                return $query->execute();
        }


I'm using revision 2271 of extbase

Regards,

Søren

-- 
Officially Certified TYPO3 Integrator


More information about the TYPO3-project-typo3v4mvc mailing list