DataTables OData connector
DataTables OData connector
There is a new add-on in the DataTables ecosystem - DataTables OData connector.
We had several discussions about the configuration of dataTable when OData service is used as a data source, and now we have solution. This add-on, or actually a function that should be set as fnServerData represents an adapter for DataTables/OData communication. It handles different versions of OData service (v2, v3, v4), translates dataTables filtering, pagination, and sorting actions to OData queries and updates the table content.
Current constraints relate to usage of text search for the columns that are declared as date/numeric on the server side. Other than that, dataTables functionality should be fully covered.
Add-on itself, as well as the examples, are available on GitHub: http://vpllan.github.io/jQuery.dataTables.oData/
Comments are welcome.
Jovan
We had several discussions about the configuration of dataTable when OData service is used as a data source, and now we have solution. This add-on, or actually a function that should be set as fnServerData represents an adapter for DataTables/OData communication. It handles different versions of OData service (v2, v3, v4), translates dataTables filtering, pagination, and sorting actions to OData queries and updates the table content.
Current constraints relate to usage of text search for the columns that are declared as date/numeric on the server side. Other than that, dataTables functionality should be fully covered.
Add-on itself, as well as the examples, are available on GitHub: http://vpllan.github.io/jQuery.dataTables.oData/
Comments are welcome.
Jovan
This discussion has been closed.
Replies
Fantastic - I'm sure people will find this very useful as OData questions do crop up now and then. Thanks for sharing this with us!
Regards,
Allan
Hi Jovan,
thanks for the plugin.
Is it possible to have external filter fields with this plugin?
Thanks!