Hi Abu!

I have master-detail grid, inside the detail grid I need to get a value from the database, I put the following code inside the code that generate the detail grid.

/**********Detail Grid*************/
$grid = new jqgrid();

$id = intval($_GET["rowid"]);
$idListas_Precios = Carga_Id(intval($_GET["idClientes"]));

$opt = array();
$opt["sortname"] = 'idProduccion_Detalle'; // by default sort grid by this field
$opt["sortorder"] = "asc"; // ASC or DESC

The problem is that when I call the Carga_Id function it seems to block the input search box in the dropdown with the select2 feature.

Below is the code for the dropdown.

$col = array();
$col["title"] = "Vidrio";
$col["name"] = "idVidrio";
//$col["dbname"] = "productos.idProductos"; // this is required as we need to search in name field, not id
$col["align"] = "left";
$col["width"] = 200;
$col["search"] = true;
$col["editable"] = true;
$col["formatter"] = "select";
$col["edittype"] = "select"; // render as select
# fetch data from database, with alias k for key, v for value
$str = $g->get_dropdown_values("select idProductos as k, descripcion as v from productos");
$col["editoptions"] = array(
"value"=>"null:;".$str,
"onchange" => array(
"sql"=>"SELECT precio FROM precios WHERE idListas_Precios = '".$idListas_Precios."'",
"search_on"=>"idProductos",
"callback" => "fill_vidrio" )
);
$col["editoptions"]["dataInit"] = "function(){ setTimeout(function(){ link_select2('idVidrio'); },200); }";
$cols[] = $col;

I need to get the price that corresponds to the id_client and the id_list that the client has.

Can you help me out? Everything works as expected but the problem is I can't search the product in the dropdown.