Change stream fullDocument on delete

[Pavel_Duchovny]

Hi @Ivan_Lysov,

Welcome to MongoDB community!

So there is a nice workaround I presented for Atlas triggers. Since they are based on change stream events eventually same one can be applied to your scenario.

Accessing document fields on database delete trigger

Hi @ilker_cam, Welcome to MongoDB community. You are correct that delete trigger cannot access the full document object. I want to offer you a workaround/trick that have worked for me in the past. Port your delete trigger into an update trigger with fullDocument enabled and filter only updates where updated field is a ttl expired field . (Eg. deleted flag) Example : { "updateDescription.updatedFields.deleted": { "$exists": true } } Now in your collection define a 0 sec life time t…

The main Idea in the linked post is:

1. There is a new expireField with 0 life time ttl on it.
2. When you want to delete a document you actually set this field to current time.
3. Your change stream event listen to an update where the expiry field is present and specify full document.
4. The change stream will perform the needed operation and ttl will meanwhile delete that document.

To me this is the most elegant way I can think of.

Let me know if that helps

Thanks
Pavel