My point was that EntityOperator.NOT seems half-baked. Just seeking to confirm
this.
Also, EntityExpr does not yet support unary operators (where left-hand side of expression is
omitted). Also seeking to confirm this.
Jonathon
BJ Freeman wrote:
I have used the NOT in SQL.
the where goes
where sno not 'S3'
and there is other ways of getting the results.
but instead of discussion at the SQL level what are you trying to
accomplish a the entity level.
Jonathon -- Improov sent the following on 12/15/2007 4:50 PM:
Oh, yeah, so there is an equivalent in SQL.
But is there a way to do this in OFBiz? Say "WHERE NOT sno = 'S3'"?
Using EntityExpr? Note that minilang does not support that "NOT" logical
in <entity-expr> nor <entity-condition>
Not that we really need this a lot. Any "NOT"ed expression can be
expanded, and the "NOT" removed.
Jonathon
BJ Freeman wrote:
http://www.firstsql.com/tutor2.htm
and is used for the same function in minilang.
you can say and expresion is equal then encase it in a Not to make it
not equal.
Jonathon -- Improov sent the following on 12/15/2007 4:15 PM:
I find no usage in OFBiz. Does it even have any equivalent in SQL?
Jonathon
