Database
db={message:[{"_id":{"$oid":"63d9219eac737c93384d8cbc"},"body":"I've lost my keys","chat_id":"jwRpVC4FdvDLtRS_OLoR","create_date":1675174302132,"from_id":"63d910cbe9fdbd5e7c000be1","id":"f0452bcd-9dfb-4ad6-a184-02c223568e51","media":"","modifications":null,"type":"text","update_at":0},{"_id":{"$oid":"63d9219eac737c93384d8cbd"},"body":"the terrorists will have won","chat_id":"jwRpVC4FdvDLtRS_OLoR","create_date":1675174302150,"from_id":"63d91145219a8abdef1f9010","id":"1d377296-f7a7-4ae5-bcad-6c9216ea5a4e","media":"","modifications":null,"type":"text","update_at":0},{"_id":{"$oid":"63d9219eac737c93384d8cbe"},"body":"or words to that effect","chat_id":"jwRpVC4FdvDLtRS_OLoR","create_date":1675174302152,"from_id":"63d910cbe9fdbd5e7c000be3","id":"93dc8efc-166c-4e4b-b289-2ec1612cda53","media":"","modifications":null,"type":"text","update_at":0},{"_id":{"$oid":"63d9219eac737c93384d8cbf"},"body":"safety in numbers","chat_id":"jwRpVC4FdvDLtRS_OLoR","create_date":1675174302153,"from_id":"63d910cbe9fdbd5e7c000be5","id":"f679cfd3-0ccb-448f-932e-43ae1311e147","media":"","modifications":null,"type":"text","update_at":0},{"_id":{"$oid":"63d9219eac737c93384d8cc0"},"body":"use one's coconut","chat_id":"jwRpVC4FdvDLtRS_OLoR","create_date":1675174302154,"from_id":"63d910cbe9fdbd5e7c000be7","id":"8b2a63af-9671-4b8e-add5-17d9139ee395","media":"","modifications":null,"type":"text","update_at":0},{"_id":{"$oid":"63d9219eac737c93384d8cc1"},"body":"please say that again","chat_id":"jwRpVC4FdvDLtRS_OLoR","create_date":1675174302155,"from_id":"63d910cbe9fdbd5e7c000be1","id":"031a4716-b69b-433f-b061-16e2cbaf05d8","media":"","modifications":null,"type":"text","update_at":0},{"_id":{"$oid":"63d9219eac737c93384d8cc2"},"body":"that's a relief","chat_id":"jwRpVC4FdvDLtRS_OLoR","create_date":1675174302156,"from_id":"63d91145219a8abdef1f9010","id":"88ce72e2-7884-4a48-a545-6b927a32fa9a","media":"","modifications":null,"type":"text","update_at":0},{"_id":{"$oid":"63d9219eac737c93384d8cc3"},"body":"much of a muchness","chat_id":"jwRpVC4FdvDLtRS_OLoR","create_date":1675174302157,"from_id":"63d910cbe9fdbd5e7c000be3","id":"56998ee4-5b8d-4def-ad34-dcd835882bb7","media":"","modifications":null,"type":"text","update_at":0},{"_id":{"$oid":"63d9219eac737c93384d8cc4"},"body":"how many siblings do you have","chat_id":"jwRpVC4FdvDLtRS_OLoR","create_date":1675174302158,"from_id":"63d910cbe9fdbd5e7c000be5","id":"75a183b8-5bf0-4070-a00d-54dd743310e2","media":"","modifications":null,"type":"text","update_at":0},{"_id":{"$oid":"63d9219eac737c93384d8cc5"},"body":"how do you spell this word","chat_id":"jwRpVC4FdvDLtRS_OLoR","create_date":1675174302159,"from_id":"63d910cbe9fdbd5e7c000be7","id":"88d1765f-cbd5-442a-8aff-d240f9648e7c","media":"","modifications":null,"type":"text","update_at":0}],}
Query
db.message.aggregate([{$match:{$expr:{$and:[{chat_id:"5XboYfS02SCb1D_4RiDB"},{$lte:["$create_date",1675174302153],},]},}},{$limit:100,},{$project:{id:1,chat_id:1,from_id:1,create_date:1,type:1,media:1,body:1,update_at:1,modifications:1,}},])