Data Grid

[hrovira]

• sortable data grid or spreadsheet component
• optional filter controls or API
• common view for all apps

[hrovira]

Feel free to re-assign this issue as appropriate to @kleisb or @ryanbressler

[rbkreisberg]

The data grids we have tried so far:

Slickgrid: https://github.com/mleibman/SlickGrid Backgrid: http://backgridjs.com/

Slickgrid is good. It consumes data arrays and expects mutations on the data to be handled by exterior code (sorting, filtering, etc). There are some plugins. It creates all of its own markup, making it somewhat tricky to layout completely to design.

Backgrid is tricky. It consumes a Backbone collection and seems to work best when it has already been initialized with a reference to the collection before the 'fetch' is performed. This is a difficult guarantee to make in our app.

Grids worth evaluating:

dgrid: http://dojofoundation.org/packages/dgrid/ Pro: It is supported by a large community and has recent updates/fixes. Good set of functionality. Con: It requires a dojo DataStore or at least a wrapper around the data that provides the DataStore's API. The DataStore implementations look useful.

jqgrid: http://trirand.com/blog/jqgrid/jqgrid.html Pro: Integrates nicely with jQuery. Has many options and a lot of built-in functionality. Con: May be pretty heavy at this point. It is not clear how to style/theme the widget.

On Mon, Nov 18, 2013 at 12:25 PM, Hector Rovira notifications@github.comwrote:

Feel free to re-assign this issue as appropriate to @kleisbhttps://github.com/kleisbor @ryanbressler https://github.com/ryanbressler

— Reply to this email directly or view it on GitHubhttps://github.com/cancerregulome/WebAppBase/issues/3#issuecomment-28734467 .

[ryanbressler]

I've used yui datatable in the past and it is pretty full featured and has been around for a while (good and bad):

http://yuilibrary.com/yui/docs/datatable/

Dick found a cool filtering example:

http://www.yuiblog.com/blog/2011/03/01/filtering-yui3-datatable/

[hrovira]

Let's not change ui frameworks for this. We need to keep it simple. On Nov 20, 2013 10:55 AM, "Ryan Bressler" notifications@github.com wrote:

I've used yui datatable in the past and it is pretty full featured and has been around for a while (good and bad):

http://yuilibrary.com/yui/docs/datatable/

Dick found a cool filtering example:

http://www.yuiblog.com/blog/2011/03/01/filtering-yui3-datatable/

— Reply to this email directly or view it on GitHubhttps://github.com/cancerregulome/WebAppBase/issues/3#issuecomment-28917651 .

[ryanbressler]

Last time i used it, Yui was modular enough you could skin/package the grid and filter controls for use with whatever frameworks.

I'm not aware of simpler project that offers sorting, custom display and filtering out of the box though i'm sure some of the newer projects will get there eventually.

[hrovira]

Not sure what custom display is. Does it allow for pagination?

You can give it a whirl and see how it performs. I assume that wouldn't take long. On Nov 20, 2013 11:21 AM, "Ryan Bressler" notifications@github.com wrote:

Last time i used it, Yui was modular enough you could skin/package the grid and filter controls for use with whatever frameworks.

I'm not aware of simpler project that offers sorting, custom display and filtering out of the box though i'm sure some of the newer projects will get there eventually.

— Reply to this email directly or view it on GitHubhttps://github.com/cancerregulome/WebAppBase/issues/3#issuecomment-28920610 .

[ryanbressler]

You can specify your own rendering code for columns to make them ui components, replace booleans with check boxes or whatever you need.

Do we have some example use cases or data sets for this component?

[hrovira]

You can grab data from a web service call from RE. On Nov 20, 2013 11:58 AM, "Ryan Bressler" notifications@github.com wrote:

You can specify your own rendering code for columns to make them ui components, replace booleans with check boxes or whatever you need.

Do we have some example use cases or data sets for this component?

— Reply to this email directly or view it on GitHubhttps://github.com/cancerregulome/WebAppBase/issues/3#issuecomment-28924678 .