Multi-key join condition in LLBLGen 2.6

Posts   
 
    
sparq
User
Posts: 61
Joined: 14-Mar-2010
# Posted on: 28-Jul-2017 00:14:02   

Hi there,

I've had a good search through the forums but can't find anything that covers this kind of join;

select *
from parent p
join child c on (c.from_parent_id = p.parent_id OR c.to_parent_id = p.parent_id)

I need to be able to specify the following expression somewhere;

ChildFields.FromParentId == ParentFields.ParentId | ChildFields.ToParentId == ParentFields.ParentId

In the relation/join.

Is such a relation possible in code?

daelmo avatar
daelmo
Support Team
Posts: 8245
Joined: 28-Nov-2005
# Posted on: 28-Jul-2017 09:45:19   

Yes, you can. Please see Custom filters for EntityRelations

David Elizondo | LLBLGen Support Team