#1 mORMot 1 » how do mormot groups query criterias » 2019-09-22 09:29:28

hanvas
Replies: 3

Hi all,

i have searched for a while and digged through the docs but i did not find an answer or even a hint.

In SQL i can use parenthesis to group query criterias:

Examples :

1. WHERE   ((a.id = 10) or (a.id=20)) AND
                   ((a.name LIKE '%what') or (a.name LIKE '%whine'))
2. WHERE ((a.id < 10) AND (a.name LIKE '%what')) OR
                 ((a.id >100) AND (a.name LIKE '%whine'))

is this kind of grouping query critieras possible with mormot.

Thanks in advance

hajoe

Board footer

Powered by FluxBB