Mongoose conditional TTL for document

Question

Is there any way to set expiresAt index only for some documents, depending on current document state?

Answer 1

Yes, there is. You need to set both partialFilterExpression and expiresAt indexes. Works only at mongodb 3.2+

Code below will remove document after 24h only if paid property is equal to false:

let billingSchema = new mongoose.Schema({
_id:type:Number,
summ:{
    type:Number,
    required:true
},
description:String,
paid:{
    type:Boolean,
    default:false,
    index:true
},
ownerId:{
    type:mongoose.Schema.Types.ObjectId,
    ref:'User',
    index:true
}
},{timestamps: true,_id: false});
billingSchema.index({createdAt: 1},{expireAfterSeconds: 24*60*60,partialFilterExpression : {paid: false}});