Hi, I need a help. I am unable to get “t_name.name” value from following document
{
“_rev”: “1-98850503ade89466c843dbbe8d2199c5”,
“_id”: “febaad09-ee40-4cee-b24e-6ac03ac8198a”
“t_items”: [
{
“itemId”: “edaaad09-ee40-4cee-b24e-6ac03ac8198a”,
“name”: “baby shop-l”,
“priceVariations”: [
{
“price”: “12”,
“sku”: “adssd”,
“variationId”: null,
“variationName”: “Regular”
},
{
“price”: “24”,
“sku”: “df”,
“variationId”: null,
“variationName”: “l”
}
],
“selecteQty”: 2,
“selectedPrice”: “48.00”,
“selectedVariation”: {
“price”: “24”,
“sku”: “df”,
“variationId”: null,
“variationName”: “l”
},
“type”: “ITEM”
},
{
“itemId”: “exaaad09-ee40-4cee-b24e-6ac03ac8198a”,
“name”: “kohampa-Regular”,
“priceVariations”: [
{
“price”: “43”,
“sku”: “dfded”,
“variationId”: null,
“variationName”: “Regular”
}
],
“selecteQty”: 1,
“selectedPrice”: “43.00”,
“selectedVariation”: null,
“type”: “ITEM”
}
],
“t_value”: 91 }
this is my query
SELECT t_name.name FROM todo WHERE type="transaction"
i need to get “t_name.name” and sum(selecteQty). i am getting “empty object”.