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

After loading the data by my sql request in my script.php file, I do some calculations in order to create some new columns with new data like increase, gap, ...

After I did my calculations, I write the xml data and I add a line to add the new cells for my new columns.

When I load the grid, everything is ok. My new data are in the grid.

If I sort the data loaded from the database, it's ok. But when I try to sort a colum with my new data, calculated and not loaded from DB, it doesn't work and the grid becomes empty.

I can retrieve the grid with data if I click on the title of a column which has data loaded from the DB.

Any idea ?

thanks 🙂

Bastien