Do you have "supportsOrCriteria" turned to "true"?
After I added it, it works now. But can I ask why it worked for "AND" operator even i don't have "supportsAndCriteria" turned to "true"?
Thanks a lot.
The planner doesn't have a concept of limiting conjunct pushdowns. We have yet to come accross a situation where predicates are supported, but only one at a time (if for example predicates are only supported against a single column, then all others can be marked as unsearchable).