View on GitHub


OData jQuery dataTables

Download this project as a .zip file Download this project as a tar.gz file

jQuery DataTables OData connector

jQuery DataTables OData connector enables standard jQuery DataTables plugin to display data provided by OData service. Beside displaying, it allows you to filter, sort, and navigate through the data. There are several versions of OData services (v4, v3, and v2), which return results in different formats. This connector handles all of these versions (and you simply need to specify a version through "iODataVersion" parameter).




    "sAjaxSource": "",
    "iODataVersion": 4,
    "aoColumns": [
        { mData: "Name" },
        { mData: "Description" },
        { mData: "Rating", sType: 'numeric' },
        { mData: "Price", sType: 'numeric' },
        { sName: "ReleaseDate", sType: 'date' }
    "fnServerData": fnServerOData, // required
    "bServerSide": true,  // optional
    "bUseODataViaJSONP": true,  // set to true if using cross-domain requests

Note: For full example take a look at submitted html pages.

Functionality for connecting to OData service is placed in the fnServerOData function defined in jquery.datatables.odata.js. This function should be set as the value of "fnServerData" parameter.

If dataTables is used in server-side processing mode, date columns and numeric columns should be marked as such using "sType" parameter (because OData service cannot perform text search against these fields). Also, for cross-domain requests you need to set "bUseODataViaJSONP" parameter value to true.