Setting the DataSource Of jQuery DataTables As An Array

Question

I am attempting to set the source of my DataTable as an array, but I am getting this error:

Uncaught Error: DataTables warning: table id=my-table - Requested unknown parameter '0' for row 0, column 0

This is my syntax that I am wanting to use:

<script type="text/javascript">
var information = <?php echo json_encode($data) ?>;
alert(information.toString());
    $(document).ready(function () {
        $('#my-table').dataTable({
            data: information,
            columns: [
                { title: 'Employee' },
                { title: 'TotalSales' },
                { title: '30DaySales' },
                { title: '60DaySales' }
            ]
        });
    });
</script>

What alterations need to be made to the code so that the error is removed and the DataTable is displayed?

EDIT
And below is the output of console.log so you can see the format my array is in.

Console.log(JSON.stringify(information[0]))
[{"Employee":"Mitch McConell","Total Sales:"1,000.00","30DaySales:"750.00","60DaySales":"350.00"}]

It is same from what you asking here: stackoverflow.com/questions/57260055/… — mike85
– mike85, Commented Jul 30, 2019 at 0:28

JDB · Accepted Answer · 2019-07-29 20:24:17Z

1

I don't really know Data Table well, but it looks like you're mixing up the title and data properties.

I think you need to include the data property on your columns.

            columns: [
                { data: 'Employee' },
                { data: 'TotalSales' },
                { data: '30DaySales' },
                { data: '60DaySales' }
            ]

answered Jul 29, 2019 at 20:24

JDB

26.1k5 gold badges80 silver badges132 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Setting the DataSource Of jQuery DataTables As An Array

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related