python (65.2k questions)

javascript (44.3k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (13k questions)

Questions - ttl

Auto delete a document after specific time in mongoDB

I want to delete a document after a specified amount of time. Like if the user selects 24 hours then it should be auto-deleted after 24 hours. I heard about TTL in mongo but in that, I have to specify...
test-img

Het Delwadiya

mongodb

mongoose-schema

ttl

Votes: 0

Answers: 2

Latest Answer

We can add a field like expireAt and it will contain the Date of expiration. Now add a TTL index like this- db.dbname.createIndex({expireAt:1},{expireAfterSeconds:0}) Now just add expireAt field in e...
test-img

Het Delwadiya

how to delete a record of a collection after a specific amount of time

i want to create an OTP (one time password) for my node js application using mongodb as database after generating otp and sending that for client with email i want to store the otp as hashedOTP in dat...
test-img

mehraeen mozhdi

node.js

database

mongodb

settimeout

ttl

Votes: 0

Answers: 1

Latest Answer

If you want to delete the hashedOTP after a fixedTime (ie 120000 second) , You could run a cron job and update the collection by checking against the createdAt time 1 - Run Cron Job 2 - if( time of ch...
test-img

Akash NO

MongoDB TTL index never deletes records

I created an index as shown below and added a createdAt field to each new record added to the db. The records should be auto-deleted after 24 hours however I have waited days and nothing has been dele...
test-img

Amber Johnson

javascript

mongodb

ttl

database-indexes

mongodb-indexes

Votes: 0

Answers: 1

Latest Answer

Expiration of data requires that the indexed field value be a BSON date, or an array of BSON dates. MongoDB Reference Manual Expiration of Data TTL indexes expire documents after the specified number ...
test-img

rickhg12hs

MongoDB TTL does not works

I work on debian 10(buster) with mongod ver. 4.2.17. I want to use TTL to remove older documents on collection. I do walk around and I'm sure that no typo on the query. I followed dummy example offica...
test-img

Dhody Rahmad Hidayat

mongodb

ttl

Votes: 0

Answers: 1

Latest Answer

I trying to find whats wrong with the mongo, then I tried to activate TTL thread with this reference db.adminCommand({setParameter: 1, ttlMonitorEnabled: true}); Then I tried to using this suggestion...
test-img

Dhody Rahmad Hidayat

Posts

Questions

Blogs

Jobs