Hi, this code doesn’t work for me. The filter doesn’t work for the first element.
I think the problem isn’t on code, I think is a configuration database or regional configurational server because if i use search debug the condition for first element is not correct (a “-” sign appears in front of the identifier value).
Example: “AND ( `cliente`.`id_estado` = ‘-1’ )” when the correct form would be “AND ( `cliente`.`id_estado` = ‘1’ ) “
For the rest of elements filter works correctly. ¿Anyone know what might be happening?
$col = array(); $col["title"] = "Estado"; // caption of column, can use HTML tags too $col["name"] = "id_estado"; // grid column name, same as db field or alias from sql $col["dbname"] = "subasta_boe.id_estado_subasta"; $col["width"] = "50"; // width on grid $col["editable"] = true; $str = $g->get_dropdown_values("select distinct id_estado_ as k, descripcion as v from estado order by id_estado"); $col["edittype"] = "select"; $col["editoptions"] = array("value"=>":;".$str); $col["stype"] = "select"; $col["searchoptions"] = array("value" => $str, "separator" => ":", "delimiter" => ";"); $col["searchoptions"]["sopt"] = array("eq"); $cols[] = $col;
Hello,
The code seems fine. You can check browser – console – network tab for the ajax call that is sent when you do search and inspect the posted data to server if it contains the hyphen as well.
It may need debugging and can’t help beside providing some hints.
You can email me directly and tell me your working time and timezone so we can have a remote session.
Hello.
I have the same issue.
How did you solve it?
Please email me your code and screencast showing the issue.
You can contact on [email protected]