Hi,

I think I understand the problem. When there is a click to sort a column, a new search is launched. For this new search, the variable $sidx in my script file takes the value of the index of the column the user clicks to sort.

So, as my column doesn't exist in my DB (because it's calculated by myself), the SQL doesn't work.

It seems so that it's not possible to sort calculated datas which don't exist in the DB.

Is it the same when grid is in the new mode “grid view mode”, appeared in version 3.5 ?

I think yes… so what I want to do is just impossible with jqgrid ? Anybody had to treat a similar case ?

thanks for answers

Bastien