How could I have MySQL IN clause within my elasticsearch query?

Question

I'm trying perform an elasticsearch query as a GET request in order pull data from the index which I created. The data which is in the index is, a table from MySQL DB, configured though logstash.

Here is my request without the IN clause:

http://localhost:9200/response_summary/_search?q=api:"location"+AND+transactionoperationstatus:"charged"+AND+operatorid='DIALOG'+AND+userid:test+AND+time:"2015-05-27"

In the above, I should be able to append AND responseCode IN (401,403). I tried giving it a search on the web, but couldn't find any solutions.

Any help could be appreaciated.

score 1 · Accepted Answer · answered Sep 29 '16 at 05:26

1

Simply append either of these:

responseCode:(401 403)
responseCode:(401 OR 403)
responseCode:(401 || 403)

Like this:

http://localhost:9200/response_summary/_search?q=api:"location"+AND+transactionoperationstatus:"charged"+AND+operatorid='DIALOG'+AND+userid:test+AND+time:"2015-05-27"+AND+responseCode:(401+403)

answered Sep 29 '16 at 05:26

Val

207,596
13
358
360

any idea how can mysql `sum()` be appended to the above query? – Kulasangar Sep 29 '16 at 06:20
Since this is a different issue, feel free to ask a new question so we don't cram too much into this one – Val Sep 29 '16 at 06:38
yup sure, will post as another! – Kulasangar Sep 29 '16 at 06:47

How could I have MySQL IN clause within my elasticsearch query?

1 Answers1

Linked