Dynamic portal

Classic Servoy
1

I’m currently using filemaker pro for many development and I just came across Servoy. Great job by the way I’m almost already convince to move all my solutions to this plateforme.

One of my need is to use a portal that’s build dynamically from a SQL request result. My database structure is already up and running with a web application developped in PHP, but I can see that it could be done in Servoy much more rapidly.

So Here is my question. Is it possible to display a portal that would contain different properties from one record to the next. So if the record currently displayed contains info on price, color and size, only these 3 columns would be available in the portal (or tab view if it works better). Then in the next record if I have info on price, length, depth, weigth and color, these 5 columns would be display using the same layout. Then many subproduct could be displayed using this portal.

Here are example of what it looks in our current software:


2

Easiest is to use html.

  1. create a global variable
  2. place a field on screen use the global as dataprovider
  3. set displaytype as html
  4. using databasemanager do the query
    5 use getashtml on the dataset to display as table, alternatively if you need more sophisticated markup use a loop to create your html table

If you are deploying smart client only you can also consider to use the tablebean.