I'm pretty new to MongoDB and I need to group the sum of the total of all invoices for each unique date in all the documents in a collection. This is a summary of the collection, where data is stored…
I'm trying to add up two amounts within an object inside an Aggregate pipeline. Here's my sandbox: https://mongoplayground.net/p/LIvksL-UGur Document: [ { "result": { "invoices": [ { "product": "baseball", "amount": 4, "tax": 1 }, { "product": "basketball", "amount": 10, "tax": 2…
I am trying to get all the movies from the latest 20 years of the document. I am trying like this but doesnt work. It´s the first time I use mongoDB so I am a bit lost, it may be…
I tried to use aggregate and lookup but look like I cannot keep role in the members item. Any idea how to resolve it? db.groups.insertMany([ { title: 'Hi', members: [ { userId: ObjectId('62589515f239750e7e44b958'), role: 'Admin' }, { userId: ObjectId('655f634c632d0c23b9d455de'), role:…
I am trying to get a single row for each group by clause in the query. Each SELECT output has a json in it. I am trying this: SELECT MIN(C.json_column->'key') AS Key, A.field1, B.field2 FROM json_table AS C LEFT JOIN…
Convert json pipeline to Aggify query this is my pipeline , how can i convert this to Aggify query I need to simplify some of my queries by using the aggify generator, which is a python package, so that it…
I used a $lookup to join a connection There was no problem under normal circumstances. But after using pipeline, the program gives an error :"Unsupported conversion from array to objectId in $convert with no onError value" { $lookup: { from:…
I have a hierarchal aggregate that uses below statement CREATE MATERIALIZED VIEW IF NOT EXISTS public.values_summary_five_minutes WITH (timescaledb.continuous,timescaledb.materialized_only = true) AS SELECT variableid, time_bucket(INTERVAL ‘5 minute’, bucket_interval_one_min) AS bucket_interval_five_min, MIN(Min_IntValue) as Min_IntValue, MAX(Max_IntValue) as Max_IntValue, SUM(Sum_IntValue) as Sum_IntValue, COUNT(Count_IntValue) as…
I have a list of movies like this: [ { "title":"X", "genres":[ { "tag":"Horror" }, { "tag":"Thriller" }, { "tag":"Mystery" } ] }, { "title":"Zero Dark Thirty", "genres":[ { "tag":"Thriller" }, { "tag":"Drama" }, { "tag":"History" }, { "tag":"War" }…
Loop through a object array find a key and then change its value in javascript Hi I have a below array of objects [ { createdDateTime: { '$gte': '2023-02-08T00:00:00.000Z', '$lte': '2023-05-09T23:59:59.000Z' } }, { user: 'customer' } ] I want…