This content has been marked as final. Show 3 replies
There is no option to turn off this behavior. The QBE (Query by example) stuff treads 'and' and 'or' and '>' and '<' as operators. So the only solution would be to deep dive into the implementation in the VO.
don't seem to have much luck looking into the implementation.
buildViewCriteriaClauses(ViewCriteria vc) of ViewObjectImpl is the closest I have gotten to (i think). Not sure of other unintended consequences even if I were able to modify the whereclause this method is returning.
started looking into another option using the queryListener in the backing bean: basically using wildcards with the operators in the filter criteria map.
eg. replacing occurrences of ' AND ' with '_AND_' . and of course, reverting it after invoking the query.
have a look here
its for date ranges but should be easily modified to meet your requirement