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.
