Mongodb filter using regex on timestamp
I want to filter with a regex on date. I tried this: { createdAt: { $regex: '2021-06-25T' }} But it doesn't work. How can I use a regex or something to filter for those days, on a timeStamp field? The…
How can I get all documents that match my query in mongodb?
I am trying to get all books that match my several book_ids, but instead I only get one of the books. books = mydb.Book.find({"book_id ": book_id})
How to filter mongodb collection using date field?
I have date string like this '2021-03-09' And my mongodb collection like this { "_id": { "$oid": "633aede250625c10dddfd57b" }, "title": "test 1", "description": "Hello World", "date": { "$date": "2021-03-09T18:30:00.000Z" }, "image": "fd16b297-9ad1-4e84-8c3e-715a33b351b3.png", "createdAt": { "$date": "2022-10-03T14:12:50.399Z" }, "updatedAt": { "$date":…
(MongoDB) Combining Union and Intersection in the same pipeline
I have the following aggregation pipeline running in the latest version of mongoDB and pymongo: [ { "$project": { "union": { "$setUnion": [ "$query_a", "$query_b" ] } } }, { "$unwind": "$union" }, { "$group": { "_id": "$union.ID", "date_a": {…
How to initiate mongodb replica set using nodejs
I'm running the following code for mongodb replica set initialization: try { const mongoClient: MongoClient = new MongoClient(process.env.MONGODB_URI || 'mongodb://mongodb:27017', {replicaSet: "rs0"}); const mongoDb: Db = new Db(mongoClient, "admin"); const response = await mongoDb.admin().command({ replSetInitiate: {} }, {}) } catch…
MongoDb is not connected and I have no error
I've watched multiple tutorials on how to connect mongodb with node.js I've created a free account on mongodb.com, set a user name and a password, created a database, added an IP address on 0.0.0.0/0 on vsCode I've installed all necessary…
Mongodb – Do I need to subscribe Amazon's service to use the "Alexa Smart Properties for Residential API"
Hi I'm a junior engineer in Cleveland, OH. I have received a project to implement a web application using "Alexa Smart Properties for Residential API". I think I know what api functions do they support. But the thing is I…
Mongodb – Endpoint not being executed in FastAPI
I am developing a simple API using FastAPI. I have this endpoint which I am testing, that whatever it should return, I always get a 200 code with an empty list. If I try to debug it by printing, returning…
Mongodb – mongo query for a one-to-many collection where all records has to match the condition and get an unique record
Employee has multiple employeeActions, the employeeActions data looks like this: [ { "email": "[email protected]", "companyRegNo": 105, "event": { "created": ISODate("2022-09-16T06:42:04.387Z"), "desc": "COMPLETED_APPLICATIONS", "note": "Direct apply" } }, { "email": "[email protected]", "companyRegNo": 105, "event": { "created": ISODate("2022-09-20T06:42:42.761Z"), "desc": "ASKED_TO_REVIEW", } },…
Mongodb aggregation response
I have a Property controller : //Get Properties By Type const getPropertiesByType = async (req: Request, res: Response) => { const { cities, type } = req.query const citiesArr = typeof cities === 'string' ? cities.split(',') : [] try {…