mongodb and or combo Similar to this except I'm using php and getting [MongoCursorException] $or array must contain objects.
Also read this http://www.mongodb.org/display/DOCS/Advanced+Queries#AdvancedQueries-%24or
How can one nest an "AND" inside of an "OR" in MongoDB via PHP? Here is my conditions argument (via var_export):
'group_id' => '4eec13b5-aeb4-48ee-9619-449125af0e18',
'$or' =>
array (
0 =>
array (
0 =>
array (
'active' => 0,
'user_id' => '4eea7b76-5d34-4036-8344-120c0aaa1bdc',
),
),
1 =>
array (
1 =>
array (
'active' => 1,
),
),
)
Need list of posts that are in a group id AND are active OR (belong to the user AND are not active).
Extremely easy in SQL but whichever variation I try in the MongoDB via PHP query I get the $or error. Is this possible? Is an $and required?