I have mongo documents with number field:
[
{
_id: 1,
number: 10
},
{
_id: 2,
number: 11
},
{
_id: 3,
number: 12
},
]
And i am using mongo filter $gte
and $lte
it looks like this:
db.collection.aggregate([{$match: {number: {$gte: 10, $lte: 100}}]
And i want to know is there the way to exclude some numbers? For example i have 100 documents with number from 10 to 100 and i do not want to get number 55 but i still need to use $gte and $lte. How can i do that?
I mean i can split my gte and lte numbers and exclude 1 number but what should i do if i need to exclude 2 or more numbers?