How to use an array to search in findBy in Symfony?

Question

symfony

You need to search for a large number of user ids
documentUserRepository->findBy(['user' => [...], 'account' => $this->account, 'document' => $document]);

Answer 1

class DocumentUserRepository extends EntityRepository
{
    public function findByUserAccountDocument(array $users, $account, $document)
    {
        return $this->createQueryBuilder('a')
            ->andWhere('a.user IN (:users)')->setParameter('users', $users)
            ->andWhere('a.account = :account')->setParameter('account', $account)
            ->andWhere('a.document = :document')->setParameter('document', $document)
            ->getQuery()->getResult();
    }
}