Home End User
New Blog Posts: Merging Reports - Part 1 and Part 2

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

edited May 2003 in End User
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.

Comments

  • edited May 2003
    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


This discussion has been closed.