Hello!

I have a problem using BulkEdit with Dropdown.

When I click Bulkedit, my dropdown depandant write “Select…” inside the field.

And Bulk consider this DATA to update! CAn you help me?

PRINT

View post on imgur.com

CODE

$col = array();
$col[“name”] = “FK_CIDADE”;
$col[“title”] = “Cidade do Ato”;
$col[“dbname”] = “AUD.FK_CIDADE”;
$col[“width”] = “220”;
$col[“search”] = true;
$col[“editable”] = true;
$myfieldval .= ‘,’. $col[“name”];
$myfieldnam .= ‘,’. $col[“title”];
$col[“align”] = “left”;
$col[“edittype”] = “select”; // render as select
$str = $g->get_dropdown_values(“SELECT DISTINCT ID_CIDADE AS k, UFMUN AS v FROM CIDADE ORDER BY UFMUN”);
//$col[“editoptions”] = array(“value”=>”:;”.$str);
$col[“editrules”] = array(“required”=>true);
//$col[“formatter”] = “select”; // display label, not value
$col[“editoptions”] = array(
“value”=>”:;”.$str,
“onchange” => array( “update_field” => “FK_ADVCONTRATADO”,
“sql” => “select distinct ID_COLIGADOS as k, APELIDO as v from COLIGADOS WHERE CIDATEND IN({FK_CIDADE}) ”
)
);

// multi-select in search filter
$col[“stype”] = “select-multiple”;
$col[“searchoptions”][“value”] = $str;

$pattern = ‘/’.$col[“title”].’/’;
if (preg_match($pattern, $oc)) {
$col[“hidden”] = true;
$col[“hidedlg”] = true;
}
$cols[] = $col;

$col = array();
$col[“name”] = “FK_ADVCONTRATADO”;
$col[“title”] = “Adv. Contratado”;
$col[“dbname”] = “AUD.FK_ADVCONTRATADO”;
$col[“width”] = “220”;
$col[“editable”] = true;
$myfieldval .= ‘,’. $col[“name”];
$myfieldnam .= ‘,’. $col[“title”];
$col[“align”] = “left”;
$col[“edittype”] = “select”; // render as select
$str = $g->get_dropdown_values(“SELECT DISTINCT ID_COLIGADOS AS k, APELIDO AS v FROM COLIGADOS ORDER BY NOME_COM”);
$col[“editoptions”] = array(“value”=>”:;”.$str);
$col[“editrules”] = array(“required”=>false);
//$col[“formatter”] = “select”; // display label, not value

//multi-select in search filter
$col[“stype”] = “select-multiple”;
$col[“searchoptions”][“value”] = $str;

$pattern = ‘/’.$col[“title”].’/’;
if (preg_match($pattern, $oc)) {
$col[“hidden”] = true;
$col[“hidedlg”] = true;
}
$cols[] = $col;