Hi. I have a couchbase bucket results and I store the records with the following format: [ { "results": { "data": [ {...}, {...}, {...} ] } }, { "results": { "data": [ {...}, {...} ] } } ] So what I want to do is to count and…

How about: SELECT SUM(ARRAY_LENGTH(r.data)) FROM results r ? Array Functions | Couchbase Docs You can use array functions to evaluate arrays, perform computations on elements in an array, and to return a new array based on a transformation. HTH.

Count sub-objects' array length

Couchbase Server

dh January 14, 2022, 2:30pm 2

How about:

SELECT SUM(ARRAY_LENGTH(r.data)) FROM results r

HTH.

1 Like

Topic		Replies	Views
Array JOIN same bucket count SQL++	7	1247	October 18, 2018
Bug:NIQL COUNT() function returns 1 SQL++	5	2101	January 16, 2014
Array count using subdocument api (4.5) Couchbase Server	4	836	September 20, 2018
Querying from array of objects Couchbase Server	3	546	September 25, 2020
Select object nested in array Couchbase Server query	2	507	October 22, 2022

Count sub-objects' array length

Related topics