jQuery-Datatables Change ajax columns with html codes

Question

I'm, using ajax request to get data to make my datatables, but I need change de columns with html's tags and content.

My datatables resquest is:

var oTable1 = $('#sample-table-2').dataTable({
    "language": {
        "url": "/assets/js/Portuguese-Brasil.json"
    },
    "aoColumnDefs": [{
        "bSortable": true, "aTargets": [0, 1, 2],
        "bSortable": false, "aTargets": [1, 2]
    }],
    "ajax": {
        "url": "/Clientes/GetClientes/",
        "dataSrc": "",
        "dataType": "json",                   
    },
    "columns": [
        { "data": "Nome" },
        { "data": "<strong>StatusDesc</strong>" },
        { "data": "<span>StatusDesc</span>" },
    ],                               
});

But when this table is render, the html code inside columns doen't work.

Thank you!

davidkonrad · Accepted Answer · 2015-05-21 06:01:22Z

2

Use sTitle

{ "sTitle": "offer name<span style='display:none;'>offer_name</span>",  
  "data": "offer_name"
},

edited May 21, 2015 at 6:01

davidkonrad

85.7k17 gold badges211 silver badges273 bronze badges

answered May 20, 2015 at 20:18

sergiodebcn

3101 silver badge12 bronze badges

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

2 Comments

davidkonrad Over a year ago

Yes, but title can also be used -> datatables.net/reference/option/columns.title sTitle is the old hungarian notation naming style (but still works)

soamazing Over a year ago

@sergiodebcn is possible send array inside data, and pass two or more data for one sTitle?!

rst · Accepted Answer · 2015-05-20 20:21:43Z

0

I think you can't do that as you want it to do (at least, if I understood your "question" correctly). The datatables already have classes for each element, e.g. the column headers are usually called DataTables_sort_wrapper. So what comes to mind is, you could change the appearance of those column headers with css and/or jQuery. E.g. you can find the n'th column appearance by using the jQuery .eq() function

$(".DataTables_sort_wrapper").eq(n).css(...)

Hope this helps.

Cheers

answered May 20, 2015 at 20:21

rst

2,7644 gold badges24 silver badges57 bronze badges

Collectives™ on Stack Overflow

jQuery-Datatables Change ajax columns with html codes

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related