Suppose I design a skillset application. I define a SkillClass for master list of skills. I also define a PersonClass with a DBList property with query to list Skill items. It works and I could add a person with multiple skill items selected.
I would like to modify Person page display to show details from Person object followed by a table that lists his skills along with additional information from respective skill objects. This table has to list skill details only for those skills associated with the person.
How do I do this? I tried to pick the associated skills one-by-one from the property but could not do so with following logic.
#set($perskills=$person.getProperty("SkillList").getValue())
#foreach ($ps in $perskills)
SQL to retrieve skill object
Display information
#end
Any pointers on what is wrong or better ways of doing it?