{{tag>search indexer elasticsearch indexer}}

====== How use IN equivalent operator in ElasticSearch? ======

<code sql>SELECT * FROM table WHERE id IN (1, 2, 3);</code>

The equivalent Elasticsearch 1.x filter would be:

<code json>{
  "query" : {
    "filtered" : {
      "filter" : {
        "terms" : {
          "id" : [1, 2, 3]
        }
      }
    }
  }
}</code>


The equivalent Elasticsearch 2.x+ filter would be:

<code json>{
  "query" : {
    "bool" : {
      "filter" : {
        "terms" : {
          "id" : [1, 2, 3]
        }
      }
    }
  }
}</code>