Details
-
Question
-
Resolution: Works as Designed
-
Major - P3
-
None
-
None
-
None
-
None
-
Macintosh
Description
Hi,
I am trying to execute the below query, it does not find result.
db.users.find({ "_id" : "abc", "SYS_PERM" : { "$in" : [{ "_ANY_" : { "$lt" : 3 } }, { "_ALL_" : { "$lt" : 3 } }] } })
|
It looks $lt operator doesn't work inside of $in operator. The same work if I remove the $lt as follows.
db.users.find({ "_id" : "abc", "SYS_PERM" : { "$in" : [{ "_ANY_" : 1 }, { "_ALL_" : 1 }] } })
|
Is this the current known limitation in MongoDB?