Mongo子文档比较查询的问题

Question

 {
    "_id" : ObjectId("59f82d1152a02b2a37d12b24"),
    "trainNo" : "6c000G61190J",
    "trainCode" : "G6119",
    "seatType" : "O9OM",
    "passStationList" : [ 
        {
            "name" : "长沙南",
            "stationNo" : "01",
            "arriveTime" : "----",
            "leaveTime" : "18:43",
            "waitTime" : "----"
        }, 
        {
            "name" : "衡阳东",
            "stationNo" : "02",
            "arriveTime" : "19:20",
            "leaveTime" : "19:22",
            "waitTime" : "2分钟"
        }, 
        {
            "name" : "郴州西",
            "stationNo" : "03",
            "arriveTime" : "19:55",
            "leaveTime" : "19:57",
            "waitTime" : "2分钟"
        }, 
        {
            "name" : "韶关",
            "stationNo" : "04",
            "arriveTime" : "20:28",
            "leaveTime" : "20:30",
            "waitTime" : "2分钟"
        }, 
        {
            "name" : "广州南",
            "stationNo" : "05",
            "arriveTime" : "21:27",
            "leaveTime" : "21:27",
            "waitTime" : "----"
        }
    ]
}

例如这种文档结构，我想查出passStationList.name包含长沙和衡阳，并且长沙的stationNo大于衡阳的stationNo，Mongo可以直接查询出来么？

Answer 1

可以查出长沙，衡阳的数据。然后程序自己来比较逻辑