Please refer this code:

https://gist.github.com/f32c22a0b1a045e8acea3aa7aa601db4

Line 51,86,99

Hello,

Thanks for your input.

This is working fine as long as no line (order_id in your case) is filtered.
How to get the same result when some records are ‘dynamically’ filtered ?

Thanks in advance for your additional input.

Jean-Luc

Hello again,

I managed to generate dynamically the SQL statement to be used in grid ‘sortname’.

What is the syntax in JS to set grid sortname before refreshing it ?

Best Regards,

Jean-Luc

Hi,

You can try following, this will sort list1 grid with country column descending after reload.

var grid = jQuery('#list1');
grid.jqGrid('setGridParam',{sortname: 'country', sortorder: 'desc'});
grid.trigger('reloadGrid',[{current:true}]);