mongodb - search in subarray, PHP

Question

i started with mongodb and played around with random temperature data like this:

'weather' => array(
                    'Air' => array(
                        'Jan' => 11,
                        'Feb' => 20,
                        'Mar' => 24,
                        'Jun' => 28,
                        'Jul' => 30
                    )
                ),

Now my question: How can i query the Air array ?

I knwo i can do somethin like:

$query = array('weather.Air.Jan' => 11);

Works fine...

But how can i search in the whole Air array:

$query = array('weather.Air.$' => 40);

This query doesn't work... Can somebody help me

Gates VP · Accepted Answer · 2011-10-05 04:21:50Z

2

Unfortunately, the query you're looking for does not exist.

As written, you're asking for "weather.Air where a key in the JSON object contains a value of 40".

MongoDB has the ability to "drill into" arrays. However, when it comes to sub-objects, you have to reach into the keys directly. There is no operator that provides a "search all keys" method. There is an outstanding JIRA request for this item right here.

answered Oct 5, 2011 at 4:21

Gates VP

45.3k11 gold badges108 silver badges108 bronze badges

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

Collectives™ on Stack Overflow

mongodb - search in subarray, PHP

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related