Elastic Search Complex Logical Query (SQL to ElasticSearch Query)

Question

My document schema is as follows.

Post

Id
Title
Body
Privacy -> Values can only be ["Me", "Anyone", "Team"]
UserId

What I want to do is retrieve all documents, but exclude documents where

Privacy = "Me" 
and 
UserId != "My-User-Id"

The SQL equivalent code is

SELECT * from Posts
WHERE (Privacy = "Anyone" OR Privacy = "Team")
OR (Visibility = "Me" AND UserId = 'My-User-Id')

I want to know how I can convert that SQL to the Elastic Search equivalent. Thanks, any help would be appreciated.

question from:https://stackoverflow.com/questions/65853643/elastic-search-complex-logical-query-sql-to-elasticsearch-query

Answer 1

Waitting for answers