Javascript dataTables Add variable into data columns

Question

I am using dataTables to populate my tables and I need to insert some static data into the table.

So I now have this:

jQuery('#mytable').DataTable( {
    data: dataSet,
    columns: [
        { "users": "id" },
        { "somethingelse": "valuehere" }
    ]
});

Is it possible to add a variable to valuehere? for example:

var dataSet = [['userid', 'something else'],['userid', 'something else']];
var myVariableHere = "some variable";

jQuery('#mytable').DataTable( {
  data: dataSet,
  columns: [
    { "users": "id" },
    { "somethingelse": myVariableHere }
  ]
});

<script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.0/jquery.min.js"></script>
<script src="https://cdn.datatables.net/1.10.12/js/jquery.dataTables.min.js"></script>
<link href="https://cdn.datatables.net/1.10.12/css/jquery.dataTables.min.css" rel="stylesheet"/>
<table id="mytable" class="display" width="100%"></table>

This should be possible if the myVariableHere has been formatted properly. — Anna Jeanine
– Anna Jeanine, Commented Nov 15, 2016 at 13:17
did you tried it ? as first look , it seems to work. And if the question is simply "Is it possible to add a variable to valuehere? ", then i think you are the best placed person to tell this — Incepter
– Incepter, Commented Nov 15, 2016 at 13:17
var myVariableHere = 'whatever' jQuery('#mytable').DataTable(function (myVariableHere) { ... } should be enough. — Anuga
– Anuga, Commented Nov 15, 2016 at 13:24

I wrestled a bear once. · Accepted Answer · 2016-11-15 13:26:24Z

1

Yes the variable isn't a problem, but your columns need to each have a "title" property.

var dataSet = [['userid', 'something else'],['userid', 'something else']];
var myVariableHere = "some variable";

jQuery('#mytable').DataTable( {
  data: dataSet,
  columns: [
    { title: "id" },
    { title: myVariableHere }
  ]
});

<script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.0/jquery.min.js"></script>
<script src="https://cdn.datatables.net/1.10.12/js/jquery.dataTables.min.js"></script>
<link href="https://cdn.datatables.net/1.10.12/css/jquery.dataTables.min.css" rel="stylesheet"/>
<table id="mytable" class="display" width="100%"></table>

answered Nov 15, 2016 at 13:26

I wrestled a bear once.

23.5k20 gold badges74 silver badges122 bronze badges

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

1 Comment

user7038798 Over a year ago

How do I do it if the data looks like this: { "data": "data.name", "title": "Names" } ?

Collectives™ on Stack Overflow

Javascript dataTables Add variable into data columns

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related