Table with remote loading/paging/sorting/filtering

[daan]

Is it possible to have a HTML-table and convert it to a grid and still have all the remote functionality? That includes paging, sorting and filtering the grid. I can't find any such demo, only the one about converting a table to a grid and then use local paging in it.

[paramvir]

It can be done but I don't see any point in this unless I'm missing something.

If you can send JSON data (filtered, sorted, etc ) from server why would you create HTML table in first place.

[daan]

I totally agree with you, but unfortunately it's a requirement we have. The page have to work without JS and then show a basic table instead. Because of that everything has to be built in an html-table and then if possible converted to a grid for those users that has javascript enabled.
Your example on how to convert a table to a grid is good, but the grid doesn't have remote paging, filtering and all the other nice features of a grid.
I think it will create a lot of extra work for us, but I just wanted to know if it's something you've encountered before.

[paramvir]

When HTML table is converted into a grid, table's content/data stored in cells is copied to an array of arrays. So the grid behaves like any other grid with all features but with array data.

In order to integrate it with remote sorting, filtering, paging etc you would need to map the array data to JSON data with $.map or by using 2 for loops.