How can I index array fields in Couchdb 2.0

Question

I want to index an array field, I have the next JSON

{
    "id": "invoice1",
    "sellers": [{
        "names": "Clark",
        "items": [{
            "iditem": "item1",
            "properties": [{
                "width": "212cm"
            }]
        }]
    }]
}

I would like to create an index in width propertie, I already used create index with

{
   "index": {
      "fields": [
         "sellers.[].items.[].properties.[].width"
      ]
   },
   "type": "json"
}

this is the answer in many posts but when I create the above index and when I query a selector

{
   "selector": {
      "sellers": {
         "$elemMatch": {
            "items": {
               "$elemMatch": {
                  "properties": {
                     "$elemMatch": {
                        "width": {
                           "$eq": "212cm"
                        }
                     }
                  }
               }
            }
         }
      }
   }
}

The response is

"warning": "no matching index found, create an index to optimize query time"

Possible duplicate of [Mango search in Arrays](https://stackoverflow.com/questions/43892556/mango-search-in-arrays) — Jonathan Hall, Jul 12 '19 at 08:00
I am doing and I did the same in the referenced post but the answer is the same..."warning": "no matching index found, create an index to optimize query time" — Julian Solarte, Jul 12 '19 at 13:40
Can you try changing your query to have a single $elemMatch on `sellers.[].items.[].properties.[].width` ? — Alexis Côté, Jul 12 '19 at 15:35
Sorry, it was a typo, I already try using a dot sellers.[].items.[].properties.[].width — Julian Solarte, Jul 12 '19 at 16:34

How can I index array fields in Couchdb 2.0

0 Answers0