0

how can i in mongoDB check field by another field like that in sql:

SELECT `name`,`surname` FROM `users` where `name`=`surname`

for now i try :

Credentials.findOne({ usersLen: { $lte: '$usersMaxLen' } });
                                            ^^^ - here i want access field usersMaxLen from collection

but have error:

CastError: Cast to number failed for value "$usersMaxLen" (type string) at path "usersLen" for model "Credentials"
Brokieb
  • 45
  • 6
  • https://stackoverflow.com/questions/30762987/mongodb-querying-documents-with-two-equal-fields-match-and-eq/41470741 – R2D2 Nov 13 '21 at 17:23
  • From the duplicates linked, your query should be `Credentials.findOne({ "$expr": { "$lte": ["$usersLen", "$usersMaxLen"] } });` – chridam Nov 13 '21 at 17:30

0 Answers0