I have a ranks collection with a permissions field which are bitwise operators: [ { "_id": "xxxx", "name": "Rank 1", "permissions": 1 }, { "_id": "xxxxxxxxx", "name": "Rank 2", "permissions": 2 } ] Example users: [ { "_id":"1234", "ranks":[ "xxxx",…
Let's say my documents look like this: [ { name: "Example 1", year: "2012" }, { name: "Example 2", year: "2012" }, { name: "Example 3", year: "2013" }, { name: "Example 4", year: "2014" } ] Using an aggregation,…
[ { _id:1 value: "8 Aug 2022, 1:13 PM" }, { _id:2 value: "15 Aug 2022, 1:13 PM" } ] Want to convert the above documents with the value field as an ISO Date I was splitting the first part…
I have a coupons collections and I am trying to group all the coupons based on the code. After that I want to sort them on the basis of the count. Till this the query works fine. But after this…
I want to calculate the percentage of the position of a football player field-wise to the country they belong to. Let's say, there are a total 800 players from Nepal whereas only 20 were goal keepers so percentage would be…
Suppose that I have a collection with documents like below { "location" : "Tokyo", "region" : "Asia", "attraction": { "transportation" : "Subway", "food" : { "food_0" : { "name" : "Sushi", "price" : 100, "restaurant" : "Ookinza" }, "food_1" :…
I have a collection where from the backend user can input multiple same name bikes but with different registration number but in front-End I want them to be grouped by matching the same name but as user updates separately display…
I have a document with a nested array which looks like this: [ { "id": 1, data: [ [ ISODate("2000-01-01T00:00:00Z"), 2, 3 ], [ ISODate("2000-01-03T00:00:00Z"), 2, 3 ], [ ISODate("2000-01-05T00:00:00Z"), 2, 3 ] ] }, { "id": 2, data: []…
Using Mongoose driver Consider the following code : Connecting to database const mongoose = require("mongoose"); require("dotenv").config(); mongoose.connect(process.env.DB); const userSchema = new mongoose.Schema({ name: String }, {collection: 'test'}); const Model = mongoose.model('test', userSchema); Creating dummy document async function createDocs() { await…
Following the examples I have two types of data in the same time series db.weather.insertMany( [ { "metadata": { "sensorId": 5578, "type": "temperature" }, "timestamp": ISODate("2021-05-18T00:00:00.000Z"), "temp": 72 },//.... and.. db.weather.insertMany([ { "metadata": {"sensorId": 5578, "type": "humidity" }, "timestamp": ISODate("2021-05018T00:00:001Z"),…