When aggregating a collection with the following pipeline stages let ap = [{ $group: { _id: { year: { $year: '$itemDate' }, month: { $month: '$itemDate' }, }, count: { $sum: 1 }, }, }] I receive something like this...…
Here is my document and Employee is a collection in mongoDB database @Document(collection = "Employee") public class Employee { @Id private String id; private String eId; private String firstName; private String lastName; private String emailId; private int grpId; } This…
My sample record: [ { "name": "name1", "status": "one", "unit": [ ], "child": [], "element": [ "6604" ], "tags": [ "tag1", "tag2", "tag3" ] }, { "name": "name2", "status": "one", "unit": [ ], "child": [], "element": [ "6604" ], "tags":…
I have a PSA (primary, secondary, arbiter) cluster on 4.4 which was working fine, however I managed to accidentally connect a second arbiter. I've tried to remove this arbiter from the primary using: rs.remove(<host>) rs.remove(<host>, {force: true}) rs.reconfig(confWithout2ndArbiter) rs.reconfig(confWithout2ndArbiter, {force:…
Hi i've been looking for a way to search through a collection for a document containing an email if no documents exist with that email, create one and return the document, if the document does exist already, return that original…
import mongoose from "mongoose"; const mobileNoSchema = mongoose.Schema( mobileNo: { type: String, // min: [10, "no is < 10"], // max: [10, "no is > 10"], validate: { validator: function(v) { if(v.length === 10) return true; return /d{10}/.test(v); }, message:…
I can't update many data(Array data made of Object type) in MongoDB plz help me import {MongoClient, ObjectId} from "mongodb"; async function handler(req, res) { if (req.method === "POST") { const data = req.body; const client = await MongoClient.connect("mongodb+srv:myURL") const…
I'm attempting to build a document that looks like this: { "Name" : "Joe", "Age" : 34, "Some Array" : [ { "index" : 1, "Some Var" : 12, "Flag" : false }, { "index" : 2, "Some Var" :…
Getting this error. my typescript version is 4.5.4 and "@types/mongodb": "~3.3.1", "@types/mongoose": "~5.5.17". any idea how to solve enter code here ../@types/mongodb/index.d.ts:49:74 - error TS2724: '"bson"' has no exported member named 'ObjectID'. Did you mean 'ObjectId'? 49 export { Binary,…
I want to find products that are most popular sort by quantity of amount sold. I have the following data: db={ orders: [ { "_id": "63f37d1ac3dff5dd6d8cd156", "cartItems": [ { "qty": 1, "product": { "_id": "63515ad7d5f84ecbaac38f1e", "code": "1", "name": "Coca-Cola", "pricePerItem":…