problem with get_dropdown_values

Questionsproblem with get_dropdown_values
Vygandas asked 6 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

1 Answers
Abu Ghufran answered 6 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.

Your Answer

7 + 16 =

Login with your Social Id:

OR, enter

Attach code here and paste link in question.
Attach screenshot here and paste link in question.



How useful was this discussion?

Click on a star to rate it!

Average rating 0 / 5. Vote count: 0

No votes so far! Be the first to rate it.

We are sorry that this post was not useful for you!

Let us improve this post!

Tell us how we can improve this post?