I'm trying to use a mongo client called monstache to read and synchronise data between mongodb and elasticsearch. But when I run monstache it fails showing the below error continuously : Jan 26 01:04:59 ip-172-31-1-200.eu-west-3.compute.internal monstache[25689]: ERROR 2023/01/26 01:04:59 Error…
How to replace the first n occurance of string in mongodb database. sample JSON : [{ "NAME":"Peter Parker", "NUMBER":"6882859392" }, { "NAME":"Jhon Ripper", "NUMBER":"9285346361" }, { "NAME":"James", "NUMBER":"8754859390" }] i want to update 1st 5 occurence of NUMBER field of…
I am building an application using MongoDB Atlas as the database and Django REST Framework on the backend. I'm trying to initiate the connection between the two, however, I keep getting this error back: Error connecting to MongoDB: 'ag-lfgx9hg-shard-00-02.glqs5bt.mongodb.net:27017: [SSL:…
I'm doing a project on an e-commerce website. here I'm with a problem. I have used the get method to retrieve user data from MongoDB I have passed the correct parameters and the statement UserId:req.params.userId has been satisfied where we…
I have the following json data I am trying to import into mongodb. { "subjectId": "63cd96779e66d518f3af574c", "name":"Earth and Space Science", "subtopics": [ { "name": "Rocks, Soil and Minerals", "questions": [ { "question": "What type of rock is formed when magma…
I'm new in using MERN Stack & I'm trying to connect Mongo and Node but facing this issue while inserting Data into Database, using MongoDb Compass Index.js const connectToMongo = require('./db'); const express = require('express') connectToMongo(); const app = express()…
I have documents in a collection with date format updated: 2022-10-25T05:04:47.904+00:00 How to modify the query to get the count for today's date const today = new Date() .... await db.collection('posts').countDocuments({"updated": today})
I have a collection of User documents, containing several fields and an array of Bets. I am trying to set up an update that I will run on a schedule. In the User documents, the Balance field needs to be…
How can I convert a Gregorian date to Jalali date in MongoDB? I tried adding the javascript function mentioned in this answer to my MongoDB query in Metabase but it doesn't support "$function" so I need a direct MongoDB query…
I have one schema like this: export const HotelSchema = new mongoose.Schema({ name: String, firstName: String, email: { type: String, unique: true }, canLogin: Boolean }, { collection: "hotels" } ); and to add/update I am using this query: this.hotelModel.updateOne({…