CouchDB查询选择器在字符串中的元素阵列中

Question

我需要获取games数组列表中的Archery的文档。我该如何处理CouchDB选择器？

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

Answer 1

您可以使用$elemMatch：

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

它将返回games字段等于"射箭"