[OFBiz] Dev - any way to do a not null query with entity engine?

[Si Chen-2]

Hi.

Is there anyway to do a find with the entity engine where one the fields
is "NOT NULL"?

Thanks!

Si
 
_______________________________________________
Dev mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/dev

[Si Chen-2]

Ok.  Found it:
new EntityExpr("postedBalance", EntityOperator.NOT_EQUAL, null)

:-)

Si Chen wrote:

> Hi.
>
> Is there anyway to do a find with the entity engine where one the
> fields is "NOT NULL"?
>
> Thanks!
>
> Si
>
> _______________________________________________
> Dev mailing list
> [hidden email]
> http://lists.ofbiz.org/mailman/listinfo/dev
>

 
_______________________________________________
Dev mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/dev

[Adam Heath-2]

On Tue, 2 Aug 2005, Si Chen wrote:

> Hi.
>
> Is there anyway to do a find with the entity engine where one the fields
> is "NOT NULL"?

new EntityExpr(new EntityFieldValue("fieldName"), EntityOperator.NOT_EQUALS,
null);
 
_______________________________________________
Dev mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/dev

[Adam Heath-2]

On Tue, 2 Aug 2005, Si Chen wrote:

> Ok.  Found it:
> new EntityExpr("postedBalance", EntityOperator.NOT_EQUAL, null)

That's deprecated.  The system doesn't know if that is a field name, or a
constant string value.
 
_______________________________________________
Dev mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/dev

[Si Chen-2]

Interesting....  I did not know this.  Thanks for pointing it out.

Si

Adam Heath wrote:

>On Tue, 2 Aug 2005, Si Chen wrote:
>
>  
>
>>Ok.  Found it:
>>new EntityExpr("postedBalance", EntityOperator.NOT_EQUAL, null)
>>    
>>
>
>That's deprecated.  The system doesn't know if that is a field name, or a
>constant string value.
>
>_______________________________________________
>Dev mailing list
>[hidden email]
>http://lists.ofbiz.org/mailman/listinfo/dev
>
>  
>

 
_______________________________________________
Dev mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/dev

[David E. Jones]

It should still work. If not made explicit it defaults to treating it  
as a field name for the first argument.

-David


On Aug 2, 2005, at 5:24 PM, Adam Heath wrote:

> On Tue, 2 Aug 2005, Si Chen wrote:
>
>
>> Ok.  Found it:
>> new EntityExpr("postedBalance", EntityOperator.NOT_EQUAL, null)
>>
>
> That's deprecated.  The system doesn't know if that is a field  
> name, or a
> constant string value.
>
> _______________________________________________
> Dev mailing list
> [hidden email]
> http://lists.ofbiz.org/mailman/listinfo/dev
>

 
_______________________________________________
Dev mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/dev

[Adam Heath-2]

On Tue, 2 Aug 2005, David E. Jones wrote:

>
> It should still work. If not made explicit it defaults to treating it
> as a field name for the first argument.

That's the definition of deprecated.
 
_______________________________________________
Dev mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/dev

[David E. Jones]

Hmmm... I thought deprecated meant no longer used and no longer  
supported and planned for phase-out... This is a feature that will  
always be there (as long as I have anything to say about it) and is  
just a default treatment....

Not sure I get your meaning...

-David


On Aug 3, 2005, at 9:46 PM, Adam Heath wrote:

> On Tue, 2 Aug 2005, David E. Jones wrote:
>
>
>>
>> It should still work. If not made explicit it defaults to treating it
>> as a field name for the first argument.
>>
>
> That's the definition of deprecated.
>
> _______________________________________________
> Dev mailing list
> [hidden email]
> http://lists.ofbiz.org/mailman/listinfo/dev
>

 
_______________________________________________
Dev mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/dev