jQuery Grid Plugin - jqGridForum

Topic RSS

Related Topics sp_TopicIcon

To sort a custom column

Tags: sort column db

30/11/2011
23:21

bastien

france

Member

Members

Forum Posts: 4

Member Since:
29/11/2011

Offline

Hi everybody,

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

01/12/2011
11:25

bastien

france

Member

Members

Forum Posts: 4

Member Since:
29/11/2011

Offline

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

All RSS

Forum Timezone: Europe/Sofia

Most Users Ever Online: 715

Currently Online:
58 Guest(s)

Currently Browsing this Page:
1 Guest(s)