Mongo错误：无法规范化查询：错误值未知运算符：$and

Question

我有这个查询代码，但无法使其工作。我正在使用NodeJS，数据库是mongoDB。

Transducer.find({$and: [{isNew:{$eq:true}}, {isPublished:{$eq:true}}]})
.sort({"nominalDiameterin":1})
.limit(50)
.exec(function(err, allTransducers){
if(err) {
throw err;
} else {
if(req.xhr) {
res.json(allTransducers);
} else {
var id = req.params.id;
if(id === 'en'){
res.render("products/transducers", {transducers: allTransducers, length: allTransducers.length});
}else if(id === 'cn'){
res.render("products/transducers-cn", {transducers: allTransducers, length: allTransducers.length});
}
}

我想显示新的和已发布的数据，但我没有运气。

有什么帮助吗？

Answer 1

亲爱的@Vina凡妮莎康普森，你不需要使用$and和$eq运算符进行简单的查询，你的语法也不正确。

请按照以下答案进行操作

var query = {
isNew:true,
isPublished:true
}
var toSort = {
nominalDiameterin:1
}
Transducer.find(query).sort(toSort).limit(50).exec(function(err, allTransducers) {
if (err) {
throw err;
} else {
if(req.xhr) {
res.json(allTransducers);
} else {
var id = req.params.id;
if(id === 'en'){
res.render("products/transducers", {transducers: allTransducers, length: allTransducers.length});
}else if(id === 'cn'){
res.render("products/transducers-cn", {transducers: allTransducers, length: allTransducers.length});
}
}
}
})