I want to write a query which always select second value of “trim” from this array. For now i am able to create the query which fetches all the value or trim.
SELECT ARRAY remark.trim for remark IN mn.remarks.internal.remarks.remark END,1) AS VAL FROM bucket
AS mn
remarks": {
“internal”: {
“remarks”: {
“remark”: [
{
“trim”: “ABC”
},
{
“type”: “ABC”,
“cd”: “SUPER”,
“trim”: “false”
}
]
}
}
},
If you know exact position …
SELECT mn.remarks.internal.remarks.remark[1].trim
FROM `bucket` AS mn;
If you want by condition and by position
SELECT (ARRAY v.trim FOR v IN mn.remarks.internal.remarks.remark WHEN v.trim IS NOT NULL END)[1]
FROM `bucket` AS mn;
OR
SELECT (SELECT r.trim FROM mn.remarks.internal.remarks.remark AS r WHERE ......)[1]
FROM `bucket` AS mn;
Thanks @vsr1 . It really helps