I have DB with this structure:
{
country: 'USA',
invoices: [
{ client: 'Cliet_1', docNum: '23123j' },
{ client: 'Cliet_2', docNum: '34123j' },
{ client: 'Cliet_1', docNum: '3453412df' }
]
},
{
country: 'Canada',
invoices: [
{ client: 'Cliet_3', docNum: '23123j' },
{ client: 'Cliet_4', docNum: '34123j' },
{ client: 'Cliet_4', docNum: '3453412df' }
]
},
{
country: 'USA',
invoices: [
{ client: 'Cliet_1', docNum: '23123j' },
{ client: 'Cliet_2', docNum: '34123j' },
{ client: 'Cliet_5', docNum: '3453412df' }
]
}
I can’t figure out how to transform it into it:
[
{ country: 'USA', clients: ['Cliet_1', 'Cliet_2', 'Cliet_5'] },
{ country: 'Canada', clients: ['Cliet_3', 'Cliet_4'] },
]
Seems pretty easy and I could do it by JS but it would be better to use Mongo