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

2

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

edited Oct 31, 2016 at 15:04

answered Oct 31, 2016 at 14:39

yceruto

9,6155 gold badges41 silver badges69 bronze badges

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

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