Trying to return this document from a collection by checking if a variable (userId) matches the second element in users array. I created a playground. Expected result is the user document xyz as thats the only user who liked rrr…
I have a long array of docs to create. When I create them I get no errors. const docsJson =[some array of json of docs to create] const orders = await MySchema.create(ordersJSON); // orders.length returns the same number of docs…
i have a payload { "category": "Mobile", "price": { "from": "10", "to": "50" }, "location": [ "Jakrta", "Bandung", "Surabaya" ], "rating": [ "1", "2", "3" ] } i want to find all object which have rating 1 or 2 or…
Below is the code const fs = require('fs'); const xml2js = require('xml2js'); const log = console.log; const path = require( "path" ); const folderPath = 'Data'; const folder = folderPath; let counter = 0; fs.readdirSync(folder).forEach(file => { const extname =…
I have Paraquet files in my S3 bucket which is not AWS S3. Is there a tool that connects to any S3 service (like Wasabi, Digital Ocean, MinIO), and allows me to query the Parquet files?
My query const users = usersWorkspaceModel .find({ workspaceId, userRole: 'supervisor', }) .select({ _id: 0, createdAt: 0, assignedBy: 0, updatedAt: 0, workspaceId: 0, }) .populate({ path: 'userId', select: ['_id', 'name', 'email'], mode: 'User', }); This returns me the following result :-…
In the structure of the Marks model, I have courseCode (String), courseTitle (String), studentMarks (Array of studentId and marks of that course ). The data stored in the marks collection: [ { "_id": "634 ...", "courseCode": "cse1201", "courseTitle": "Structured Programming…
I want to send dynamic query to the mongoose find() method. For each iteration I need to send dynamic key and value in find method. Can someone help in this and I have tried below. The query for each iteration…
My function is set to find email brought from /login POST method, but I am failing to declare the variable properly, what is the variable to be inserted into the findOne form on app.get('/data')? I have: app.post('/login', function (req, res)…
I'm new to using MongoDB queries. I would like to count the number of selected answers based on the question. Here is an example of data I'm trying to process: { "_id": "910ef391-bc06-4fda-80c5-c6a6d9bcXXXX", "book": { "register": [ { "questions": […