yogjun / myblog

0 stars 0 forks source link

mongoquery #37

Open yogjun opened 2 years ago

yogjun commented 2 years ago

db.getCollection("order_info").find({ "receivablePOs.0": {$exists: true}, "status":{$in:[0,5,20,-1]}, "$or":[{"receivablePOs.amount": {$exists: false}},{"receivablePOs.referenceRate": {$exists: false}}] }).limit(1000).skip(0)