在现场查询，不接近JSON

Question

查询语法。我想从选择两个字段值的集合中子集数据。

我的一些尝试如下;

"{ $and: { "gene" : "A1CF"}, { "tissue" : "LUNG"}}"
Error: Invalid JSON object: { $and: { "gene" : "A1CF"}, { "tissue" : "LUNG"}}
"{ { "gene" : "A1CF"}, { "tissue" : "LUNG"}}"
Error: Invalid JSON object: { { "gene" : "A1CF"}, { "tissue" : "LUNG"}}

在此示例中，我正在查询基因和组织。A1CF和肺。

我的json对象是

{ 
"_id" : ObjectId("5d139e3817ddc2d8750e0f13"), 
"gene" : "A1CF", 
"driver_genename" : "ERBB2", 
"target_genename" : "A1CF", 
"wilcox_p" : 0.00777647226632117, 
"effect_size" : 0.772727272727273, 
"zdiff" : -1.0725469683635, 
"tissue" : "BREAST"

}

{ 
    "_id" : ObjectId("5d139e3817ddc2d8750e0f14"), 
    "gene" : "A1CF", 
    "driver_genename" : "AFF4", 
    "target_genename" : "A1CF", 
    "wilcox_p" : 0.0120300751879699, 
    "effect_size" : 0.907407407407407, 
    "zdiff" : -0.0983195839378545, 
    "tissue" : "LARGE_INTESTINE"
}

Answer 1

$and monogodb操作员期望一个数组，即

.find({ $and: [{ "gene" : "A1CF"}, { "tissue" : "LUNG"}] });

请参阅详细信息：https：//docs.mongodb.com/manual/reference/poerator/query/query/and/

但是：

您应该可以做到这一点，这应该具有相同的结果：

.find({ "gene" : "A1CF", "tissue" : "LUNG" });