delegator.findList(...) Question

[Ruth Hoffman-2]

Hello Developers:
Can I do a self join on an Entity using the delegator.findList() method.?

Heres what I want to do:

Select * from entity where entity.field1 = entity.field2

TIA
Ruth

[Bilgin Ibryam-2]

Ruth Hoffman wrote:
> Hello Developers:
> Can I do a self join on an Entity using the delegator.findList() method.?
>
> Heres what I want to do:
>
> Select * from entity where entity.field1 = entity.field2
>
> TIA
> Ruth
You have to use EntityFieldValue. Look for examples in the code.

Bilgin

[Ruth Hoffman-2]

Will do.
Thanks for pointing me in the right direction.
Regards,
Ruth

Bilgin Ibryam wrote:

> Ruth Hoffman wrote:
>> Hello Developers:
>> Can I do a self join on an Entity using the delegator.findList()
>> method.?
>>
>> Heres what I want to do:
>>
>> Select * from entity where entity.field1 = entity.field2
>>
>> TIA
>> Ruth
> You have to use EntityFieldValue. Look for examples in the code.
>
> Bilgin
>