I need help writing a MongoDB aggregation function. My app is used node, express, and mongoose. The output of this aggregation will display in a table. Below is the criteria for the aggregation, an example of the how the data will display in the table.
Attached is a sample document that the aggregation will utilize.
******ACCESS TO OUR DB AND CODE BASE WILL NOT BE GRANTED.
Aggegation Criteria:
Find all where _store === ObjectID('12345') && blanks_order === false
group by style_number, color, and size
sum the total of each
Result should be something like:
{
{
style_number: G1000,
{
color:
{ black: [ S:14, M:33, L:4 ] },
{ red: [ S:2, L:16, XL:, 5 ] }
}
},
{
style_number: 3487,
{
color:
{ orange: [ 3XL:1 ] },
}
}
}
Output Table:
Style Number Color Size & Qty Action
---------------------- ----------- ---------------- -------------
G1000 Black [ S:14, M:33, L:4 ] Update
G1000 Red [ S:2, L:16, XL:, 5 ] Update
3487 Orange [ 3XL:1] Update
hi
i am expert on these skills with 100% customer satisfication and on time delivery
I am an Experience Full Stack Lead Developer with a Decade of Experience in versatile software development methods and technologies. Expertise in C#, Python, Nodejs.
I have worked on Angular, Reactjs and React Native on web and hybrid apps.
Developed Architectures and System Designs in MongoDb, MySql, Sql Server and Redis.
Check My Recent Large Scale Social Media Platform (.Net,Nodejs,Angular,MongoDb,Redis,Solr):
[login to view URL]
I have been managing Amazon instances and services for large scale social media web project.
I have been working on Ci and Cd using Jenkins and VSTS. I have introduced TDD and BDD practices and Test automation techniques.
If you wish to discuss further let me know.
Thanks