C00 AND C01 OR C02

is equivalent to (C00 AND C01) OR C02

and means that questions/conditions 0 (i.e. C00) and 1 (i.e. C01)

or question/condition 2 (i.e. C02) have to be fulfilled for the record to be

selected. In a given database, this could allow the retrieval of

900 records (for example).

Using another groupings of the questions, like

C00 AND (C01 OR C02)

will lead to another selection of records 30 (for example). In this latter

example questions/conditions 1 or 3 have to be fulfilled at the same time than

question 0.

The use of brackets can therefore importantly change the results of the

queries, even with the same original questions/conditions.

All the opened brackets have to be closed. You may remove a question

manually. For example, in:

C00 AND C01 AND C02

you may remove the question/condition 1 and this would then look like:

C00 AND C02

The AND, OR, NOT could be switched. For example, you may manually change

the following query

(C00 AND C01) OR C02

to

(C00 AND NOT C01) OR C02

or to

C00 AND C01 AND C02

Also keep a space before and after the AND, OR and the NOT.

Don not add any other character than the opening '(' and closing ')' brachets.

Wrongly written advanced queries like:

C00 AND C01) AND C02

or

C00 AND C01 AND C02

or

C00 AND C01AND C02

...

will lead to a message stating that no record was found or that the query was wrong.