N1QL for array elements

Couchbase Server
, , ,
6

Great!
Thank you for the explanation in detail. I have results now.

CREATE INDEX `ix` ON `bucketName`((distinct (array {"businessDate": (`d`.`businessDate`), "stockSymbol": (`d`.`stockSymbol`)} for `d` in `data` end)))

Following query provided result:

    select timestamp,
       ARRAY data FOR data in test.data 
       when
          {data.stockSymbol,data.businessDate}={"stockSymbol":"ADBL","businessDate":"2020-02-11"}
          END
          as data 
    from
       bucketName
    WHERE
       ANY d IN data SATISFIES {d.stockSymbol,d.businessDate}={"stockSymbol":"ADBL","businessDate":"2020-02-11"}
       END;

I’m going to mark this as solved but opening a new question to implement the same query using node.js. Please let me know if you have any solution to it as well.

Thank you.
Ankit Lalan

1 Like