Thanks, but I wish to compare two columns.
BTW, if I write this in java service, what should be the type for partyId ?

On Mon, Oct 11, 2010 at 6:43 PM, Chirag Manocha <cmano...@emforium.com>wrote:

> Hi Varun,
> Following will work for you :-
> EntityCondition.makeCondition("USER_LOGIN_ID",
> EntityJoinOperator.NOT_EQUAL, partyId)
>
> Regards
> --
> Chirag Manocha
> Emforium Software Pvt. Ltd. | ALL-IN Software
> +91-98735-47457 | +91-98263-19099
> Please don't print this Email unless you really need to - this will
> preserve trees on planet earth.
>
>
>
>
> From: "pankaj savita" <pankajsav...@gmail.com>
> To: user@ofbiz.apache.org
> Sent: Monday, October 11, 2010 6:12:44 PM
> Subject: Re: Entity engine compare columns
>
> Hi Varun,
>
> You can make EntityCondition using:
>
> EntityCondition.makeCondition("USER_LOGIN_ID",
> EntityOperator.GREATER_THAN_EQUAL_TO, PARTY_ID)
>
> or
>
> EntityCondition.makeCondition("USER_LOGIN_ID",
> EntityOperator.LESS_THAN_EQUAL_TO, PARTY_ID)
>
>
> --
> Thanks & Regards,
> Pankaj Savita
> Mob: +91 9890262476
> Mail to: pankajsav...@gmail.com
>
>
> On Mon, Oct 11, 2010 at 4:40 PM, varun bhansaly <vbhans...@gmail.com>
> wrote:
>
> > Hi,
> > Is it possible to compare two columns using the entity engine,
> > For eg, write a query like this -
> > SELECT * FROM USER_LOGIN WHERE USER_LOGIN_ID <> PARTY_ID
> >
> > --
> > Regards,
> > Varun Bhansaly
> >
>
>


-- 
Regards,
Varun Bhansaly

Reply via email to