You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ofbiz.apache.org by Jonathon -- Improov <jo...@improov.com> on 2007/12/16 01:15:01 UTC
Does EntityOperator.NOT serve any purpose?
I find no usage in OFBiz. Does it even have any equivalent in SQL?
Jonathon
Re: Does EntityOperator.NOT serve any purpose?
Posted by Jonathon -- Improov <jo...@improov.com>.
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
>>>>>
>>>>>
>>>>>
>>>>
>>>
>>>
>>>
>>
>>
>
>
Re: Does EntityOperator.NOT serve any purpose?
Posted by Jonathon -- Improov <jo...@improov.com>.
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
>>>>
>>>>
>>>>
>>>
>>
>>
>>
>
>
Re: Does EntityOperator.NOT serve any purpose?
Posted by BJ Freeman <bj...@free-man.net>.
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
>>>
>>>
>>>
>>
>>
>
>
>
>
Re: Does EntityOperator.NOT serve any purpose?
Posted by Jonathon -- Improov <jo...@improov.com>.
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
>>
>>
>>
>
>
Re: Does EntityOperator.NOT serve any purpose?
Posted by BJ Freeman <bj...@free-man.net>.
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
>
>
>