One way could be
values = delegator.findList("EntityName", null, null, null, null, true);
List field1Values = EntityUtil.getFieldListFromEntityList(values,
"field1", true);
finalValues = delegator.findList("EntityName",
EntityCondition.makeCondition("field2", EntityOperator.IN,
field1Values), null, null, null, true);
Bilgin
On Nov 20, 2008, at 5:01 AM, ian tabangay wrote:
i am familiar with findList and how to use EntityConditionList and
EntityExpr. But i am only familiar with comparing a column with a
given
value (like new EntityExpr("columnName", EntityOperator.EQUALS,
value). What
i wanted to do is to compare 2 columns of an entity. For example, if
it were
written as an SQL, it would be something like "SELECT column_a,
column_b
FROM table WHERE column_a = column_b"
On Wed, Nov 19, 2008 at 9:17 PM, BJ Freeman <[EMAIL PROTECTED]>
wrote:
do a search in code for findList
