Here is a sample of my document structure and a document that would be returned by the query i seek. I want to query for documents that have detections where a detection where labelName is dog and another detection with labelName sofa Basically in the array of objects find docs with two types of d…

If all you’re looking for are documents where both elements exist, you could try: SELECT * FROM event e WHERE ANY d1 IN e.detections SATISFIES d1.labelName = "dog" END AND ANY d2 IN e.detections SATISFIES d2.labelName = "sofa" END HTH.

Query for docs with multiple array field matches on attribute values

SQL++

nhogan January 13, 2023, 3:36pm 5

Thank you very much that worked!

Sorry for the newb question!

Topic		Replies	Views
Couchbase Query with multiple conditions where clause Mobile query , java , n1ql	1	1672	June 30, 2017
How to use where in for multiple items? SQL++	1	1671	February 19, 2016
What is the best way to search array in docs if they match SQL++	6	1017	February 3, 2019
Query single value array SQL++ arrays	2	1614	February 21, 2020
Effective array index to match multiple items Couchbase Server	7	1885	March 22, 2017

Query for docs with multiple array field matches on attribute values

Related topics