jQuery Datatables is returning html

Question

I'm using jQuery DataTables for one project. I applied datatable to an existing table, as shown below:

var table = '#datatable-1';
var dataTable = $(table).DataTable({
    'paging'      : true,
    'lengthChange': true,
    'searching'   : true,
    'ordering'    : true,
    'info'        : true,
    'autoWidth'   : false,
    select: {
        style: 'multi'
    }
});

Then I iterate over each row of the table, try to get the row content, but I obtained some HTML inside.

dataTable.rows({
    order: 'applied',
    page: 'all',
    search: 'applied',
    selected: true
}).every(function (rowIdx, tableLoop, rowLoop) {
    console.log(this.data());
});

And this is the result after I do a console.log(this.data()).

Array [ "A &amp; B", "143 AVE", "", "AMAZON", "EU", "", "<textarea name="" rows="1"></textar…" ]

Anyone knows how to get the row content like is shown in the table?

davidkonrad · Accepted Answer · 2017-10-10 16:57:55Z

1

You can iterate over dummy elements to translate html entities by text() or extract form input values by val() (as I believe you want as well) :

table.rows().every(function() {
  var data = this.data();
  data.forEach(function(d, index, arr) {
    d = $('<div>').html(d);
    arr[index] = d.val() || d.text()
  })
  console.log(data)
})

demo -> http://jsfiddle.net/ocL7xhzg/

In your case the array would be logged out as

Array [ "A & B", "143 AVE", "", "AMAZON", "EU", "", "" ]

answered Oct 10, 2017 at 16:57

davidkonrad

85.7k17 gold badges211 silver badges273 bronze badges

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

3 Comments

gvd Over a year ago

Fix the issue parcial, if you change the text of textarea the new value is not recognize and not show.

davidkonrad Over a year ago

@omixam, ??, this is how DataTables works. has nothing to do with your question. If you want DataTables internal cache to be updated with changes in form input see this answer -> stackoverflow.com/a/27860934/1407478 it is easy to overcome -> jsfiddle.net/ocL7xhzg/1

gvd Over a year ago

you have reason, this is like datatables works. Thanks for the bonus.

yılmaz · Accepted Answer · 2017-10-10 16:41:11Z

0

You have an Array. You can get first record (A & B) with this.data()[0]. Increase array index for next values.

answered Oct 10, 2017 at 16:41

yılmaz

1,83615 silver badges15 bronze badges

1 Comment

gvd Over a year ago

How you can see above, if I do that I will obtain "A & B" and not "A & B" that is the current value for this position. Also, there is textarea tag shows in the response.

Collectives™ on Stack Overflow

jQuery Datatables is returning html

2 Answers 2

3 Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related