I have the following set for a select filter but the first option doesn’t bring back any results. I have other filter dropdowns set the same way and none of them work with the first option.
//TYPE
$col = array();
$col[“title”] = “Type”; // caption of column, can use HTML tags too
$col[“name”] = “type”; // grid column name, same as db field or alias from sql
$col[“editable”] = true;
array(“list”=>true, “add”=>true, “edit”=>true, “view”=>true, “bulkedit”=>false);
$col[“edittype”] = “select”;
$col[“editoptions”] = array(“value”=>’Bus:Bus;Small Bus:Small Bus;Van:Van’);
$col[“stype”] = “select”;
$col[“searchoptions”] = array(“value”=>’Bus:Bus;Small Bus:Small Bus;Van:Van’, “separator” => “:”, “delimiter” => “;”);
$cols[] = $col;
It seems that if I add a blank selection at the beginning that works. Not sure if this is the answer but here is the search options that worked for me:
$col[“searchoptions”] = array(“value”=>’:;Bus:Bus;Small Bus:Small Bus;Van:Van’, “separator” => “:”, “delimiter” => “;”);
Yes, that’s necessary in search options to allow no-selection while filtering.
PS: Please let me know about the export issue in email / chat / ticket.