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
>
