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 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 >
Re: Entity engine compare columns
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" 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 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 >
Re: Entity engine compare columns
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 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" > 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 > 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
Re: Entity engine compare columns
In entitymodel.xml partyId will be defined as: & In java service you can get & compare using: String partyId = getPartyId(context); if (UtilValidate.isEmpty(partyId)) { //your code...} -- Thanks & Regards, Pankaj Savita Mob: +91 9890262476 Mail to: pankajsav...@gmail.com On Mon, Oct 11, 2010 at 6:47 PM, varun bhansaly wrote: > 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 >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" > > 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 > > 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 >
Re: Entity engine compare columns
The condtion should be something like this: (EntityFieldValue.makeFieldValue("userLoginId"), EntityOperator.EQUALS, partyId) Bilgin On Mon, Oct 11, 2010 at 12:10 PM, varun bhansaly 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 >
Re: Entity engine compare columns
This is what works - EntityCondition.makeCondition("oldValueText", EntityOperator.NOT_EQUAL, EntityFieldValue.makeFieldValue("newValueText")); and the generated query is - SELECT AUDIT_HISTORY_SEQ_ID, CHANGED_ENTITY_NAME, CHANGED_FIELD_NAME, PK_COMBINED_VALUE_TEXT, OLD_VALUE_TEXT, NEW_VALUE_TEXT, CHANGED_DATE, CHANGED_BY_INFO, CHANGED_SESSION_INFO, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM ENTITY_AUDIT_LOG WHERE (OLD_VALUE_TEXT <> NEW_VALUE_TEXT) ORDER BY CHANGED_DATE DESC Thanks All. On Mon, Oct 11, 2010 at 7:29 PM, Bilgin Ibryam wrote: > The condtion should be something like this: > > (EntityFieldValue.makeFieldValue("userLoginId"), EntityOperator.EQUALS, > partyId) > > > Bilgin > > On Mon, Oct 11, 2010 at 12:10 PM, varun bhansaly >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