Elasticsearch Query

Elastic Stack Elasticsearch
1

Hi All,

I have record in Elasticsearch index like below. Can any one pls help me for curl query with following conditions.

Conditions:

  1. Type must be 'A'
  2. user must be 'U1' OR 'U3'
  3. date range between '8/22/2020' and '8/28/2020'

SQL:
select * from table1 where type="A" and user in("U1","U3") and date between "8/21/2020" and "8/28/2020"
expecting elastic query against above SQL query.

|id|type|user|date|
|1|A|U1|8/20/2020|
|2|A|U2|8/21/2020|
|3|A|U3|8/22/2020|
|4|E|U1|8/23/2020|
|5|A|U3|8/24/2020|
|6|A|U3|8/25/2020|
|7|E|U1|8/26/2020|
|8|A|U2|8/27/2020|
|9|A|U1|8/28/2020|
|10|A|U1|8/29/2020|

2

What have you tried so far?

3

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