XF 2.2 finder with IN?

[Robert9]

Entities, finders, and repositories | Developer Documentation | XenForo

Developer documentation for XenForo

xenforo.com

In the list for whereis no "IN"; really?

 

[Kier]

Just pass an array:

$userFinder = $this->finder('XF:User')->where('username', ['Kier', 'Mike']);

 

[Robert9]

Thank you. Have solved it with:

    public function findTeamsByIds($teamIds)
    {
        $db = \XF::db();
        return $this->db()->fetchAll("
            SELECT * FROM xf_lala_team WHERE team_id IN (".$db->quote($teamIds).")"
            );
    }

or

    public function findTeamsByIds($teamIds)
    {
        return $this->finder('Lala:Team')
        ->where('team_id', $teamIds);
    }