I have a Project entity (projects collection). Each Project belongs to an organization represented by Project.orgId and has an author Project.author taken from users collection. I want to query the projects that belong to an organization using Mongoose, and here's…
I have a dataset in MongoDB that contains array data for each state, each of which has it's own inner array of zip codes. Here is a simplified example of the structure: [ { data: { name: 'Alabama', zip_codes: […
I was working on an aggregation pipeline to cleanup duplicate data from a collection on the database. But it was throwing the following error even after setting { allowDiskUse: true }. Err: "MongoServerError: PlanExecutor error during aggregation :: caused by…
Here see this Collection here have a record with createdAt with 14Feb and one with 16Feb, Now querying an aggregation on the collection such as I want to add an document of 15Feb as it was missing in collection with…
I have a collection of documents as follows: { "id": ..., "key": 47 }, { "id": ..., "key": 12 } I want to aggregate the whole collection to a single string, by concatenating the keys, delimited by |. So here,…
I collect device ON/OFF events in a timeseries table. Following is a sample data. time_stamp state 2023-10-04 10:05:53 0 2023-10-04 10:15:58 1 2023-10-04 10:30:59 0 2023-10-04 10:40:00 1 2023-10-04 10:55:01 0 2023-10-04 11:05:03 1 2023-10-04 11:35:36 0 2023-10-04 11:40:39 1…
I need to project phone numbers and emails from array and show them as Document Fields. Something like this: { Name: "Mac", Emails: [ {address: '[email protected]', title: '', isMain: true}, {address: '[email protected]', title: '', isMain: false} ], Phones: [ {number:…
I have a list of n rows (n < 100) with '#' separated values in postgres (version 13+) row value 1 'ABC#DEF#123' 2 'ABC#DEF#156' 3 'ABC#DEF#178' ... These values can be of any length (e.g. 'ABC#DEFDEF#GHIG#123123#456#678') There are no NULL…
Given a document with a subdocument from a $lookup aggregation, I want to project a specific field form the subdocument based on the field of the $$ROOT document. Example: { "date": "2023-08-20", "code": "USD", "exchange_rates": { "USD": 1.01, "EUR": 2.01,…
I have following data in my collection { “name": “test”, "data": { “statusOne”: “enabled”, “statusTwo”: “active” } } { “name": “test”, "data": { “statusOne”: “disabled”, “statusTwo”: “active” } } { “name": “another-test”, "data": { “statusOne”: “disabled”, “statusTwo”: “active” } }…