Daily Archives: May 1, 2017

Converting jqGrid filtering and sorting options to MySQL statements using Perl. And processing them.

Here I will describe a pattern that I used for a couple of years to pass filtering and sorting options from jqGrid to MySQL server.
JqGrig that is used here is simple. What I actually want to share is my two Perl subroutines – get_searchstring() and _get_filterops that allows to translate almost any filtering request from jqGrid to MySQL.
I can’t guarantee anything, you know, but these subroutines worked well for several years and didn’t manifest any glitches.