[TYPO3-mvc] Help needed for DISTINCT using QOM

[Fabien Udriot]

Also, there would be another approach for my problem maybe more QOM "compliant" available here:

http://forge.typo3.org/projects/extension-terfe/repository/entry/branches/ter_fe2/Classes/Domain/Repository/AuthorRepository.php

On 4/21/11 9:52 PM, Fabien Udriot wrote:
> Found a solution with:
>
> $query->getQuerySettings()->setReturnRawQueryResult(TRUE);
>
>
> Complete code snippet is here:
>
> public function findAllCountries() {
> $query = $this->createQuery();
> $query->getQuerySettings()->setReturnRawQueryResult(TRUE);
> $query->statement('SELECT DISTINCT country FROM tx_typo3agencies_domain_model_agency);
> $result = $query->execute();
> return $result;
> }
>
>
>
> On 4/21/11 6:32 PM, Fabien Udriot wrote:
>> Hi all,
>>
>> Would you have any idea / hint how to do a DISTINCT with extbase 1.3 using the QOM. I didn't find
>> any clue neither on the ML nor on the Internet. My goal would be to retrieve all DISTINCT countries
>> from a set of records. Don't know what would be the best approach.
>>
>> With extbase 1.2, we could do the code above. However $query->statement does not seem to work well
>> with extbase 1.3. Basically, when I loop in the template, it appears to be the same record at every
>> loop.
>>
>> public function findAllCountries() {
>> $query = $this->createQuery();
>> $query->statement('SELECT DISTINCT country FROM tx_typo3agencies_domain_model_agency');
>> return $query->execute();
>> }
>>
>> Thanks for help as the problem is quiet urgent for me.
>>
>> Fb.