如何使mongodb与$ in,$或$ and聚合

这是mongodb中的Query,我以前是根据状态,verify_status及其类别以及它们的位置来获取信息的,它们只是该字段的一个位置,但需要在多个集合中查找位置。

更新:我尝试在Robo3t中运行此查询,它返回空白Result,但是我在Studio3t中运行的相同查询显示了预期的结果。是否存在任何版本问题。

{
    "status":{
        "$eq":"active"
    },"verify_status":{
        "$eq":"Yes"
    },"$or":[
    {
        "category":{
            "$eq":{
                "$oid": "5da0f71e15712b5f7723bb58"
            }
        }
    },{
        "multi_car_status":{

            "$eq":"ON"

        },"additional_category":{

            "$eq": "5da0f71e15712b5f7723bb58"

        }
    }
    ],"driver_location":{
        "$in":[
            "5dee787f15712b443f6a5e06","5dee787f15712b443f6a5e06"
        ]
    }
}

当我删除driver_location或“ $或”它的返回结果时,有 结果在数据库中,但它返回返回0结果。我无法获得两个运营商的结果。下面是示例数据。

{
    "_id" : ObjectId("5ead0f5f15712b5df22d7e23"),"driver_location" : "5dee787f15712b443f6a5e06","category" : ObjectId("5da0f71e15712b5f7723bb58"),"image" : "7f8e1ddfbe862a7ac4386b2f41fe953f.jpg","driver_name" : "Ravi aa","email" : "#####@gmail.com","dail_code" : "+1","mobile_number" : "83748746","dob" : "10/05/2000","password" : "######","verify_status" : "Yes","status" : "active","availability" : "Yes","mode" : "Available","gender" : "male","vehicle_type" : null,"vehicle_maker" : "5da0f05115712b5fb36e3d02","vehicle_model" : "5db22e1215712b25a36b8a3c","loc" : {
        "lon" : 77.35124777,"lat" : 28.6543715
    },"address" : {
        "address" : "delhi","county" : "United States","state" : "AR","city" : "delhi","postal_code" : "122001"
    },"multi_car_status" : "ON","additional_category" : [ 
        "5da09ed315712b413333ca58","5da0f6fc15712b5c1956eed6","5da0f73b15712b5fb36e3d09"
    ],}
iCMS 回答:如何使mongodb与$ in,$或$ and聚合

暂时没有好的解决方案,如果你有好的解决方案,请发邮件至:iooj@foxmail.com
本文链接:https://www.f2er.com/1825883.html

大家都在问