Aggregating table to json combined with references to other tables – Postgresql
Table A: id status 1 1 2 4 Table B: id status a_id 1 1 1 2 3 1 3 5 2 Table A ( id int, status int); Table B( id int, status int, a_id int foreignt key reference…
How do I put multiple documents/objects into one document/object in MongoDB
I have a list of documents that looks like this: config: { _id: ObjectId('63c6a4b858612f44f37d4771'), type: "TypeA", priority: 1 } config: { _id: ObjectId('627279d3ba7aef5d6418c867'), type: "TypeB", priority: 3 } config: { _id: ObjectId('628b4d3ff5b1c1736c0b654a'), type: "TypeC", priority: 4 } The type is…
Get Count 0 if there are no entries in the RIGHT Table – Postgresql
Websites: website_Id website_name 1 website_a 2 website_b 3 website_c 4 website_d 5 website_e Fixtures: fixture_Id website_id fixture_details 1 1 a vs b 2 1 c vs d 3 2 e vs f 4 2 g vs h 5 4 i…
Mongodb – Create an object to already existing collection
I have a collection "product_reviews" with this document structure { _id: 'B000000OE4', 'product/title': 'Working Class Hero', 'product/price': '16.99', reviews: [ { 'review/userId': 'unknown', 'review/profileName': 'unknown', 'review/helpfulness': '2/3', 'review/score': '4.0', 'review/time': '27/05/1999/00:00:00', 'review/summary': 'Worth it for one song', 'review/text': "I really…
MongoDB move element inside a document
I want to update all documents that match a field and move this element (and I want all properties of this element kept). Dataset : [{ "name": "Guillaume", "childrens": [{ "name": "Robert", "degree": "License" } ], "students": [ { "name":…
Retrieve only queried element from a single document in mongoDB
I have a collection like below : `{ "topics" : [ { "id" : "2", "name" : "Test1", "owner" : [ "123" ] }, { "id" : "3", "name" : "Test2", "owner" : [ "123", "456" ] } ] }`…
MongoDB nested map aggregation to sum a array element
I have the following data: [ { "result": { "events": [ { "amount": [ [ 1623224700000, "33333333" ], [ 1623224760000, "33333333" ], [ 1623224820000, "33333334" ] ], } ], } } ] In amount, the second element (str) is the…
mongodb get all values for a specific field in an inner array
I am new to mongodb and I am struggling to understand something that I think should be pretty simple, maybe you can point me out in the right direction! Lets say I have the following single document in a collection:…
Aggregating JSON items in a list in Python
I would appreciate your help to aggregate dataset. I have a dataset something link below, and I want to aggregate ids if the other values are the same. Current Data: dataset= [ {'title' : 'XYZ', 'Description' : 'XYZ Description', 'instance_id'…
How can I find a value from an array using another object value in MongoDB group aggregation?
I have a collection where I want to find one data based on another object data: const data = [ { _id :0, name:"jane", joined : ISODate("2011-03-02"), likes : 30, dislikes: 9}, { _id :1, name: "joe", joined : ISODate("2012-07-02"),…