What does "Add Parenthesis" in Search dialog are used for?

rbuser

I have searched through all of your documentation but still was unable to
find how those Add and Remove Paretheses are used.
Can you explain it to me?

Thanks.

digitalmetaphors

Parenthesis are needed sometimes so you can AND or OR criteria together to
achieve different results. The AND or OR is added to the WHERE clause of the
generated SQL. By default, the AND's are implicitly when you add criteria in
the search dialog. Try testing with some different expressions. You can add
OR's to force two conditions to be OR'ed together. When you view the SQL
that is generated, you should see the OR in the WHERE clause.

WHERE (SomeCriteria1 and SomeCriteria2) OR SomeOtherCriteria


Cheers,

Jim Bennett
Digital Metaphors