Redesenhar datatables depois de usar ajax para atualizar o conteúdo da tabela?

joao_oliveira

Como posso redesenhar datatables depois de usar ajax para atualizar o conteúdo da tabela?

allan

How are you updating the table via Ajax at the moment? As noted in the forum rules, please link to a test case.

Also this is a predominantly English forum - you are far more likely to get help if you pose your questions in English, even if you just run them through Google translate.

Allan

joao_oliveira

Ok Allan...

$(document).ready(function() {
var oTable = $('#tbleitos').dataTable( {
"bPaginate": false,
"bLengthChange": false,
"bFilter": false,
//CLASSIFICAÇÃO DE COLUNAS
"bSort": false,
"bInfo": false,
//LARGURA INTELIGENTE DA COLUNA
"bAutoWidth": false,
"aoColumns" : [ {
"sWidth": "10px"},
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null],

"bProcessing": false,
"bServerSide": true,
//ATUALIZAÇÃO EM REAL-TIME
"sAjaxSource": "consulta_cirurgias.php?sEcho=1" } );

setInterval(function()
{
//oTable.fnReloadAjax("consulta_teste.php?sEcho=1");
oTable.fnDraw();
//$('table.dataTable td').css('font-size', 70);
},120000);

} );

allan

I think using the fnReloadAjax plug-in is what you want to do. Why is it commented out?

Allan

joao_oliveira

Comentei porque estou em dúvida. Preciso carregar dados de uma tabela e depois de outra, com intervalo de tempo. É como se o botão para a próxima página funcionasse automatica, sem a necessidade de clicar em cima.

joao_oliveira

I commented because I'm in doubt. I need to load data from a table and then another, with time interval. It's as if the button for the next page to work automatically, without the need to click on.

allan

> ?sEcho=1

That is wrong.

Also, thinking about it, just use fnDraw since you have server-side processing enabled.

Allan

joao_oliveira

Allan,

I want to display two different tables each minute. Can I use FnDraw?

allan

That sounds a lot like your other post - can we please just have one thread on that topic, otherwise I'll get confused and we'll waste everyone's time.

What was wrong with the method of showing two different tables?

joao_oliveira

ok...

joao_oliveira

I am not able to display two different tables. I need it to display a data table and after two minutes appears another table and stay in the loop. I need to be more specific. Show me how to develop my code.

joao_oliveira

ok?