Gustavo Lazaro asked 6 years ago
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
Abu Ghufran answered 6 years ago
Yes, you can use WHERE clause in this sql.
e.g.
$col["formatoptions"] = array( "sql"=>"SELECT *, name as v FROM clients WHERE gender='female' ORDER BY name desc",
"search_on"=>"concat(name,'-',client_id)",…………..);
Your Answer
