Mongodb php query, search in array?

Question

I am looking for a way to search for a keyword (ex. "Henrik") in the "answers" array of documents with the following structure

Array
(
[_id] => MongoId Object
    (
        [$id] => 4eeedd9545c717620a000007
    )

[formId] => 6
[respId] => 4eeedd95c93228
[dateCreated] => 2011-10-14 07:45
[answers] => Array
    (
        [field1] => Henrik
        [field6] => [email protected]
        [field7] => my city address
    )

)

I am working in PHP on this project, and quering like this works of course:

$answers = $collection->find( array('formId' => 6, 'answers.field1'=> 'Henrik' ) );

What I want to do is search without a specific key of the answers array, like this

$answers = $collection->find( array('formId' => 6, 'answers'=> 'Henrik' ) );

Is it possible to do this type of query? I am sorry if this is a repost. I was not able to find any examples about this here or on Google.

Might be of interest to you: stackoverflow.com/questions/6179871/… — Flukey
– Flukey, Commented Dec 19, 2011 at 13:46

fancyPants · Accepted Answer · 2013-04-24 13:47:19Z

8

$answers = $collection->find( array('formId' => 6, 
           'answers'=>
                      array('$in' => array('Henrik'))));

edited Apr 24, 2013 at 13:47

fancyPants

52.1k34 gold badges94 silver badges100 bronze badges

answered Apr 24, 2013 at 13:27

vyc

891 silver badge1 bronze badge

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

1 Comment

lesolorzanov Over a year ago

This is the correct answer, nowadays the driver works perfect with this

civilu · Accepted Answer · 2011-12-19 13:02:06Z

7

I don't think it's possible to do that.

"answers", being an array of documents (as you say), needs to know where in the documents it contains to look for the value you specify.

I presume that what you want to do is to look for 'Henrik' on any of the fields of the documents in "answers". In this case I think your best bet is to use $or:

$answers = $collection->find( array('formId' => 6, '$or' => array('answers.field1'=> 'Henrik', 'answers.field6' => 'Henrik', 'answers.field7' => 'Henrik')));

answered Dec 19, 2011 at 13:02

civilu

1,2221 gold badge9 silver badges17 bronze badges

1 Comment

Henkealg Over a year ago

I guess that is the closest I will come, and it might just work for me to. Thanks!

Dave Lancea · Accepted Answer · 2011-12-19 14:55:14Z

2

Not a solution, but a workaround: assuming your keys are as arbitrary as field1, field6, you could stop using keys and store the values in a normal array:

'answers' => array(
    'Henrik',
    '[email protected]',
    'my city address'
)

In which case your query:

$answers = $collection->find( array('formId' => 6, 'answers'=> 'Henrik' ) );

would find documents where 'Henrik' was any one of the answers.

answered Dec 19, 2011 at 14:55

Dave Lancea

1,6891 gold badge16 silver badges20 bronze badges

Collectives™ on Stack Overflow

Mongodb php query, search in array?

3 Answers 3

1 Comment

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related