Passing an array with objects in to a datatable

Question

I have an array with objects like this:

console.log(data);

Shows this in the console:

(40) […]
0: Object { id: 368802, start: "52990", start_id: "ABC", … }
1: Object { id: 329340, start: "52991", start_id: "DEF", … }
2: Object { id: 337521, start: "52992", start_id: "GHI", … }
...

How can I pass it into datatables? This doesn't seem to work

table_direct = $('#table_direct').DataTable({
    dom: 'Bflrtip',
    ajax: data,
    columns: [
        { "data": "start" },
        { "data": "start_id" }
    ]
});

Use data, not ajax, as you're providing an array of content. — Rory McCrossan
– Rory McCrossan, Commented Feb 27, 2019 at 14:00

Enzo B. · Accepted Answer · 2019-02-27 13:59:50Z

Have you tried to do used data (https://datatables.net/manual/data/) instead ajax ?

table_direct = $('#table_direct').DataTable({
    dom: 'Bflrtip',
    data: data,
    columns: [
        { "data": "start" },
        { "data": "start_id" }
    ]
});

As what we can read into the official documentation :

[
    {
        "name":       "Tiger Nixon",
        "position":   "System Architect",
        "salary":     "$3,120",
        "start_date": "2011/04/25",
        "office":     "Edinburgh",
        "extn":       "5421"
    },
    {
        "name":       "Garrett Winters",
        "position":   "Director",
        "salary":     "$5,300",
        "start_date": "2011/07/25",
        "office":     "Edinburgh",
        "extn":       "8422"
    }
]

$('#example').DataTable( {
    data: data,
    columns: [
        { data: 'name' },
        { data: 'position' },
        { data: 'salary' },
        { data: 'office' }
    ]
} );

Scott Johnston · Accepted Answer · 2020-07-03 19:07:00Z

0

This is so wrong...I like how you copied the documentation, but there's an obvious bug in the column definitions.

How it the key for each column object the "data" object.

answered Jul 3, 2020 at 19:07

Scott Johnston

831 silver badge3 bronze badges

Collectives™ on Stack Overflow

Passing an array with objects in to a datatable

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related