I have a document that looks like this: { "startTime": 123, "endTime": 932345235, "type": "results", "validationResults": [ { "name": "xyz", "ruleViolated": 1, "details": [ { "timeStamp": 132345235, "place": "abc", "…

SELECT a.* , vr AS validationResults FROM bucketName AS a LET vr = (ARRAY OBJECT_PUT(b,"details", (ARRAY c FOR c IN b.details WHEN c.timeStamp BETWEEN 1462042800000 AND 1462043025018 END)) …

N1QL query Filtering data within an array

SQL++

koder1 April 24, 2019, 10:32am 7

@vsr1 The query above produces the desired result but it is taking too long to process. Around a minute when I have around 40,000 docs in the bucket.

Topic		Replies	Views
Pagination within document SQL++ query	3	833	September 11, 2019
N1QL for array elements Couchbase Server query , n1ql , server , index	9	4316	February 14, 2020
N1QL query to retrieve results based on matching criteria in array SQL++	4	8410	September 21, 2015
Filtering multiple nested array with n1ql query SQL++ n1ql	3	441	January 31, 2024
Need help for the array query SQL++ array-query	10	1248	January 19, 2021

N1QL query Filtering data within an array

Related topics