Combo, Connector and Grid

Suite and Optimus Suite 5
#1

have a connector.php file that render the grid

$filter1 = new OptionsConnector($res);
$filter1->render_table(“countries”,“country_id”,“country_name(value)”);
$grid->set_options(“COUNTRY”,$filter1);
…
$grid->render_sql(“Select FIRST_NAME,f.tabl.GEND as GENDER, b.tabl.COUNTRY as COUNTRY,CITY, c.tabl.STRTYPE as TSTREET, d.tabl.NAME_STREET as STREET from a.tabl, b.tabl, c.tabl, d.tabl, f.tabl where a.tabl.COUNTRY_LIVE= e.tabl.ID_COUNTRY and a.tabl.NAME_OF_STREET= d.tabl.ID_STR and a.tabl.GENDER= f.tabl.ID_GENDER and a.tabl.TYPE_OF_STREET= c.tabl.ID_STRT”,"",“FIRST_NAME,GENDER,COUNTRY,CITY,TSTREET,STREET”);
…

and other values for alias tables

at grid.php

initialize grid…
and for header i use combobox with

then initialize DhtmlxCombobox with street.php

and all works, filtering on grid headers except one combobox ???

my question how with selected item in combobox sent request to connector.php,
i found getactualvalue() for combobox but cant imagine how to join in connector.php

#2

you may set onChange event handler for combo and reload grid. To the server-side script that generates grid xml you need to pass dhx_filter[column_index] parameter with the combo value:

combo.attachEvent(“onChange”,function(){
var value = this.getActualValue();
grid.clearAll();
grid.loadXML(“url”+"?dhx_filter[0]="+value); //0 is column index
})

#3

great work …

that script i totally needed for 4,000 record’s

thx :wink: