N1QL for array elements

Couchbase Server
, , ,
7

If you are looking equality only

CREATE INDEX `ix` ON `bucketName`((distinct (array  [d.stockSymbol , d.businessDate ] for `d` in `data` end)));
select timestamp,
       ARRAY data FOR data in test.data 
       when  dtata.stockSymbol = "ADBL" AND d.businessDate = "2020-02-11"  END
          AS  data 
    from
       bucketName
    WHERE
       ANY d IN data SATISFIES [d.stockSymbol,d.businessDate] = ["ADBL","2020-02-11"]  END;

Check this post for explanation Creating a covered index with array, how to access array elements in select?
Composite index from an array of objects