Query Dsl Terms

Used to match on any of the values
Equivalent of sql statement:

select * from orders where id = "1" or id = "2"

Example

curl -XPOST 'localhost:9200/orders/orders/_search?pretty=true' \
  -H 'content-type:application/json' \
  -d '{
  "query" : {
    "terms": {
      "id": [ "1", "2"]
    }
  }
}'

Can be extended with lookup - where list of values is a reference to a doc:

curl 'localhost:9200/orders/orders/_search?pretty=true' \
  -H 'content-type:application/json' \
  -d '{
  "query" : {
    "terms": {
      "id": {
        "index" : "lateorders",
        "type" : "lateorders",
        "id" : "2018-01-01",
        "path" : "ids"
      }
    }
  }
}'