How to get entries for the last week in mongo with one specific parameter?

Question

MongoDB

In MongoDB, the users_messages collection contains user messages on the forum, 1 entry per message. The fields of each entry are timestamp, username, is_moderated, message. How to provide the distribution of the number of moderated posts between users in the last week?
in order to get just moderated, you can, but how have they been for the last week? you can also use mongoose
db.users_messages.find( { is_moderated: true }

Answer 1

db.users_messages.find({
timestamp: {
$gte: new Date(new Date() - 7 * 60 * 60 * 24 * 1000)
}, is_moderated:true
});