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