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?