[TYPO3-mvc] How to debug query object

[Thomas "Thasmo" Deinhamer]

Hello!

You may have a look into the file 'Typo3DbBackend.php'
in the directory 'Persistence/Storage', there you can
debug your SQL statement, especially in 'getObjectDataByQuery()'.

Thomas

Am 28.05.2010 14:32, schrieb Søren Malling:
> 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
>