ElasticSearch : IN equivalent operator in ElasticSearch

http://stackoverflow.com/questions/30111258/elasticsearch-in-equivalent-operator-in-elasticsearch

Similar to what Chris suggested as a comment, the analogous replacement for IN is the terms filter (queries imply scoring, which may improve the returned order).

SELECT * FROM table WHERE id IN (1, 2, 3);

The equivalent Elasticsearch filter would be:

{
  "query" : {
    "filtered" : {
      "filter" : {
        "terms" : {
          "id" : [1, 2, 3] }
      }
    }
  }
}