We are evaluating N1QL. For POC, we used XDCR to ElasticSearch(EL) and querying data using EL. As far as now EL satisfies our need. But we really want to move to N1QL if N1QL can satisfy our needs.
Can N1QL support below type of condition?
(Condition1 OR Condition2) AND (Condition3 OR Condition4) AND (Condition5)
For Example, below is the document structure -
Our search condition can be - (Role1 OR Role2) AND (Role4)
Also is there any limit on conditions?