Trying to breakdown query into ES query

Elastic Stack Elasticsearch
1

hey all,

Needed some help.

Im trying to do some query type stuff with ES, and wanted to know if it would even be possible, if so, how would I accomplish something like this.

SELECT * FROM Tickets WHERE (status = open AND queue = support) AND (email = *@1234.com OR email = *@67890.com OR last_response >= 15 minutes)

or

SELECT * FROM Tickets WHERE (status = closed AND queue = help) OR (status = open AND queue = support)

2

There are a few ways to translate that into an Elasticsearch query, but the simplest way is to start with Query String Query.

3

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