I have collection with 2 properties "from_id", "chat_id". I want to filter objects with same values in this fields.
Unfortunatelly, from_id: { $ne: '$chat_id' } doen't works.
Advice me, please how to exclude such objects.
Asked
Active
Viewed 24 times
0
Дмитрий Коляда
- 11
- 1
-
You need [`$expr`](https://www.mongodb.com/docs/manual/reference/operator/query/expr/) operator in order to compare different fields. – Yong Shun Sep 01 '23 at 12:18
-
2$expr: { $ne: ["$from_id", "$chat_id"] thank you! – Дмитрий Коляда Sep 01 '23 at 12:47
-
1Does this answer your question? [MongoDb query condition on comparing 2 fields](https://stackoverflow.com/questions/4442453/mongodb-query-condition-on-comparing-2-fields) – ray Sep 01 '23 at 14:40