Is it possible to refine the filter options in a OptionsConnector contruct, e.g. using your example
$filter1 = new OptionsConnector($res);
$filter1->render_table(“countries”,“country_id”,“country_name(value)”);
$grid->set_options(“item_nm”,$filter1);
$grid->render_table(“grid50”,“item_id”,“item_nm,item_cd”);
I have something similiar, but I want to filter the results of the lookup table first, e.g. in the example above say you wanted to show the countries from the table where country_name was like %a%, i.e. all countries beginning with ‘a’
thanks!
it is possible you can try to use render_sql method instead of render_table: dhtmlx.com/dhxdocs/doku.php?id=d … iting_data
for example
$filter1->render_sql(“select * from countries where country_name like ‘%a%’ “,“country_id”,“country_name(value)”,””,"");
instead of
$filter1->render_table(“countries”,“country_id”,“country_name(value)”);