FindBy('myvar' => $array) not working with mongoDbOdm in Symfony3?

Question

I have filled a mongodb-collection with the following values (identifer = myvar):

array (size=10)
  0 => string 'B00LHILHS8' (length=10)
  1 => string 'B00WSCCMV8' (length=10)
  2 => string 'B00MA15OK8' (length=10)

However - findBy(['myvar' => 'B00LHILHS8']) returns the document as wanted. But findBy(['myvar' => ['B00LHILHS8', 'B00WSCCMV8']]) returns an empty result.

I am not sure, if this is right. As the Doctrine Manual - Working with objects - By Simple Conditions mentions, that it should be possible to pass an array for the findBy() method.

Should i use the query-builder instead?

@Cuchu - Yes. I have a document with severals field and myvar is one of them. — Roman
– Roman, Commented Feb 16, 2016 at 13:49

Maxi Schvindt · Accepted Answer · 2016-02-16 13:52:42Z

2

use doctrine-mongodb-odm with Conditional Operators [link]

try:

$qb = $dm->createQueryBuilder('Entity')
    ->field('myvar')->in(array('B00LHILHS8', 'B00WSCCMV8'));

answered Feb 16, 2016 at 13:52

Maxi Schvindt

1,4601 gold badge11 silver badges21 bronze badges

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

5 Comments

Maxi Schvindt Over a year ago

I use doctrine but with mysql and mongodb with php api.

Maxi Schvindt Over a year ago

and then $query = $qb->getQuery(); $result = $query->execute();

Roman Over a year ago

Thanks, working with the QueryBuilder helped me - but the problem is, that findBy() seems not work with Doctrine and MongoDB properly. With mysql it does.

Maxi Schvindt Over a year ago

findBy use array(field1 => value1, field2 => value2)

malarzm Over a year ago

@Roman MongoDB will happily hold array value in the document so effectively your query is asking for myvar with an array as its value - this is perfectly valid in MongoDB world :)

Collectives™ on Stack Overflow

FindBy('myvar' => $array) not working with mongoDbOdm in Symfony3?

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related