Replace jqGrid: Difference between revisions

Revision as of 17:29, 9 March 2016

We want to replace jQgrid with another similar jQuery library.

Why?

Hard to exactly control and style the HTML, e.g. wrap something with a span tag
Not maintained since the license changed
...more?

Wanted features

Sort by column
Inline edit or pop-up edit
Fetch using Ajax
Filter?
Pagination
GPL or MIT license

Suggestions

handsontable, https://handsontable.com/
- Antifeature : Filter data + Header tooltips + Fixing bottom rows are unfree
datatables, https://www.datatables.net/
- Antifeature :
  - inline edit are not free
- Features
  - Sort by column : https://www.datatables.net/examples/basic_init/multi_col_sort.html
  - Fetch using Ajax : https://www.datatables.net/examples/ajax/
  - Filter : https://datatables.net/plug-ins/filtering/ (have done a filter on each column like 2.06 response some year ago, see an example here : http://www.codeproject.com/Articles/331855/jQuery-DataTables-Advanced-Filtering-in-ASP-NET-MV)
  - Pagination : included

Other notes

CPDB

CPDB uses jQgrid to open up - within the table - possibilities to edit attributes and surveys for one participant. This should probably be a dialog instead.

Dialog or inline

Actual edit in token don't update link. And we have issue with some control. A dialog edit fix this 2 issue more easily.

@@ Line 26: / Line 26: @@
 *** Sort by column : https://www.datatables.net/examples/basic_init/multi_col_sort.html
 *** Fetch using Ajax : https://www.datatables.net/examples/ajax/
-*** Filter : https://datatables.net/plug-ins/filtering/ (have done a filter on each column like 2.06 response some year ago)
+*** Filter : https://datatables.net/plug-ins/filtering/ (have done a filter on each column like 2.06 response some year ago, see an example here : http://www.codeproject.com/Articles/331855/jQuery-DataTables-Advanced-Filtering-in-ASP-NET-MV)
 *** Pagination : included