A have a collection Products in MongoDB: { "name": "My Product 01", "description": "This is an excelent product", "tags": [ "AA", "BBBB", "C", "DDDDDDDDDDD" ] } How can I find the single longest occurrence if an item in the whole…
I want MongoDB query to minus a day from existing date in a column and update the same. query to update a date like original date = '2024-12-24T18:30:32' updated date = '2024-12-23T18:30:32' and how to execute the query on terminal…
I have chat, admin,user and message entities. chat has reference of user and admin, message has reference on chat. Message has boolean property called viewed. So I am trying to get chats for admin with user data populated and the…
Stages of MongoDB aggregation pipeline are always executed sequentially. Can the documents that the pipeline processes be changed between the stages? E.g. if stage1 matches some docs from collection1 and stage2 matches some docs from collection2 can some documents from…
In MongoDB, I have a collection of different movies with their years. Consider these documents: { "_id" : ObjectId("63a994974ac549c5ea982d2b"), "title" : "Destroyer", "year" : 1907 }, { "_id" : ObjectId("63a994974ac549c5ea982d2a"), "title" : "Aquaman", "year" : 1902 }, { "_id" :…
so i have document for users with this structure in JSON format: [ { "_id": { "$oid": "6369aeb83ce0f8168520f42f" }, "fullname": "Jokona", "password": "$2b$10$MUAe7XIc/xtJTGVh/y1DeuShCARbwxCSejUbHaqIPZfjekNrn0.Yy", "NIK": "MT220047", "status": "active", "department": "Logistic", "position": "Management Trainee", "Group_Shift": "Non Shift", "role": "admin", "createdAt": 1667870392, "updatedAt":…
I have two collections, one being Companies and the others being Projects. I am trying to write an aggregation function that first grabs all Companies with the status of "Client", then from there write a pipeline that will return all…
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…
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" :…