Hello. In the sql on formatoptions, can I use the where clause?
$col["formatter"] = "autocomplete"; // autocomplete
$col["formatoptions"] = array("sql"=>"SELECT codProfesional AS k, nombre AS v FROM gen_profesional ORDER BY nombre", "search_on"=>"matricula", "update_field"=>"codProfesional");
1 Answers
Your Answer