I have a database with users collection which contains a verified field in its schema. I want users that have not been verified 5min after account creation to be deleted. How can I do this? I am already familiar with…
We are looking for a user in the database by '_id' "_id": "6381e7c6bf8892cf05c7c798", "username": "Teacher", "email": "[email protected]", "role": "teacher", "avatar": "fixtures/teacher.jpg", "token": "KNuSF7sscU3EJsMetUFKi", "authentication": true, "myCourses" and It is necessary to get a suitable object from the array using 'aggregate',…
I'm building social network app using nodejs and mongodb. Now in my user schema i have an array of ids of users who are following certain user and ids of users who are followed by certain user. When i delete…
Trying to find a document by ObjectId in mongoose. The query returns an empty result but when applying the same query in the "MongoDB Compass" - it returns the document. const mongoose = require("mongoose"); await CollectionModel.find({ "_id": new mongoose.Types.ObjectId(DOCUMENT_ID)}); What…
I have two collections Post (belongs to posts database) and User (belongs to account database). My requirements to do join on these two collection. But I am unable to reproduce my requirements. I am expecting joins on two collections.
I have recently shifted to MongoDB and Mongoose with Node.js. And I am wrapping my head around it all coming from SQL. I have a collection where documents have a similar structure to the following: { name: String rank: Number…
I have collection: bookSchema as: [ { _id: ObjectId("637d05dc32428ed75ea08d09"), book_details: { book_name: "random123", book_auth: "Amber" } }, { _id: ObjectId("637d0673ce0f17f6c473dee2"), book_details: { book_name: "random321", book_auth: "Amber" } }, { _id: ObjectId("637d069a3d597c8458ebe4ec"), book_details: { book_name: "random676", book_auth: "Amber" } }, {…
I have following data in my mongoDb database and I want to find the student from the array of students objects by iterating on all my students field of my database with the id the students array objects have. I…
so here's my collection. This consists of users and their data { userId: 6udg, data: [ { date: 22-09-2022 hits: 98 }, { date: 23-09-2022 hits: 88 }, { date: 24-09-2022 hits: 100 }, { date: 24-11-2022 hits: 145 },…
If I have this collection [ { "_id": "637cbf94b4741277c3b53c6c", "text": "outter", "username": "test1", "address": [ { "text": "inner", "username": "test2", "_id": "637cbf94b4741277c3b53c6e" } ], "__v": 0 } ] and would like to search for the nested document by _id and…