Search

I see you're using Editor, but our accounts aren't showing that you have a license - it just reports that your trial expired 2016. Is the license registered to another email address? Please can let us know so we can update our records and provide support. Thanks, Colin

No worries, glad all sorted! Colin

@kthorngren Thanks to sample json response

See if this thread helps. Kevin

Colin, thank you for your prompt reply. The transpose option should be exactly what I was looking for.

We're happy to take a look, but as per the forum rules, please link to a test case - a test case that replicates the issue will ensure you'll get a quick and accurate response. Information on how to create a test case (if you aren't able to link to the page you are working on) is available here. Cheers, Colin

sorry, we were off for Thanksgiving holiday. It looks like I am using version 2.0.4.0 I believe when I first posted I was using 1.9, but when I realized I wasn't using the newest I upgraded. But i am still getting the same sql statement in the debug.

Is this with Editor? Or filtering? There are a few threads on each, such as here and here, Colin

dear @hcmhmt did you find a solution ?, please your comments.

row().data() is both a getter and a setter. You need to pass the updated data as a parameter to row().data() to use it as a setter. Something like this: var tr = $(this).closest('tr'); var row = table.row(tr); var data = row.data(); data.favorito = ! data.favorito; row.data( data).draw(); // Update the row data Kevin