[TYPO3-mvc] query for match two users of same usergroup

[Robert Schneider]

You could explain why you have to compare the usergroups for you issue. 
I'm wondering what this is for.

However, you could join the fe_user table with itself using the 
usergroup column. Then you would get those users with the same 
usergroup. Of course you have to exclude identical entries. And it 
requires that the usergroups always have the same ordering (as it is 
comma seperated list). But I don't know if this is the case.

But maybe you need to choose a (totally) different approach.

Regards,
Robert


Am 31.01.2013 01:35, schrieb Domi:
> Hi Toke
>> Tx_Extbase_Domain_Model_FrontendUser
>>    - usergroup
>>      - Tx_Extbase_Domain_Model_FrontendUsergroup:1
>>      - Tx_Extbase_Domain_Model_FrontendUsergroup:2
>>      ...
>>
>> using the array iterators you can create a query based on the
>> user->getUsergroup()
>
> Yes I know that I can iterate through all my emails and archive the
> values through PHP functions, but I would like to know if this task is
> possible with pure SQL statement to avoid heavy traffic. There might be
> thousands of mailentries and to iterate each entry and test the
> usergroup of each from / to user seems for me a bit unefficient.
>
> Cheers Dominic