Let say my SQL query will be as follow:
SELECT A,B,C,D FROM TABLE1 WHERE A in ('a','b','c') AND B > 20

How can I write the elasticsearch query so that it works the same manner as the query above?


You can try to translate the original query to SQL.

Otherwise, you need probably here a bool query with 2 must clauses.
One clause would be a terms query and the second clause a range query.

Create a bool query with filter range and must should inside. Then use _source to select only which columns to return.

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.