Vygandas asked 10 years ago
Hello,
Can somebody explain why I cannot get values with
$col = array();
$col["title"] = "Status";
$col["name"] = "statuso";
$col["width"] = "30";
$col["align"] = "left";
$str = $g->get_dropdown_values("select distinct eilnr as v FROM npaktai WHERE id = '{id}'");
$col["show"] = array("list"=>true,"edit"=>true,"add"=>false); // only show in listing
$col["default"] = $str;
$cols[] = $col;
BUT I GET VALUES WHEN I USE
$str = $g->get_dropdown_values("select distinct eilnr as v FROM npaktai WHERE id = '1'");
BR
Vygandas
Abu Ghufran answered 10 years ago
This is doable with onload settings. However you may need updated build for that.
$col["editoptions"]["onload"]["sql"] = "select note as k, note as v from invheader WHERE client_id = '{client_id}'";
Please email me from your payment email address for latest build.
