[TYPO3-dev] Getting members of backend group

[Malte Jansen]

Hi,
Check out this function:
t3lib_db::listQuery($field, $value, $table)

This should help solving your problem...

Cheers,

Malte

Patrick Rodacker schrieb:
> Hi devs,
> 
> the column usergroup (varchar) holds a csv of all assigned backend group
> ids. What is the best approach to get the entries, if I want to get all
> users of a certain group?
> 
> For now I am using
> 
> $res = $GLOBALS['TYPO3_DB']->exec_SELECTquery('*', 'be_users', "pid=0
> AND usergroup LIKE '%".intval($id)."%'
> ".t3lib_BEfunc::deleteClause('be_users'));
> 
> which works for me, but is not a really good solution in my opinion.
> 
> Is there any existing method I can use or another way to handle the user
> group relations in a clean way?
> 
> Thanks and regards
> Patrick