DESIGN DOC

$OR not working at all

 {"$or":[{"name":"james"},{"name":"doe"}]}

gistfile1.txt

{
  "_id": "_design/19398d38b0a026e2b1e4a82dfa5aea65a51c0782",
  "_rev": "1-a500b8628ef2ae8123b6f6f527288d01",
  "language": "query",
  "views": {
    "19398d38b0a026e2b1e4a82dfa5aea65a51c0782": {
      "map": {
        "fields": {
          "name": "asc",
          "colors": "asc",
          "timestamp": "asc"
        }
      },
      "reduce": "_count",
      "options": {
        "def": {
          "fields": [
            "name",
            "colors",
            "timestamp"
          ]
        },
        "w": 2
      }
    }
  }
}

NOT WORKING SELECTOR

selector : {
                        "$and": [
                            {
                                'timestamp': {'$gte': 0},
                            },
                            {
                                "$or" : [
                                    {
                                    "$and" : [
                                        {"name":{"$eq":"james"}},
                                        {"colors":{"$elemMatch":{"$in":["red","blue"]}}}
                                    ]},
                                     {
                                    "$and" : [
                                        {"name":{"$eq":"doe"}},
                                        {"colors":{"$elemMatch":{"$in":["orange","black"]}}}
                                    ]}
                                    
                                ]
                            }
                        ]
                    }

WORKING SELECTOR

selector : {
                        "$and": [
                            {
                                'timestamp': {'$gte': 0},
                            },
                            {
                                "$and" : [
                                        {"name":{"$eq":"doe"}},
                                        {"colors":{"$elemMatch":{"$in":["red","blue","black"]}}}
                                ]
                            }
                        ]
                    }