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?
Simply use the $nor
operator.
$nor
performs a logicalNOR
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]];