What is wrong in this elastic search query?

Question

I can't understand why I have no results? Using ES 2.

"query": {
      "filtered": {
         "query": {
            "match_all": {}
         },
         "filter": {
            "term": {
               "technical.techcolor": "red"
            }
         }
      }
   }

And here is the info from db that I am searching against.

{"technical":
        [{
         "techname22": "test",
         "techcolor":"red",
         "techlocation": "usa"
        }],
    "audio":
        {
        "someAudioMetadata": "test"
        }
    }

Answer 1

Since you have not specified your mapping, I am considering the following mapping.

Mapping:

{
  "mappings": {
    "company": {
      "properties": {
        "technical": {
          "type": "nested"
        }
      }
    }
  }
}

Search Query:

{
  "query": {
    "filtered": {
      "query": {
        "match_all": {

        }
      },
      "filter": {
        "nested": {
          "path": "technical",
          "filter": {
            "term": {
              "technical.techcolor": "red"
            }
          }
        }
      }
    }
  }
}

Search Result:

"hits": {
        "total": 1,
        "max_score": 1.0,
        "hits": [
            {
                "_index": "demos",
                "_type": "company",
                "_id": "1",
                "_score": 1.0,
                "_source": {
                    "technical": [
                        {
                            "techname22": "test",
                            "techcolor": "red",
                            "techlocation": "usa"
                        }
                    ],
                    "audio": {
                        "someAudioMetadata": "test"
                    }
                }
            }
        ]
    }

To know more about nested datatype you can refer to this official documentation and for Query and Filter Context refer this