Multiple grids on one form

Scriptcase 9 General
#1

Hello,

I am trying to get multiple grids on one form page, each one having a different SQL Select statement for their respective grid. Anyone ever done this or have any idea on how to do this? I know this could be done through a Dashboard but would rather not use the Dashboard application.

Any help would be appreciated.

Dr Tim

#2

You can create a different grids with different sql statement. Using master and details function of the Form application you can pull several grids as per its requirement. You can even pass the variable to make filter on your grid from form. for which you can use global variable on the grid sql and mpa the global variable from form application.

#3

If the queries are not related and you cannot create master-detail then you can always use a dashboard approach. Then each panel has it’s own grid.

#4

This will be from same table, so I do not think the Master-Detail will work unless there is a work around.

#5

All Select statements will come from same table just different queries, I do not think the Mater-Detail option would work.

#6

Is there a reason for not using the dashboard to display several grids? (just curious)

The only “work-around” would be to use the ‘application type = blank’ then using the ‘onExecute’ event, use jquery or bootstrap to format the page and include the ‘SC grids’.

here’s an example of the idea using the <iframe> tag

?>

<body>
<iframe src="…/index.php" height=“360px” width=“100%”></iframe>
<iframe src="…/index.php" height=“360px” width=“100%”></iframe>
</body>

<?PHP

hope this helps…

#7

Yes, I think this will work. I always try to look for a couple of ways. I really did not want to use the Dashboard method due to the size of the grid will always vary between the grids and and from minute to minute depending on actions being taken within the application. If you should come across something else just hit me up with a message.

Thanks,

Dr Tim