Datatables javascript sourced data without specifying column names

Question

I am trying to use an array of objects as an input to Datatables. Each object in the array I want to be a row in the table. Is there a way of inserting the data without specifying the column names?

var table = $('#data_table_test').DataTable( {
    "data": data,
    "columns": [
        { "data": "GENE_NAME" },
        { "data": "FDR"},
    ],
    dom: 'Bfrti',
    deferRender: true,
    scrollY: 420,
    scrollX: true,
    scroller: true,
    buttons: [
        'excel','csv'
    ],
    order: [],
} );

This works because I am specifying the column names, but I can't figure out a way to insert the data without using the column names.

do you have a fiddle?

codeandcloud
– codeandcloud

2016-08-12 15:23:49 +00:00
Commented Aug 12, 2016 at 15:23 — codeandcloud
– codeandcloud, Commented Aug 12, 2016 at 15:23
@naveen Yea here you go: jsfiddle.net/jag_123/x4nw6mac/5

Jeremy G
– Jeremy G

2016-08-12 15:47:04 +00:00
Commented Aug 12, 2016 at 15:47 — Jeremy G
– Jeremy G, Commented Aug 12, 2016 at 15:47

Adam · Accepted Answer · 2016-08-12 15:04:55Z

1

If the only issue is that you want to avoid naming the column, you could define the number of columns with just an empty definition

You could build the table definition in javascript based on your data and then pass it to the datatables initialization:

var tableDef = [ {}, {} ];

"columns": tableDef

I made a quick fiddle just to see if the idea works: https://jsfiddle.net/zyat1q2p/1/

edited Aug 12, 2016 at 15:04

answered Aug 12, 2016 at 14:59

Adam

2,6961 gold badge18 silver badges17 bronze badges

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

3 Comments

Jeremy G Over a year ago

Unfortunately, the number of columns won't be the same for every table

Adam Over a year ago

What if you built a javascript variable to become your columns definition?

Jeremy G Over a year ago

yea I think I might have to go that route.

Collectives™ on Stack Overflow

Datatables javascript sourced data without specifying column names

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related