I was having a go at ExecuteSQL() function and its very handy. But I'm not sure how i can display data in table or in portal like view.
I have a dashboard where I wan to display latest data for example, I would like to see last 10 newest customers, last 10 notes added, last 10 timesheet.
My dashboard is obviously is assigned to show customers table.
In relationship I have customers table linked to all other tables.
My question is if i have portal; the portal will display related records of that customers only. So how can I use execute SQL script to display data in table.
My second comes from this. I was looking at something called Virtual list. Can anyone explain what is that and how that can be used to display results in table or portal like way.