[TYPO3-mvc] Help needed for DISTINCT using QOM

[Sy Moen]

Wow, great find. Thanks for posting this...

On Thu, Apr 21, 2011 at 8:55 AM, Fabien Udriot <fudriot at omic.ch> wrote:

> 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.
>>>
>> _______________________________________________
> TYPO3-project-typo3v4mvc mailing list
> TYPO3-project-typo3v4mvc at lists.typo3.org
> http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-project-typo3v4mvc
>