Home

Initialisation

Automatic initialization

1. Add the keyword 'O' in dataTables dom settings
2. Add OData settings to dataTbales initialisation settings
3. Add columns settings

// Settings
var dt_settings = 
{
	dom: "lCtipO",
	columns: [
		{ data: "Name", searchMethod: "contains" },
		{ data: "Age", type: "number" },
		{ data: "Dogs", type: "number" },
	],
	odata: {
		url: "/odata/service",
	},
	processing: true,
	serverSide: true,
	stateSave: true,
};

// DT initialisation
var dt = $("#table").DataTables(dt_settings);

// Get DataTablesOData instance
var dt_odata = dt.odata();

Manual initialization

Column search row may not displayed if used in this method.

// DT Settings
var dt_settings = 
{
	columns: [
		{ data: "Name", searchMethod: "contains" },
		{ data: "Age", type: "number" },
		{ data: "Dogs", type: "number" },
	],
	...
};

// DT initialisation
var dt = $("#table").DataTables(dt_settings);

// OData settings
var od_settings = 
{
	url: "/odata/service",
},

// OData initialisation
$.fn.DataTable.OData(dt, od_settings);

// To display column search inputs row
dt.odata().searchColumnAddInputs();