Hi,
I'm need to write a query which provides the length of array fields inside an object which is stored as value in a map.
E.g.
{
"id":1,
"data": {
{
"2023": {
"array1" : ["A","B"],
"array2" : ["A","B","C"]
"array3" : ["Z","B"],
"array4" : ["R","B"]
},
"2024": {
"array1" : ["A","B"],
"array2" : ["A","B","C"]
"array3" : ["Z","B"],
"array4" : ["R","B"]
}
}
}
}
So my requirement is to find the length of each array inside the map.
Thanks
Abhi