Categories | Question details Back To List | ||
OptionsConnector 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! Answer posted by Alex (support) on Dec 10, 2009 06:31 it is possible you can try to use render_sql method instead of render_table: http://dhtmlx.com/dhxdocs/doku.php?id=dhtmlxconnector:loading_editing_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)"); |