How to query nested array with Mongoose?

Question

MongoDB

There is a model

var RequestSchema = new Schema({
    requestNumber: {
        type: String
    },
    requestDescription: {
        type: String,
        required: [true, 'Необходимо добавить описание']
    },
    orders: [{
        product: {
            type: Schema.Types.ObjectId,
            ref: 'Product',
            required: true
        },
        finishTo: {
            type: Date,
            required: true
        }
    }],
    createdAt: {
        default: Date.now,
        type: Date
    }
});

I want to sort orders by the nearest delivery date - finishTo, when sorting from smallest to largest, {"orders.finishTo":1} is sorted as needed, and if sorted in descending order, the maximum finishTo in the order is taken.

Answer 1

The issue is resolved, there was version 3.2 in which there was no aggregate. After the upgrade, mongodb rewrote the query using aggregate.