XF 2.2 finder secondary_group_ids

[Robert9]

Is there another/better way for

$finder = \XF::finder('XF:User'); $userFinder = $finder ->where('secondary_group_ids', 'LIKE', '%11%')

 

[Lukas W.]

The default user searcher XF\Searcher\User has an implementation for this problem.

 

[Robert9]

So look for the code or to use it?

            $columnName = $finder->columnSqlName('secondary_group_ids');
            $positiveMatch = ($key == 'secondary_group_ids');
            $parts = [];
            foreach ($value AS $part)
            {
                if ($positiveMatch)
                {
                    $parts[] = 'FIND_IN_SET(' . $finder->quote($part) . ', '. $columnName . ')';
                }
                else
                {
                    $parts[] = 'FIND_IN_SET(' . $finder->quote($part) . ', '. $columnName . ') = 0';
                }
            }
            if ($parts)
            {
                $joiner = $positiveMatch ? ' OR ' : ' AND ';
                $finder->whereSql(implode($joiner, $parts));
            }
            return true;