thomasg wrote:
Cheers Marcel, its working as expected now. I should have tried the lowercase or. The fact that 'AND' was not giving an invalid query and working as expected must have made me assume that the operators had to be upper case!
I see. that is indeed a bit misleading. I think that's a bug in the query parser. It seems it simply dropped the AND tokens end ended up with multiple predicates. which are by definition ANDed ;)
regards marcel
