Grid features

[atasc]

Hi,
does EXA-DATATABLES for Grails 3 support the following features?

-ajax async loading
-filter by column
-custom formatter by domain field/column
-action buttons (edit, delete, etc etc)
-multi column filtering
-multi column sorting
-custom column filter (combobox, datepicker etc etc)

[lguerin]

Hi,

actually, the version for Grails 3 supports everything you can find in the demo page: http://grails-exanpe.rhcloud.com/exaDatatablesDemo/index

Regarding your requested features:

• Ajax async loading : not yet
• Filter by column : not out of the box
• Custom formatter by domain field/column : yes
• Action buttons (edit, delete, etc etc) : yes, you have to add your own buttons, like in the demo
• Multi column filtering : no
• Multi column sorting : no
• Custom column filter (combobox, datepicker etc etc) : no

Notice that the plugin lets you access the full native API provided by Datatables.js before rendering the component, if you want. So you can use that to implement the requested features.

[sebDK]

Hi @lguerin,
Does your plugin support subgrid like

Thanks.

S.

[lguerin]

Hello @sebDK ,
We usually try to avoid to nest datatables like that, so I haven't try to get a such result with the component.

[daptordarattler]

Examples link doesn't work

[lguerin]

Redhat cloud has closed, so the demo app is going to be migrated to Openshift. A new link will be available in few days.

[lguerin]

Hello, the new demo link is: http://grails-exanpe-grails-exanpe.193b.starter-ca-central-1.openshiftapps.com/exaDatatablesDemo/index

[daptordarattler]

Link isn't working

[lguerin]

[daptordarattler]

Ok, its up now. Seems there was some startup delay.

[daptordarattler]

Lovely demo. Quick question tho, do you get the list via ajax anytime there is a search, or everything is rendered/loaded once the page is rendered? I ask because if the domain instances are many (1000+) it could have performance issues. How is this resolved?

Also have you tested with the export plugin?

Thanks

[lguerin]

Currently, everything is rendered client-side, ajax features are in the roadmap but has not been done yet. The use-case where I use this grid for my customers is to limit the number of results to 300 and ask user to set more search criterias in order to get more accurate (and less) results.
BTW, I haven't try Datatables.js export features, but according to the last example to the demo, you can switch the auto parameter to 'off', and try to add export button and implement export feature as exposed in Datatables.js demo page.

[daptordarattler]

Ah, i understand. btw I meant explort plugin for grails with the results, but since its all loaded, it shouldnt be a problem.

Thanks again.