$where is not allowed in this context,出错,用count不能统计

Question

已解决15.51K 浏览2021/06/28数据库

0

heavenm 22 2021/06/18 1条评论

db.getCollection(“rank”).find({“$where:”this.stats > this.stats”}).limit(1000).count(0)

有啥解决办法不

$where is not allowed in this context

heavenm 选择最佳答案 2021/06/28

读取内容可以,但是count()不行

xiaoxu · Answer 1 · 2021-06-28T23:04:58+00:00

如果是3.6版本，建议是$expr，$where执行js脚本，效率低。

尝试如下方式

db.getCollection(“rank”).find({$expr:{$gt:[‘$stats’,‘$stats1’]}}).count()

The query operator $where can also be used to specify JavaScript expression. However:

Starting in MongoDB 3.6, the $expr operator allows the use of aggregation expressions within the query language。