@vsr1 I have a quick question: I have a document containing someting similar with: "level-1": { "level-2": { "A": { "cr": 483, "crt": 1618930800, "hr": 270, "hrt": 1618837200 }, "B": { …

SELECT FIRST v.`1234` FOR v WITHIN d WHEN v.`1234` IS NOT MISSING END AS A FROM default AS d WHERE ....; SELECT ARRAY_FLATTEN(ARRAY (ARRAY v.[TO_STR(v1)] FOR v1 IN [12345,6789] WHEN v.[TO_STR(v1)] NOT MISSING END) FOR v WITHIN d END,2) AS A FROM default AS d WHERE ....;

Select from object two level down without knowing the keys

SQL++

flaviu May 26, 2021, 6:37pm 5

oh yes, I am so stupid

Topic		Replies	Views
N1QL to fetch by path levels SQL++	9	1668	April 26, 2017
Find data from documets wich have keys which I chose from another select SQL++ query , n1ql	7	861	November 22, 2020
N1QL with array SQL++	4	643	November 5, 2020
Nested document - Query Data Couchbase Server query , n1ql	2	718	July 29, 2020
Selected nested values and their result representation SQL++ query	4	717	April 20, 2018

Select from object two level down without knowing the keys

Related topics