if i want to do projection with my data like following
{
"ProductName": {
"WORLDWIDE": {
"zh": "产品 1",
"en": "product 1"
},
"CHINA": {
"zh": "产品 2",
"en": "product 2"
}
}
}
to
{
"ProductName": "产品 2"
}
with some judgement then get specific data inside of ProductName
which kind of query json format should i use?
it's kind like mongodb aggergate projection