SQL NOT operator in OFBiz, does EntityOperator.NOT work?

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

SQL NOT operator in OFBiz, does EntityOperator.NOT work?

biletnikov
Hello all,
does OFBiz support SQL NOT operator in the entity engine implementation?

What I'd like to see as the final result is :
SELECT * FROM TABLE WHERE NOT(field1 = 'AAA' AND field2 = 'BBB' AND field3 = 'CCC')

it looks like 'EntityOperator.NOT' has what I need, but I have errors when I used it.  EntityOperator.NOT is the comparison operator.... Perhaps, I need an advice how to use it or is there any alternatives?

Thank you.
 
Kind regards,
Sergei