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
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
Yes, it is possible. I do not see anything wrong with it. You can control the priority of the AND/OR operators using parenthesis.
Thanks for the info, will try it
Compound statements using multiple range constraints and AND/OR operators along with parenthesis works very well.