ofbiz entity query problem?

[Hans Bakker]

if i write the groovy statement:

orExprs = [];
orExprs.add(EntityCondition.makeCondition("workEffortId",
EntityOperator.NOT_EQUAL, null));

i get the error message:

java.lang.IllegalArgumentException: Operator must be EQUALS or NOT_EQUAL
when right/rhs argument is NULL )

if i change the operator to EQUALS it seems to work fine.

anybody can confirm?

--

Regards,

Hans Bakker
CEO, http://antwebsystems.com

[Hans Bakker]

Sorry it is a bit more complicated:

andExprs = [];
andExprs.add(EntityCondition.makeCondition("marketingCampaignId",
EntityOperator.EQUALS, parameters.marketingCampaignId));
andExprs.add(EntityCondition.makeCondition("actionIsActive",
EntityOperator.NOT_EQUAL, "N"));

orExprs = [];
orExprs.add(EntityCondition.makeCondition(andExprs, EntityOperator.AND));
orExprs.add(EntityCondition.makeCondition("workEffortId",
EntityOperator.EQUALS, null));


i tried to simplify it but too much.

these condictions are on a custom view i created here.

the message is still:
  java.lang.IllegalArgumentException: Operator must be EQUALS or
NOT_EQUAL when right/rhs argument is NULL )


Regards,
Hans



On 01/09/16 13:05, Hans Bakker wrote:

> if i write the groovy statement:
>
> orExprs = [];
> orExprs.add(EntityCondition.makeCondition("workEffortId",
> EntityOperator.NOT_EQUAL, null));
>
> i get the error message:
>
> java.lang.IllegalArgumentException: Operator must be EQUALS or NOT_EQUAL
> when right/rhs argument is NULL )
>
> if i change the operator to EQUALS it seems to work fine.
>
> anybody can confirm?
>

--

Regards,

Hans Bakker
CEO, http://antwebsystems.com

[Hans Bakker]

looks like it is caused by the underlying view....forget it for now.....

On 01/09/16 13:18, Hans Bakker wrote:

> Sorry it is a bit more complicated:
>
> andExprs = [];
> andExprs.add(EntityCondition.makeCondition("marketingCampaignId",
> EntityOperator.EQUALS, parameters.marketingCampaignId));
> andExprs.add(EntityCondition.makeCondition("actionIsActive",
> EntityOperator.NOT_EQUAL, "N"));
>
> orExprs = [];
> orExprs.add(EntityCondition.makeCondition(andExprs, EntityOperator.AND));
> orExprs.add(EntityCondition.makeCondition("workEffortId",
> EntityOperator.EQUALS, null));
>
>
> i tried to simplify it but too much.
>
> these condictions are on a custom view i created here.
>
> the message is still:
>  java.lang.IllegalArgumentException: Operator must be EQUALS or
> NOT_EQUAL when right/rhs argument is NULL )
>
>
> Regards,
> Hans
>
>
>
> On 01/09/16 13:05, Hans Bakker wrote:
>> if i write the groovy statement:
>>
>> orExprs = [];
>> orExprs.add(EntityCondition.makeCondition("workEffortId",
>> EntityOperator.NOT_EQUAL, null));
>>
>> i get the error message:
>>
>> java.lang.IllegalArgumentException: Operator must be EQUALS or NOT_EQUAL
>> when right/rhs argument is NULL )
>>
>> if i change the operator to EQUALS it seems to work fine.
>>
>> anybody can confirm?
>>
>

--

Regards,

Hans Bakker
CEO, http://antwebsystems.com