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 <[email protected]> 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 <[email protected] > >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
