Search

Hello, I want to post sort value with column name not column index. Is this possible on datatables?

hi, i have a requirement to show sorted data(first column) in table. I am able to disable the default sorting options in the table header but how can sort table data with first column. So my question - Is there any setting to sort the data in the table.

Hi All, I have use this code in my client web side, $('#example').dataTable({ "dom": 'lBfrtip', "serverSide": true, "ajax": "scripts/server_processing.php", buttons: [ { extend: 'excel', text: 'Save all page', exportOptions: { modifier: { page: 'all' } } } ] }); but, my client database is very large near about 100,000 record's in table, so i have used in server side process and all's are working fine (list,search,sort). But when i click on excel button and generate excel file at time only current page record's render in excel file,but we need all record's rendering excel file. please help me how's it possible.

issue in Reset Column ordering - I was using table.colReorder.reset();

Hi Alan First of all congratulation ALAN for developing this great great great Plugin. Very minor i have seen a complete widget like this. i am using colvis and colreorder same time and i want to save state of my grid on server side. For doing this I am using statesavecallback its working fine BUT if user reorder columns (after loading datatables) statesavecallback not invoke. If we apply some sorting or search or use colvis, statesavecallback invoke and after any of these actions Now colreorder able to invoke statesavecallback. Other wise it is not working. Any Help from anyone Thanks in advance

Hello, I'm using DT 1.10.4, the new api and server side processing. I've switch to yadcf instead of ColReorder. I'm facing a problem with yadcf and after debugging, i've noticed that the xhr request send was different when you reload the html page than the one send when you use the DT pagination system. Here is my test case: http://yadcf.johndegey.org/ If you switch field2 and field3, then reload the page, the xhr request will be columns[0][data] field1 columns[0][name] field1 columns[0][orderable] true columns[0][search][regex] false columns[0][search][value] columns[0][searchable] true columns[1][data] field2 columns[1][name] field2 columns[1][orderable] true columns[1][search][regex] false columns[1][search][value] columns[1][searchable] true columns[2][data] field3 columns[2][name] field3 columns[2][orderable] true columns[2][search][regex] false columns[2][search][value] columns[2][searchable] true If you just go to page 2 with the pagination, it looks like columns[0][data] field1 columns[0][name] field1 columns[0][orderable] true columns[0][search][regex] false columns[0][search][value] columns[0][searchable] true columns[1][data] field3 columns[1][name] field3 columns[1][orderable] true columns[1][search][regex] false columns[1][search][value] columns[1][searchable] true columns[2][data] field2 columns[2][name] field2 columns[2][orderable] true columns[2][search][regex] false columns[2][search][value] columns[2][searchable] true Notice the column 1 is now field3 and column 2 is field2. Is this an expected behavior ? Shouldn't the 2 request be the same ? Here is the discussion we have on github https://github.com/vedmack/yadcf/issues/151 thanks for help John

syntax for rendering then ordering the json data , specifically

Hello, I am using datatables 1.10 and I have defined a data function in the ajax property of my datatables options as follow: "ajax": { url: AllMxEnvironments.Config.AjaxSource, data: function (d) { } } The problem is in the property d I can access all my changes in the datatable except for sorted column index and OrderDirection. Is there a way to access the ColumnOrder and OrderDirection properties of each column within this function? In case I can't can you please tell me how to get the object in the preDrawCallback or on the draw event of the table? Thanks, Jhonny.

Hi, I am using datatables(client-side) with ColReorder and showing/hiding columns programmatically using fnSetColumnVis(index, true). I have set stateSave = true. Whenever I reorder columns, do sorting on a column, hide/show columns, reorder columns again and click refresh, I am getting different sort column index from fnSettings().aaSorting and fnSettings().aLastSort than column I had sorted on. Due to this I am unable to sort back on column that User had last sorted. I am using fnSort to sort column based on index retrieved from aaSorting. Can someone please let me know how to resolve this. Thanks,

set allow for column ordering. Unfortunately I cannot change