So I am noob on NoSQL and MongoDB by reference as well. Let’s say we have this structure (do considered the are id objects:
Curriculas{
name: String,
hours: { type: Number, min: 0 },
modules: {
name: String,
theoreticalHours: { type: Number, min: 0 },
practicalHours: { type: Number, min: 0 },
}}
The result we are to required to produce is something like this:
| name | hours | (module)Name | theoreticalHours | PracticalHours |
|---|---|---|---|---|
| Weilder | 50 | Types of metal | 3 | 7 |
| Weilder | 50 | Weilding types | 10 | 20 |
| Weilder | 50 | Finishings | 2 | 8 |
| Plumber | 35 | Types of Pipes | 2 | 3 |
| Plumber | 35 | Unions and Reductions | 5 | 10 |
| Plumber | 35 | Valves and Faucets | 5 | 10 |
so far I have poorly failed to accomplish this and export this to excel directly using either shell or compass. I’ve learnt to filter, to include and not include fields but I have been for days -(every single possible solutions leads to lots of reading and or watching videos, which ended teaching the same topics)- looking for results that look like this and no videos or anything else have given me any Ideas on how to do so. It has misled me to believe this is not done much on MongoDB ( I do not think so). Pleas help. Pd- on SQL database this would have not been a sweat.