AppGini Community Forums

I am new to Appgini, love it so far. I need some guidance as to how to either modify or add a WHERE clause to a tables sql statement. So any help with this would be greatly appreciated.

Thanks,
TD

I found this, $options->QueryWhere = 'WHERE ... and this seems to be the answer.

My final code is:
$options->QueryWhere = 'WHERE `inspections`.`dept_id` = '.$dept_id;

TD