File
Add library
Share
Login or Register
Help
HTMLSaved
 
<!DOCTYPE html>
<html>
  <head>
    <script src="https://code.jquery.com/jquery-1.11.3.min.js"></script>
    <link href="https://cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/5.3.0/css/bootstrap.min.css" rel="stylesheet" type="text/css" />
    <link href="https://cdn.datatables.net/v/bs5/jq-3.7.0/jszip-3.10.1/dt-2.1.8/af-2.7.0/b-3.1.2/b-colvis-3.1.2/b-html5-3.1.2/b-print-3.1.2/cr-2.0.4/date-1.5.4/fc-5.0.3/fh-4.0.1/kt-2.12.1/r-3.0.3/rg-1.5.0/rr-1.5.0/sb-1.8.1/sp-2.3.3/sl-2.1.0/sr-1.4.1/datatables.min.css" rel="stylesheet" type="text/css" />
    <script src="https://cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/5.3.0/js/bootstrap.bundle.min.js"></script>
    <script src="https://cdn.datatables.net/v/bs5/jq-3.7.0/jszip-3.10.1/dt-2.1.8/af-2.7.0/b-3.1.2/b-colvis-3.1.2/b-html5-3.1.2/b-print-3.1.2/cr-2.0.4/date-1.5.4/fc-5.0.3/fh-4.0.1/kt-2.12.1/r-3.0.3/rg-1.5.0/rr-1.5.0/sb-1.8.1/sp-2.3.3/sl-2.1.0/sr-1.4.1/datatables.min.js"></script>
​
    <meta charset=utf-8 />
    <title>DataTables - JS Bin</title>
  </head>
  <body>
    <div class="container">
      <table id="example" class="display nowrap" width="100%">
​
      </table>
    </div>
  </body>
</html>
​
CSSSaved
 
body {
  font: 90%/1.45em "Helvetica Neue", HelveticaNeue, Verdana, Arial, Helvetica, sans-serif;
  margin: 0;
  padding: 0;
  color: #333;
  background-color: #fff;
}
​
JavaScriptSaved
 
​
var table = new DataTable('#example', {
  ajax: "https://live.datatables.net/examples/ajax/data/data_5k.txt",
  layout: {
    topStart: 'pageLength',
    top2Start: {
      buttons: [
        {
          className: 'btn-sm',
          extend: 'searchPanes',
          config: {
            cascadePanes: true,
          },
        },
      ]
    },
  },
  columns: [
    {
      data: 'name',
      title: 'Name',
      searchPanes: { show: true},
    },
    {
      data: 'position',
      title: 'Position',
      searchPanes: { show: true},
    },
    {
      data: 'office',
      title: 'Office',
      searchPanes: {
        show: true,
        options: [
          {
            label: 'Tokyo',
            value: function(rowData, rowIdx) {
               return rowData.office == 'Tokyo';
            },
          },
          {
            label: 'London',
            value: function(rowData, rowIdx) {
               return rowData.office == 'San Francisco';
            },
          },
          {
            label: 'New York',
            value: function(rowData, rowIdx) {
               return rowData.office == 'New York';
            },
          },
          {
            label: 'Bellevue',
            value: function(rowData, rowIdx) {
               return rowData.office == 'Bellevue';
            },
          },
          {
            label: 'Amarillo',
            value: function(rowData, rowIdx) {
               return rowData.office == 'Amarillo';
            },
          },
          {
            label: 'Springfield',
            value: function(rowData, rowIdx) {
               return rowData.office == 'Springfield';
            },
          },
        ],
      },
    },
    {
      data: 'salary',
      title: 'Salary',
    },
    {
      data: 'start_date',
      title: 'Start Date',
    },
​
    {
      data: 'extn',
      title: 'Ext',
    },
  ],
  columnDefs: [
    {
      searchPanes: {
        show: false,
      },
      targets: '_all',
    },
  ],
});
​
​
Output

You can jump to the latest bin by adding /latest to your URL

Dismiss x
public
Bin info
anonymouspro
0viewers