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 — Jonathan Hall
– Jonathan Hall, Commented Mar 14, 2019 at 18:31

Rouliboy · Accepted Answer · 2020-02-14 08:42:16Z

4

You can use $elemMatch:

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

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

edited Feb 14, 2020 at 8:42

answered Feb 12, 2020 at 10:27

Rouliboy

1,3971 gold badge8 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

CouchDB query selector on string in array of elements

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related