Hmm, even EntityOperator.BETWEEN isn't working.
I'll fix JIRA issue 1045 right now. Coming up...
Jonathon
Jonathon -- Improov wrote:
> 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
>>>>>
>>>>>
>>>>>
>>>>
>>>
>>>
>>>
>>
>>
>
>
Locked
