jQuery Grid Plugin - jqGrid - Topic: Filter/Search

marcelocr2 on Filter/Search

Thu, 31 May 2012 00:23:43 +0300

Ji, I made some changes and I can search now using the navigation bar, but I want to make the search usig the filtertoolbar too.

$("#list").jqGrid('filterToolbar',{stringResult: true, searchOnEnter : false, defaultSearch: 'cn'});$("#list").jqGrid('navGrid','#pager',{edit:false,add:false,del:false});

Every time I use the filtertoolbar it doesn send any parameters to the server so the query looks like this:

SELECT id, nombre, descripcion FROM desc_examenes WHERE '' ORDER BY nombre asc

I dont know why I am not capturing the parameters with the toolbar

Thank You

marcelocr2 on Filter/Search

Tue, 29 May 2012 22:53:56 +0300

Hi, I am new to jqgrid and I wanty to filter/search data, but I dont know how to change de php file, I am using this in HTML file

$("#srccontents").filterGrid("list",{ gridModel:true, gridNames:true, formtype:"vertical", enableSearch: false, enableClear: false, autosearch: true });

and the query in php file is:

$SQL = "SELECT id, nombre, descripcion FROM desc_examenes ORDER BY $sidx $sord LIMIT $start , $limit";

I suppose i should include the where clause, but I dont know how to get the value the user wnats to search

Thank you