CODEWITHSUNDEEP
elasticsearch
Sharmila Gaddipati
Sharmila Gaddipati

Reputation: 15

facing problems with terms filter

My mapping looks like the below. "BID": { "type": "string" }, "REGION": { "type": "string" },

Now I am trying to search for the records whose BID values are B100, B302. I've written below query. Though I've records with those ID values, I am not getting any results. Any clue where I am doing wrong?

{"query": {"filtered": {"filter": {"terms": {"BID": ["B100","B302"]}}}}}

Upvotes: 1

Views: 41

Answers (1)

Sloan Ahrens
Sloan Ahrens

Reputation: 8718

Try using lower-case values, like:

{"query": {"filtered": {"filter": {"terms": {"BID": ["b100","b302"]}}}}}

You need to do this because, since you did not specify an analyzer in the definition of "BID" in your mapping, the default standard analyzer is used, which will convert letters to lower-case.

Alternatively, if you want to maintain the case in your index terms, you can add "index": "not_analyzed" to your mapping definition for "BID".

To test I set up an index like this:

PUT /test_index
{
   "mappings": {
      "doc": {
         "properties": {
            "BID": {
               "type": "string",
               "index": "not_analyzed"
            },
            "REGION": {
               "type": "string"
            }
         }
      }
   }
}

added a few docs:

POST /test_index/doc/_bulk
{"index":{"_id":1}}
{"REGION":"NA","BID":"B100"}
{"index":{"_id":2}}
{"REGION":"NA","BID":"B200"}
{"index":{"_id":3}}
{"REGION":"NA","BID":"B302"}

and now your query works as written:

POST /test_index/_search
{
   "query": {
      "filtered": {
         "filter": {
            "terms": {
               "BID": [
                  "B100",
                  "B302"
               ]
            }
         }
      }
   }
}
...
{
   "took": 1,
   "timed_out": false,
   "_shards": {
      "total": 1,
      "successful": 1,
      "failed": 0
   },
   "hits": {
      "total": 2,
      "max_score": 1,
      "hits": [
         {
            "_index": "test_index",
            "_type": "doc",
            "_id": "1",
            "_score": 1,
            "_source": {
               "REGION": "NA",
               "BID": "B100"
            }
         },
         {
            "_index": "test_index",
            "_type": "doc",
            "_id": "3",
            "_score": 1,
            "_source": {
               "REGION": "NA",
               "BID": "B302"
            }
         }
      ]
   }
}

Here is some code I used for testing:

http://sense.qbox.io/gist/b4b4767501df7ad8b6459c4d96809d737a8811ec

Upvotes: 1

Related Questions