Doctrine check if parameter value exists in entity array property [duplicate]

Question

I have an array property inside my entity which contains series of dates in 'd/m/Y' format.

I'm trying to write a query which will select all instances of entity which don't have some date passed as argument to repository method in that array property.

I tried with:

 ->andWhere(
      $qb->expr()->notLike('u.datesBooked', ':date')
 )

and

 ->andWhere(
      $qb->expr()->notIn($date->format('d/m/Y'), 'u.datesBooked')
 )

with no luck, i get the wrong results. Is this even possible on database level?

See: stackoverflow.com/a/39229713/1791606 . You would need to use ->where('u.datesBooked like :datesBooked')->setParameter('datesBooked', '%'.$date->format('d/m/Y').'%'). — qooplmao
– qooplmao, Commented Sep 27, 2016 at 14:18

Al Foиce ѫ · Accepted Answer · 2016-09-27 13:55:15Z

0

Try:

->andWhere('u.datesBooked != :date')
->setParameter('date', $date);

answered Sep 27, 2016 at 13:55

Al Foиce ѫ

4,34112 gold badges44 silver badges51 bronze badges

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

Collectives™ on Stack Overflow

Doctrine check if parameter value exists in entity array property [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related