Elastic Search Complex Logical Query (SQL to ElasticSearch Query)

174 Views Asked by At

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.

0

There are 0 best solutions below