Search

Muchisimas Gracias, ha funcionado bien. Habría alguna forma de hacerlo en esta tabla var tablinAlb = '<table id="tbl_LinAlb" class="display responsive no-wrap" style="width:100%" ><thead><tr HEIGHT="3"> <td BGCOLOR="#7c979e" ><font color="white">Producto:</font></td></td><td BGCOLOR="#7c979e" ><font color="white">Certificado:</font></td><td BGCOLOR="#7c979e" class = "text-right"><font color="white">Bultos:</font></td><td BGCOLOR="#7c979e" class = "text-right"><font color="white">Kilos:</font></td><td BGCOLOR="#7c979e" class = "text-right"><font color="white">Precio:</font></td><td BGCOLOR="#7c979e" class = "text-right"><font color="white">Importe:</font></td></tr>' + '</thead>' + '<tbody>'; $.each(objJson, function (i, item) { tablinAlb += '<tr style="cursor: pointer;"> <td >' + objJson[i].name + '</td><td>' + objJson[i].cert + '</td><td class = "text-right">' + objJson[i].cnt + '</td><td class = "text-right">' + objJson[i].pso_net_real + '</td> <td class = "text-right">' + objJson[i].pre + '</td> <td class = "text-right">' + objJson[i].imp + '</td></tr>'; }); tablinAlb += '</tbody><tfoot><tr HEIGHT="3"> <td BGCOLOR="#7c979e" class = "text-right"></td> <td BGCOLOR="#7c979e" ></td><td BGCOLOR="#7c979e" class = "text-right"></td> <td BGCOLOR="#7c979e" class = "text-right" ></td> <td BGCOLOR="#7c979e" class = "text-right"></td><td BGCOLOR="#7c979e" class = "text-right"></td></tr></tfoot></table>' ; En este caso sería el campo objJson[i].pso_net_real.

That does answer the main issues. Hopefully the blue + indicator vertical alignment issue is fixed as well.

See this blog post. The date-uk plug-in should work as well. If it isn't then please link to a test case showing the issue. Allan

Ok this was my resolution for the problem: create a view in mysql for "localidad" (eg: view_localidad), so the SQL server-side part change to: LEFT JOIN view_localidad GO ON A.mxv_loc_ori_fk = GO.vloc_id LEFT JOIN localidad GD ON A.mxv_loc_dest_fk = GD.loc_id At the moment, works great!

Hi CrazyRaccoon, I don't think that's possible, but there may be a workaround. You could listen for the search event kicking off, and then inside that callback, you could reset the ordering with the order.neutral() plugin. That sounds like what you're looking for. Hope that helps, Cheers, Colin

@allan, I remember that topic on GitHub, the October 2017 reaction was typed by my hands ;)

Hi, This thread here may give some clues, another user had problems and it turned out to be a combination of a badly defined format, and multiple formats within the same column. It would be worth checking that with your data. If that is all fine, it would be worth doing a live example here, so we can see the problems with the formatting. Cheers, Colin

Oh man... Thanks! :) This solves my problem!

This was a tough one, at least for me :smile: I was able to workout one of of doing this. However someone with more Javascript experience may be able to provide a better option. Here is the example: http://live.datatables.net/nehozara/1/edit What I found is that with columns.render there is no access to the HTML table's cells so getting the selected option is not possible. To workaround this I updated the cell's HTML by moving the selected="selected" attribute to the selected option. Then I update the Datatables cell with the updated HTML and force a table redraw via cell().invalidate(). During columns.render Datatables has the updated HTML in the data parameter and jQuery can get the selected option from this. Hope this helps you get started. Kevin

I'm using the Datatable for the Serverside and I have two different scenarios I'm working on. These two Scenarios can be switched 1: Page Layout: When I am viewing on page basis, I can switch to the View All Records basis. The Page Layout is working fine as required. 2: View All Records: When I am viewing all records, I can switch to Paginate option to view records on page basis. When I switch from the page layout basis to view all records, this is when I'm getting the problem, cause I'm using the pagelength -1 to view all the records. So, what is the best way to work on this scenario? Are there any other ways that I can work on the pipeline and to view on All the records basis or on page layout basis?