I'm working with this query: customers.aggregate: [ {$lookup: { from: "users", localField: "_id", foreignField: "customerId", as: "users" }}, {$lookup: { from: "templates", let: {localField: "$_id"}, pipeline: [{ $match: { $and: [{ $expr: { $eq: ["$customerId", "$$localField"]}}, {module: false}] }}], as:…
I would like to get price and date info and send to ejs the between two specific dates and names. My first document is like this and I have many. For instance I want all Bitcoin infos between 2022-4-1 and…
I have a large set of records in this schema: { username: "[email protected]", timestamp: 1646006400000 //unix timestamp in milliseconds amount: 100 } Given an arbitrary range of dates, I need to find the change in average amount value vs a…
I am trying to count how many times does a particular value occur in a collection. { _id:1, field1: value, field2: A, } { _id:2, field1: value, field2: A, } { _id:3, field1: value, field2: C, } { _id:4, field1:…
{ "_id" : ObjectId("5c139771d79ac8eac11e754a"), "title" : "API", "content" : "API stands for Application Programming Interface. It is a set of subroutine definitions, communication protocols, and tools for building software. In general terms, it is a set of clearly defined methods…
I'm new to making queries in Mongo. I have this single record and I need to find the sections with the same link. My record: { "_id" : ObjectId("1234"), "name": "singleRecordInMongo", "__v" : 0, "sections" : [ { "name" :…
I am using coffeescript with nodejs to query monogodb data but for some custom data i need to perform aggregate function on my collection but using Session.aggregate(query) in the code is giving me error like not pipeline operator $and. So,…
I want to store maximum length, breadth, area ever encountered from a request and store it in the database. In this case, anything can be maximum and based on that I want to update max values in the database for…
I have an issue that need to insert index number when get data. First i have this data for example: [ { _id : 616efd7e56c9530018e318ac student : { name: "Alpha" email: null nisn: "0408210001" gender : "female" } }, {…
I want to have the mongodb query given these details below, and to have best in performance. Let me start by an example: Let me have a collection, /// the collection services = [ { _id: obj(id1), provider_id: "provider1", service_code:…