How to query in symfony that has an array?

Question

The first thing that I do is to search all the users, and I successfully show all the users. Now I'm trying to query the roles of users, but it displays an array, like the image

Do you have an idea on how to query this in symfony? or Is this allowed in symfony to query an array? I have no idea on how to do it. I try to search it to google but no result found. I'm just stuck on this query

$query =  $this->createQueryBuilder('u')
            ->where('u.role = :parameter')
            ->setParameter('parameter', 'ROLE_ADMIN')
            ->getQuery();

        return $query->getResult();

Chuck Norris · Accepted Answer · 2017-04-04 06:46:01Z

1

Replace = by like :

->where('u.role like :parameter')
->setParameter('parameter', '%ROLE_ADMIN%')

answered Apr 4, 2017 at 6:46

Chuck Norris

1,1231 gold badge12 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to query in symfony that has an array?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related