database - 带 OR 条件的 CouchDB View

Question

我在 couchDB 中有两种 json 类型的文档:

1. 
{
 "_id": "4a91f3e8-616a-431d-8199-ace00055763d",
 "_rev": "2-9105188217acd506251c98cd4566e788",
 "Vehicle": {
     "type": "STRING",
     "name": "Vehicle",
     "value": "12345"       
 },
"Start": {
     "type": "DATE",
     "name": "Start",
     "value": "2014-09-10T11:19:00.000Z"      
 }
}

2. 
{
   "_id": "4a91f3e8-616a-431d-8199-ace00055763d",
   "_rev": "2-9105188217acd506251c98cd4566e788",
   "Equipment": {
       "type": "STRING",
       "name": "Equipment",
       "value": "12345"       
   },
"Start": {
   "type": "DATE",
   "name": "Start",
   "value": "2014-09-10T11:19:00.000Z"      
 }
}

我想创建一个 View 来搜索所有这些 doc.Vehicle.value=12345 或 doc.Equipment.value=12345 的文档。我怎样才能使这个 View 返回所有这些类型的文档。提前致谢。

Answer 1

只需在您的 View 中同时发出(是的， map 函数可能会为同一文档发出多次不同的键值)值:

function(doc){
  if (doc.Equipment) {
    emit(doc.Equipment.value, null)
  }
  if (doc.Vehicle) {
    emit(doc.Vehicle.value, null)
  }
}

并通过相同的 key 请求它们:

http://localhost:5984/db/_design/ddoc/_view/by_equip_value?key="12345"

另见 Guide to Views有关 CouchDB View 的更多信息。