How to compare two multiple fileds in document in mongodb

Question

i have collection called "devices". this devices collection have two fields called as "devices" and "totalDeviceNeeds". totalDeviceNeeds have integer value. devices field contain array. I want to get all documents that totalDeviceNeeds > devices array size. How can i do that. I try lot of ways and didnt get correct. I try in nodejs.

Did you try the $where operator? Something like this, db.devices.find( { $where: "this.totalDeviceNeeds > this.devices.length" } ); — Ammar
– Ammar, Commented Aug 15, 2021 at 16:49

wisnshaftler · Accepted Answer · 2021-08-15 17:57:18Z

1

Thank you all.

i just wrote query code or whatever called. here is this

db.collection.find({ $expr:{ $lt:[{$size:"$devices"}, "$totalDeviceNeeds"] } }).toArray();

in this $lt meaning less than operation

i used this post to do this.

https://www.mongodb.com/community/forums/t/is-there-a-way-to-query-array-fields-with-size-greater-than-some-specified-value/54597/2

answered Aug 15, 2021 at 17:57

wisnshaftler

1011 silver badge11 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to compare two multiple fileds in document in mongodb

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related