When loading data from an Ajax source, by default, DataTables will look for the data to use in the
data
parameter of a returned object (e.g. { "data": [...] }
). This can easily
be change by using the dataSrc
option of the ajaxDT
initiation option.
The ajax.dataSrcDT
has a number of ways in which
it can be used:
dataSrc: 'myData'
) - obtain data from a different property in
the source object.dataSrc: ''
) - the data source is not an object but an
array.dataSrc: function(json) {}
) - a function can be used to
transform the data from one source format to another (for example you could convert from XML to a
Javascript object). The value returned from the function is used as the data for the table.The example below shows ajax.dataSrcDT
being used as
an empty string. This tells DataTables that the JSON loaded is a plain array, not an object with an
array inside it as is the default.
Name | Position | Office | Extn. | Start date | Salary |
---|---|---|---|---|---|
Name | Position | Office | Extn. | Start date | Salary |
Loading... |
The Javascript shown below is used to initialise the table shown in this example:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 | $(document).ready(function() { $('#example').dataTable( { "ajax": { "url": "data/objects_root_array.txt", "dataSrc": "" }, "columns": [ { "data": "name" }, { "data": "position" }, { "data": "office" }, { "data": "extn" }, { "data": "start_date" }, { "data": "salary" } ] } ); } ); |
In addition to the above code, the following Javascript library files are loaded for use in this example: