Compound Query with multiple ranges

General
1

Is it possible to have a query statement that can handle multiple ranges?

For example: where=column=3 AND column1>=10 AND column2<=20 OR column1>=45 AND column2<=68

2

Yes, it is possible. I do not see anything wrong with it. You can control the priority of the AND/OR operators using parenthesis.

3

Thanks for the info, will try it

4

Compound statements using multiple range constraints and AND/OR operators along with parenthesis works very well.