CouchDB query selector on string in array of elements

Question

I need to get the documents where exists Archery in the array list of games. How can i do with CouchDB selector?

[{
    "name": "John",
    "games": ["Archery", "Board sports"]
},
{
    "name": "Sara",
    "games": ["Fishing", "Archery"]
},
{
    "name": "Tara",
    "games": ["Decathlon"]
}]

Possible duplicate of [Cloudant Selector Query for fetching particular elements inside Array](https://stackoverflow.com/questions/45460879/cloudant-selector-query-for-fetching-particular-elements-inside-array) — Jonathan Hall, Mar 14 '19 at 18:31

Rouliboy · Accepted Answer · 2020-02-14T08:42:16.390

3

You can use $elemMatch:

{
   "selector": {
      "games": {
         "$elemMatch": {
            "$eq": "Archery"
         }
      }
   }
}

It will return all objects where games field equals 'Archery'

edited Feb 14 '20 at 08:42

answered Feb 12 '20 at 10:27

Rouliboy

1,377
1
8
21

CouchDB query selector on string in array of elements

1 Answers1