Hot to filter out the results which NOT equal to the key words?

Hi there,

I am wondering how can I filter the search result filtering the field!='key words'? something like:
select * from tbl where col1!='test'

Thanks,
Chelsea

Hi,

Look at Bool query must_not with the TermQuery in.

https://www.elastic.co/guide/en/elasticsearch/reference/current/query-dsl-bool-query.html

bye,
Xavier

1 Like

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