Add multiple Filters to a search

[howzit]

Hi, I am struggling to understand how to add multiple filters to a search. Can you assist?

[confact]

If you still have problem i can assist.

[tejashwikalptaru]

Hello, may I have the example of search?

[sk-karthik]

hi, can you comment example search query

[chirayushri]

Hello,please provide the example of search ? query_all is not support LIKE Statement .. How i execute search operation ?

[sk-karthik]

Sample Search Query { "query":{ "bool":{ "must":[ {"match":{"createdDate":"2018-07-15"}}, {
"bool":{ "should":[ {"match":{"status":"Y"}}, {"match":{"deletestatus":"N"}} ] } }
] } } }

[chirayushri]

its worked for exact match.. how i perform like operation as in sql for elastic ?? How i query following please ?? Select * from lists where list_name LIKE '%edu%'

[sk-karthik]

You can use "match_phrase"

{ "query": { "match_phrase": { "list_name": "edu" } } }

[chirayushri]

plz give example for this library which function used for execute this format query ..

[confact]

@chirayushri this is easy to do with the advancedquery function. just do what @sk-karthik say, by making a json object to send as one of the paramater to the advancedquery function.