anton
anton

Reputation: 257

$not operator in Mongo PHP query

I'm trying to write a query to Mongo DB with the following structure:

not (condition1 or condition2)

$query = ['$or' => [$condition1, $condition2]];

works correctly,

$query = ['$not' => ['$or' => [$condition1, $condition2]]];

is not working with error message invalid operator: $or' in ... in logs. What I'm doing wrong?

Upvotes: 0

Views: 1058

Answers (1)

ʰᵈˑ
ʰᵈˑ

Reputation: 11375

Simply use the $nor operator.

$nor performs a logical NOR operation on an array of one or more query expression and selects the documents that fail all the query expressions in the array.

$query = ['$nor' => [$condition1, $condition2]];

Upvotes: 1

Related Questions