looking for some insite as we try to port from coldfusion cfgrid to jqgrid world.
currently a CF page has several input fields a button is pressed and a cfgrid gets loaded. then the user filters thru the grid on the local data. The filter fields are handled in real time.. So for example if you have 1000 rows and enter a “V” the dataset gets filtered then when you enter a second letter it becomes “Va” and more filtering is done, and so on. Enter is not pressed and no database query is done. all filtering can be done as a Like clause or a Contains clause as we see fit.
The examples I see here all seem to filter by issuing new database queries upon pressing enter. This is fine when the result sets are small or the queries are simple. Is there an example of the filtering being done on the local data once the grid has been loaded with a SQL query?