Ok so I have got this weird error. I am passing user credentials via postman. In one tab, I am getting an error, but when another tab is used it works. As far as I have checked everything is same…
I have a collection that records comments from users. Something like the below: { _id:1 "statusReason" : { "text" : { "value" :"Hello there 😊" } } } I need to write a query that can identify any comments containing…
const search = await searchAgent.aggregate([ {$match: {id: Number(fid), status: {$regex: status, $options: 'i'}}}, {$sort: {[order_by]: order == 'desc' ? -1 : 1}}, {$skip: skip}, {$limit: pagelimit}, ]) Here I need to get the total number of documents matching the query.…
I have a collection with 10M records, with the following schema: { "_id": ObjectId "uid": string } uid is a random string for testing purposes, generated with unique values. There are 2 indexes: {"_id": 1} and {"uid": 1}. The following…
The film collection has a review array of objects which holds the userid who made the review: The user collection has a filmsReviewed array of object storing all the films that user reviewed: I want to delete a user which…
I have my data structured as [{type: "advanced", price: 5000}]. The schema type is set to type: []. When I query the data in my browser (using react) I get an array but the objects like ['[object Object],[object Object]']. How…
consider there are 3 collections : Company : { name } Department: { name, company_id } Person: { name, department_id } and we want to get all persons in a company, by company name. i know the way to first…
i have a problem when POST some data in POSTMAN my problem is during "post" method /auth/login req.body return empty array. Postman return empty object only if i use POST method with use form-data, if i change to xxx-www-form-urlencoded whatever…
I have Product collection. In this collection each document has same keys and different values. Several documents are shown in the example below. [ { "productCategory": "Electronics", "price": "20", "priceCondition": "Fixed", "adCategory": "Sale", "productCondition": "New", "addDescription": "Lorem Ipsum Dolor Sit…
I have a collection test, and a compound index on it with two fields db.test.createIndex({ i: 1, j: 1 }) When I execute following pipeline db.test.aggregate([{ $sort: { i: 1, j: 1 } }], { allowDiskUse: false }) it works…