Search

I'd like to have column headers that include both the column name, and a dropdown that would allow the user to select which columns they want to display. The means of selection would be a checkmark or a checkbox by each column name in the list. I've attached a screenshot of what I'm looking for, from another web app. If they uncheck a column name from the dropdown, that column would disappear from the table, and vice-versa. What I'm looking for involves several pieces: 1. Creating a column header that can display the dropdown list of columns to select from 2. The checkmarks persisting on the page, once selected 3. Re-rendering as soon as a column is selected or deselected from the list. (I believe this part will be simpler, once I get #1 and #2... but I could be wrong, so I'm interested in anything anyone can tell me about this as well) I've been told that DataTables can do this, but I don't see anything obvious in the DataTables documentation. (Nor in general web searches, looking for this functionality in DataTables and other tools.) Does anyone have any ideas? I appreciate any and all ideas! Thanks

Because I found a solution that used https://datatables.net/extensions/tabletools/ but this extension is retired. How should I proceed? This is a piece of my code, concerning the buttons: dom: 'Blfrtip', buttons: [ 'copyHtml5', 'excelHtml5', 'csvHtml5', 'pdfHtml5' ],

Hi, I am using a button collection which is extended from built-in html5 buttons. var table = $('#myTable').DataTable({ ........ buttons: [ { extend: 'csvHtml5', title: 'My Leaves', exportOptions: { columns: [5, 6, 7, 8, 9, 10, 23, 24] } }, { extend: 'excelHtml5', title: 'My Leaves', exportOptions: { columns: [5, 6, 7, 8, 9, 10, 23, 24] } }, { extend: 'pdfHtml5', title: 'My Leaves', exportOptions: { columns: [5, 6, 7, 8, 9, 10, 23, 24] } }, { extend: 'copyHtml5', text: 'Lưu Bộ Nhớ Tạm', exportOptions: { columns: [5, 6, 7, 8, 9, 10, 23, 24] } }, { extend: 'print', text: 'In Tất Cả', title: 'My Leaves', exportOptions: { columns: [5, 6, 7, 8, 9, 10, 23, 24] } } ] ..... Now, I want to add my own collection- a new button named "Actions" and when I click on it, the "ADD, DELETE,EDIT" buttons will be shown down. Please help me to do that. Many thanks.

Hi everyone, i need to do a table using data of 2 (or more) tables of my database (mysql) using ajax and php obv. for 1 table i'm using this code: <?php /* * DataTables example server-side processing script. * * Please note that this script is intentionally extremely simply to show how * server-side processing can be implemented, and probably shouldn't be used as * the basis for a large complex system. It is suitable for simple use cases as * for learning. * * See http://datatables.net/usage/server-side for full details on the server- * side processing requirements of DataTables. * * @license MIT - http://datatables.net/license_mit */ /* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * Easy set variables */ // DB table to use $table = 'table'; // Table's primary key $primaryKey = 'primarykey'; // Array of database columns which should be read and sent back to DataTables. // The `db` parameter represents the column name in the database, while the `dt` // parameter represents the DataTables column identifier. In this case simple // indexes $columns = array( array( 'db' => 'cod', 'dt' => 0 ), array( 'db' => 'description', 'dt' => 1 ), array( 'db' => 'date', 'dt' => 2, 'formatter' => function( $d, $row ) { return date( 'Y/m/d', strtotime($d)); } ) ); // SQL server connection information $sql_details = array( 'user' => 'root', 'pass' => '', 'db' => 'db', 'host' => '127.0.0.1' ); /* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * If you just want to use the basic configuration for DataTables with PHP * server-side, there is no need to edit below this line. */ require( 'ssp.class.php' ); echo json_encode( SSP::simple( $_GET, $sql_details, $table, $primaryKey, $columns ) ); anyone can help me? thanks so much!

happen. New row is created via editor, after creation

Hi, I am going to show a progress bar while exporting data table to excel at server side.My exporting servlet works fine and export all the data.But now I want to show the progress of exporting on jsp using progress bar.plz help me to salve this problem. Thank you in Advance

With your angular datatable api, how it possible to generate a dynamic html table usin dynamic json array (number of column is undefined) ? thx,

Hello all, I am using datatables with the editor extension to post data to an ASP.NET MVC backend. The action I am calling expects a complex object which I would like it to be able to automatically find the property values for using default model binding. My problem is the default model binding expects the fields to have EXACTLY the same names as the public properties defined by my object. So when the table POSTs the data data as data[name]="name" it can't find the value for the property 'Name'. I can work around this problem by defining a custom model binder, but I have a lot of models I will be working with so would rather be able to reformat the data send by the table so that the default model binder can find it e.g. name="name". Can this be done? Thanks Nathan

Hi All, A newbie to DataTables, but am keen to implement on its core functionalities as I think its really extensible. I'm trying to integrate a Music Playlist Creator using 3 tables into my Rails application. Table 1 - Songs, music, cuts Table 2 - Jingles, commercials Table 3 - Blank Playlist My aim is to drag and drop the contents from Tables 1 + 2 into the Blank Playlist table. I have been experimenting with jQuery UI but doesn't have the functionality I need. The closest example I can find is: http://codepen.io/esironal/pen/britv although this doesn't have all the bells and whistles like DataTables, e.g. sorting, search etc and only uses 2 tables. Would be great to hear if anyone has ideas or solutions to point me in the right direction. FYI, am using Bootstrap 3 if that makes any difference whatsoever to the responsiveness/styling. Look forward to hearing from anyone - Many thanks!

Hello, is there some sort of callback, when i add childrow to table using "columns":[ {"data": null, "class": 'details-control', "defaultContent": '' }, as in example here http://datatables.net/examples/api/row_details.html ?