Doctrine Query Builder: Value in SQL array

Question

I have an array of entities (groups) in an entity (user), and in my Query Builder I would like to do something like this:

$groups = $current_user->getGroups(); $usersQuery = $em->getRepository('AppBundle:Users')->createQueryBuilder('u'); foreach ($groups as $group) { $usersQuery ->orWhere(':group_value in (u.groups)') ->setParameter('group_value', $group); }

But doctrine doesn't like it. Is there another way to check if a value is in a SQL array ?

Thanks.

yceruto · Accepted Answer · 2016-10-31 15:04:49Z

Use MEMBER OF DQL statement for these cases:

foreach ($groups as $group) { $usersQuery ->orWhere(':group_value MEMBER OF u.groups') ->setParameter('group_value', $group); }

Definition: http://docs.doctrine-project.org/projects/doctrine-orm/en/latest/reference/dql-doctrine-query-language.html#collection-expressions

Collectives™ on Stack Overflow

Doctrine Query Builder: Value in SQL array

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related