Hi Team,
How do i select Transaction field from this document? Looks like querybench things Transaction is a key word.
{
“Id”: “abc::14835”,
“$Type”: “abc”,
“$MdfdById”: “yyy”,
“$MdfdTmstmp”: “2020-06-23T15:18:13.263Z”,
“RunStats”: [ { “Transaction”: “bvc”,
“Status”: “Inprogress”,
“BatchId": “yyyyyyy”,
“CreateTime”: “2020-06-23T15:18:13.263Z”,
“ValidForMins”: “9999”,
“RecCount”: “98”
} ]
}
Use escaped identifier https://docs.couchbase.com/server/current/n1ql/n1ql-language-reference/identifiers.html#escaped-identifiers
SELECT r.`Transaction`
FROM default AS d
UNNEST d.RunStats AS r
WHERE .....