How can $match all data except one

[skander_lassoued]

I have collection of docs that looks like (Dummy data)

Users {
name : "XXX",
age:"20"
}
{
name : "XXX",
age:"26"
}

{
name : "XXX",
age:"23"
}

I want to to query all users except that one has 23 years old
I implement function like this :

this.userMoadel.aggregation([
{
$match: {age: !23}
}

])

It doesn’t work is there any solution ?
I have to work with aggregation cuz this query should be after a lookup stage

[steevej (Steeve Juneau)]

What you need is https://www.mongodb.com/docs/manual/reference/operator/query/ne/.

Please followup on your other threads

• How can I optimize a query?
• $gte and $lte doesn't with variable
• Why aggregation doesn't return exact data in my DB - #6 by skander_lassoued

[psram (Ramkumar Pillai)]

One more observation, your sample data age field is of type String, it wont work for numeric Operation

[skander_lassoued]

$nin was the missed param thank you all