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