I never used the delegator in this purpose. I think it's not possible
and need extend EntityCondition to support this.
Nicolas
ian tabangay a écrit :
That's not really very efficient especially if youre trying to find a few
items from a hundred thousand. Putting it in a list would easily give you an
OutOfMemoryException. I have a workaround for this but its done using
SQLProcessor which could be problematic later on. Any other suggestions?
On Thu, Nov 20, 2008 at 6:15 PM, Bilgin Ibryam <[EMAIL PROTECTED]> wrote:
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
--
Nicolas MALIN
Consultant
Tél : 06.17.66.40.06
Site projet : http://www.neogia.org/
-------
Société LibrenBerry
Tél : 02.48.02.56.12
Site : http://www.librenberry.net/