CB team,
I want to create index on “flightarea” array which is in the flightOptions object where documentId contains “TRT::” and while executing the query i should get all the documents which value has “PNR”
{
“documentId”: “TRT::Flight”,
“flightOptions”: {
“flightarea”: [
“PNR”,
“CNT”,
“TFA”
],
“resultsSet”: “100”
}
i have tried below but not getting expected result
CREATE INDEX idx_pref_custom_view ON FLIGHT_TEST (ALL ARRAY v.flightarea FOR v IN flightOptions END);