Hi,

I have the following tables/entities: <Bezoek> <Stage> - FK to 'Bezoek.id', FK to 'Locatie.Id' <StudentStage> lookup table <Student> - FK to 'BE.Id' <BE> <Locatie> <School> - FK to 'Locatie.Id' <BestuurSchool> lookup table <Bestuur>

I want to get information from all these entities, which are related. Is there a way to do this without having the performance get out of hand? Should i construct a view or do this in llblgen code by the entityrelations functionality? Any suggestions are welcome.

Kind regards, Karim

Karim wrote:

Hi,

I have the following tables/entities: <Bezoek> <Stage> - FK to 'Bezoek.id', FK to 'Locatie.Id' <StudentStage> lookup table <Student> - FK to 'BE.Id' <BE> <Locatie> <School> - FK to 'Locatie.Id' <BestuurSchool> lookup table <Bestuur>

I want to get information from all these entities, which are related. Is there a way to do this without having the performance get out of hand? Should i construct a view or do this in llblgen code by the entityrelations functionality? Any suggestions are welcome.

Kind regards, Karim

When i say 'all information' i mean a specific subset of information. 'Stage' is the starting point. I have a Stage.Groep on which i filter out all the stages. From there i want to get the related information for each stage and display this in a grid: For instance the following info: BE.Name All of Bezoek School.Name Locatie that belongs to the School

Kind regards, Karim

if you want obtain the whole graph you can use a prefetch path (see help for details) or if you to obtain a view-like dataset containing the information from all those tables creating a typedlist from the designer is very straightforward.