[QUOTE=Henry;19602]Hi,
The following tutorial video shows how to pass a global variable to another application.
http://www.scriptcase.net/scriptcase-videos/basic-concepts/
However, it doesn’t explain how to pass multiple values such as checkboxes (global variable from a control app) to filter a grid.
SO my questions are:
a. how to pass a multi-dimensional global variable (from checkboxes) from a control app to a grid app?
b. how to get the checkbox values recognised by the MySQL ‘where clause’ in the grid?
Thanks.[/QUOTE]
AFAIK there’s not a real difference in passing variables as singular, array or multi-dimensional array. But to be honest I don’t know exactly how SC works with global variables internally. But if it is an issue you have always the opportunity to transform an array into a simple variable using implode. Then you pass the value to a global and in your other application you transform that variable back into an array using php explode method.
If you need to filter the sql you need to apply a where clause. This too can contain a global variable like: where [glob_where]
To set the glob_where global you must need an event like onscriptinit. In this event you can check the passed variables and create your where.
If things not seem to work you can go to the application section of your module and check the debug options. Your application will show every generated sql statement before execution and allows you to check your settings.