Is it possible to create a relation based on data?

If I have for example a project and a contract for that project And my project has a start date and an end date.

And I would like to get all the projects with a left join on contract when the join is based on:

left outer join CONTRACT ON PROJECT.PROJECT_NO = CONTRACT_PROJECT_NO AND CONTRACT.ACTIVE_FROM >= PROJECT.START_DATE AND CONTRACT.ACTIVE_UNTIL <= PROJECT.END_DATE

Since I can't do this in the designer, is it possible to do this in code?

I need to do this with a join, because when I use a where clause, i would get different results that I can't use in my application.

Yes, specify a predicate expression as CustomFilter, when you add the relation to the relationcollection. Please see Using the generated code / adapter(selfservicing) / filtering and sorting -> Custom filters for EntityRelations

Otis wrote:

Yes, specify a predicate expression as CustomFilter, when you add the relation to the relationcollection. Please see Using the generated code / adapter(selfservicing) / filtering and sorting -> Custom filters for EntityRelations

Is it possible specify a CustomFilter for TypedList's relation? Or should I generate a dynamic list instead and pass in the relations with a custom filter?

Thanks, -Ryan Casey

In selfservicing you have to inherit a class from the typedlist class and override BuildRelationSet and first call the base method, then set the particular relation's CustomFilter property (relationCollection[index].CustomFilter = ...) . In adapter you first call typedList.GetRelationInfo(), and the bucket you receive contains the relationcollection: bucket.Relations[index].CustomFilter = ... should do the trick