Search

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

I'm not clear why that would affect it. Please can you update my example to demonstrate your situation, Colin