dhtmlxGrid with dhtmlxConnector

Suite 7.0/6.0/5.0 and Optimus Suite 5.0
#1

Hello,

I have a FULL dhtmlxGrid using a number of connector_select_filters. The database is expecting ‘1’ but i want to display a different text label in the drop down list “Yes”. The problem is it seems to be using the display text “Yes” instead of the “1” which means it fails when trying to do a sql lookup.

Any help on this would be great as its driving me mad. I have tried lots of different combinations as well as different code examples but no joy.

$options = array(
“1” => “Yes”,
“0” => “No”,
);

$grid->set_options(“positioned”,$options);

#2

Try to use code like next

[code]function custom_options(){
$index = $filter_by->index(“positioned”);
if ($index!==false) //there is client side input for the filter
if ($filter_by->rules[$index][“value”] == “Yes”)
$filter_by->rules[$index][“value”]=“1”;
else
$filter_by->rules[$index][“value”]=“0”;
}

$options = array( “Yes”, “No” );
$grid->event->attach(“beforeFilter”, “custom_options”);
$grid->set_options(“positioned”,$options);[/code]

docs.dhtmlx.com/doku.php?id=dhtm … :filtering