javascript - 如何在聚合中从数组中删除数据而不干扰 mongodb 中的外部数据

Question

在这里，我尝试获取完整数据，但如果日期小于当前日期，则不要从数据库中获取该日期。

{ 
"_id" : ObjectId("5d6fad0f9e0dc027fc6b5ab5"), 
"highlights" : [
    "highlights-1", 

], 
"notes" : [
    "Listen"
], 
"soldout" : false, 
"active" : false, 
"operator" : ObjectId(""), 
"title" : "2D1N Awesome trip to Knowhere 99", 
"destinations" : [
    {
        "coordinatesType" : "Point", 
        "_id" : ObjectId("5d6fad0f9e0dc027fc6b5ab6"), 

    }
], 
"difficulty" : "Easy", 
"duration" : {
    "_id" : ObjectId("5d6fad0f9e0dc027fc6b5ab7"), 
    "days" : NumberInt(2), 
    "nights" : NumberInt(1)
}, 
"media" : {
    "_id" : ObjectId("5d6fad0f9e0dc027fc6b5ab8"), 
    "images" : [

    ], 
    "videos" : [

    ]
}, 
"description" : "Surrounded ", 
"inclusions" : [
    {
        "_id" : ObjectId(""), 
        "text" : "Included"
    }
], 
"itinerary" : "Surrounded .", 
"thingsToCarry" : [
    {
        "_id" : ObjectId(""), 
        "text" : "Yourself"
    }
], 
"exclusions" : [
    {
        "_id" : ObjectId(""), 
        "text" : "A Lot"
    }
], 
"policy" : "Fully refundable 7777 Days before the date of Experience", 
"departures" : [
    {
        "dates" : [
            ISODate("2019-11-19T02:44:58.989+0000"), 
            ISODate("2019-11-23T17:19:47.878+0000")
        ], 
        "_id" : ObjectId(""), 
        "bookingCloses" : "2 Hours Before", 
        "maximumSeats" : NumberInt(20), 
        "source" : {
            "coordinatesType" : "Point", 
            "_id" : ObjectId("5d6fad0f9e0dc027fc6b5ac2"), 
            "code" : "code", 
            "name" : "Manali", 
            "state" : "Himachal Pradesh", 
            "region" : "North", 
            "country" : "India", 
            "coordinates" : [
                23.33, 
                NumberInt(43), 
                NumberInt(33)
            ]
        }, 
        "pickupPoints" : [
            {
                "coordinatesType" : "Point", 
                "_id" : ObjectId("5d6fad0f9e0dc027fc6b5ac3"), 
                "name" : "name-3", 
                "address" : "address-3", 
                "time" : "time-3", 
                "coordinates" : [
                    23.33, 
                    NumberInt(43), 
                    NumberInt(33)
                ]
            }
        ], 
        "prices" : {
            "3" : NumberInt(5)
        }, 
        "mrps" : {
            "3" : NumberInt(5)
        }, 
        "markup" : NumberInt(25), 
        "discount" : NumberInt(0), 
        "b2m" : {
            "3" : NumberInt(5)
        }, 
        "m2c" : {
            "3" : 6.25
        }, 
        "minimumOccupancy" : NumberInt(3), 
        "maximumOccupancy" : NumberInt(3)
    }
], 
"bulkDiscounts" : [
    {
        "_id" : ObjectId("5d6fad0f9e0dc027fc6b5ac4")
    }
],     
}

在此，我试图获取除日期部分之外的所有数据。意味着我应该得到如下输出

{
            "_id": "5d6fad0f9e0dc027fc6b5ab5",
            "highlights": [
                "highlights-1",
                "highlights-2",
                "highlights-3",
                "highlights-4",
                "highlights-5"
            ],
            "notes": [
                "Listen"
            ],
            "soldout": false,
            "active": false,
            "operator": "5d5d84e8c89fbf00063095f6",
            "title": "2D1N Awesome trip to Knowhere 99",
            "destinations": [
                {
                    "code": "code",
                    "name": "Manali",
                    "coordinates": [
                        23.33,
                        43,
                        33
                    ]
                }
            ],
            "difficulty": "Easy",
            "duration": {
                "_id": "5d6fad0f9e0dc027fc6b5ab7",
                "days": 2,
                "nights": 1
            },
            "media": {
                "_id": "5d6fad0f9e0dc027fc6b5ab8",
                "images": [


            ],
            "videos": []
        },
        "description": "Surrounded.",
        "inclusions": [
            {
                "_id": "5d6fad0f9e0dc027fc6b5abe",
                "text": "Included"
            }
        ],
        "itinerary": "Surrounded",
        "thingsToCarry": [
            {
                "_id": "5d6fad0f9e0dc027fc6b5abf",
                "text": "Yourself"
            }
        ],
        "exclusions": [
            {
                "_id": "5d6fad0f9e0dc027fc6b5ac0",
                "text": "A Lot"
            }
        ],
        "policy": "Fully refundable 7777 Days before the date of Experience",
        "departures": [
            {
                "dates": [
                    "2019-11-23T17:19:47.878Z"
                ],
                "_id": "5d6fad0f9e0dc027fc6b5ac1",
                "bookingCloses": "2 Hours Before",
                "maximumSeats": 20,
                "source": {
                    "code": "code",
                    "name": "Manali",
                    "coordinates": [
                        23.33,
                        43,
                        33
                    ]
                },
                "pickupPoints": [
                    {
                        "coordinatesType": "Point",
                        "_id": "5d6fad0f9e0dc027fc6b5ac3",
                        "name": "name-3",
                        "address": "address-3",
                        "time": "time-3",
                        "coordinates": [
                            23.33,
                            43,
                            33
                        ]
                    }
                ],
                "mrps": {
                    "3": 5
                },
                "markup": 25,
                "discount": 0,
                "b2m": {
                    "3": 5
                },
                "m2c": {
                    "3": 6.25
                },
                "minimumOccupancy": 3,
                "maximumOccupancy": 3
            }
        ],
        "bulkDiscounts": [
            {
                "_id": "5d6fad0f9e0dc027fc6b5ac4"
            }
        ],
        "url": "",


    }
]

我的意思是说，除了日期数组之外，输出没有区别。如果日期小于当前日期，则无需获取，否则可以使用过滤后的日期数组从数据库中获取。

Answer 1

如果您使用 mongo 3.4>，那么您可以尝试使用 $addFields 和 $filter:

myCollection.aggregate([
    {$match: { 
      'departures.dates': {
          $elemMatch: {$gt: new Date()}}
       }
    },
    {$addFields: {
        'departures.dates': {
            $filter: {
                input: '$departures.dates',
                as: 'date',
                cond: {
                    $gt: ['$$date', new Date()]
                }
            }
        }
    }}
])