I have three mongoDB collections and their respective documents namely; mosques, prayers and subscriptions as follows: mosque document: { "_id": "64a48ce14ebcac9ec9a3b0b9", "address": "pti road , effurun", "city": "Warri", "state": "Delta", "country": "Nigeria", "name": "PTI central mosque", "image": "", "imamName": "Malam…
I'm performing an aggregation in MongoDB Compass, and I want to exclude the values of "0" from the result. Currently, my aggregation returns the following date value: "1948-12-08 00:00:00.000". How can I modify my aggregation to exclude these "0" values…
I have the following structure in the database: { "_id": ObjectId("6464acb09947e03e45b78b61"), "ProjectId": "64635ac02286d48c0c0d5907", "LabelValues": { "62d12558d75c134f54911490": "Nicht zuzuordnen", "62d12546d75c134f5491148f": "Nicht zuzuordnen" }, "KnowledgeItemId": ObjectId("6464acaf9947e03e45b78b60") } I want to write a query, that gets this element if I pass the two…
Is there any better way to write this query? { $facet: { results: [ { $match: { $expr: { $and: [{ $gte: ["$var1", 1] }, { $gte: ["$var2", 200] }], }, }, }, { $sort: { var1: 1 } },…
I have the following project: { '$project': { '_id': 1, 'applicationIds': { 'type': 'linux', 'refId': '$applicationIds' }, 'configurationIds': { 'type': 'linux', 'refId': '$configurationIds' } } } As long as there is at least one record in $configurationIds I will get…
I have the following documents in my MongoDB Aggregation stage: _id: ObjectId('641316fd596514e63a2121ca'), teamId: 5, playerId: ObjectId('64131139596514e63a2121c1') _id: ObjectId('641316fd596514e63a2121ca'), teamId: 5, playerId: ObjectId('64143f7702ede13fea5ff3be') _id: ObjectId('64143f458b6a6cf54652d3a5'), teamId: 17, playerId: ObjectId('64143fa75a97b9a63a260e16') _id: ObjectId('64143f4f9ba5f2b3cf3030e6'), teamId: 3 I want to create an Object field called…
I have the following two collections, Player and Team. These two collections each contains lots of documents. Here is an example with some dummy data: Player _id: ObjectId('6098c5ab615d9e23543d0f6e'), name: 'Frank', age: 27, position: 'striker' _id: ObjectId('61409537c4f113354782eea3'), name: 'Jan', age: 19,…
I need to a match aggregation query for this sample schema { "items": [ {name:'Test1'},{name: null} ] } Query1: get documents if all name is null or unassigned Query2: get documents if at least 1 name is filled I tried…
Trying to condense an array with key value pairs into an array of objects with the key and all the unique values for that key. I have a structure like: { fruits: [ {fruit: apple, type: gaja}, {fruit: apple, type:…
I have postgresql table with a jsonb column containing maps with strings as keys and string arrays as values. I want to aggregate all the maps into a single jsonb map. There should be no duplicate values in string array.…