Posted: 08/12/2016, 4:20 AM |
|
Sure,
Dynamically Modify the SQL Statement
Add the Before Build Select event to the Grid :
assuming you have PHP :
function Tasks_DataSource_BeforeExecuteSelect(& $sender) {
global $Tasks; //your grid name
$Tasks->DataSource->SQL = "SELECT * FROM Tasks";
}
for dynamicaly change :
use link parameter like file.php?view=someview
than use it in before build select event:
function Tasks_DataSource_BeforeExecuteSelect(& $sender) {
global $Tasks; //your grid name
$view = CCGetFromGet('view')
if($view == 'someview'){
$Tasks->DataSource->SQL = "SELECT * FROM ViewTable1";
}elseif(($view == 'someview2')){
$Tasks->DataSource->SQL = "SELECT * FROM ViewTable2";
}
......
}
You can find this on help file under CodeCharge Studio Examples and Techniques
Happy coding! :)
|