Start Building Professional
Web Apps Today


 
Categories Question details Back To List
Question  posted by LeitrimMan on Dec 10, 2009 05:06
open dhtmlx forum
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)");