DataTables - Row grouping

by Mohammad Gouse

HTML

<link rel="stylesheet" href="https://cdn.datatables.net/1.10.7/css/jquery.dataTables.css">
<script src="https://cdn.datatables.net/1.10.7/js/jquery.dataTables.min.js"></script>
<table id="example" class="display" cellspacing="0" width="100%">
    <thead>
        <tr>
           <th>Status</th>
            <th>Project</th>
            <th>Region</th>
			<th>Unit Name</th>
            <th>Days of First Fire</th>
            <th>First Fire date</th>
            <th>Action</th>
        </tr>
    </thead>
       <tbody>
        <tr>
            <td><span style="color: #fff;padding: 3px;border: 1px solid red;background: red;">InComplete</span></td>
            <td>Alba</td>
            <td>Asia</td>
			 <td>Unit 1</td>
            <td>61</td>
            <td>2011/04/25</td>
            <td>$320,800</td>
        </tr>
        <tr>
         <td> <span style="color: #6d5760;padding: 3px;border: 1px solid yellow;background: yellow;">Release</span></tc>
            <td>Alba</td>
            <td>America</td>
				 <td>Unit 1</td>
            <td>63</td>
            <td>2011/07/25</td>
            <td>$170,750</td>
        </tr>
        <tr>
           <td><span style="color: #fff;padding: 3px;border: 1px solid #3fb618;background: #3fb618;">First Fire</span></td>
            <td>Asset</td>
            <td>San Francisco</td>
				 <td>Unit 2</td>
            <td>66</td>
            <td>2009/01/12</td>
            <td>$86,000</td>
        </tr>
        <tr>
            <td><span style="color: #fff;padding: 3px;border: 1px solid #3fb618;background: #3fb618;">First Fire</span></td>
            <td>Alba</td>
            <td>Middle East</td>
				 <td>Unit 2</td>
            <td>41</td>
            <td>2012/10/13</td>
            <td>$132,000</td>
        </tr>
        <tr>
            <td><span style="color: #fff;padding: 3px;border: 1px solid #3fb618;background: #3fb618;">First Fire</span></td>
            <td>Alba</td>
            <td>Asia</td>
			 <td>Unit 2</td>
           ...

CSS

tr.group,
tr.group:hover {
    background-color: #ddd !important;
}

JavaScript

$(document).ready(function() {
    $('#example').DataTable( {
        initComplete: function () {
            this.api().columns().every( function () {
                var column = this;
                var select = $('<select><option value=""></option></select>')
                    .appendTo( $(column.footer()).empty() )
                    .on( 'change', function () {
                        var val = $.fn.dataTable.util.escapeRegex(
                            $(this).val()
                        );
 
                        column
                            .search( val ? '^'+val+'$' : '', true, false )
                            .draw();
                    } );
 
                column.data().unique().sort().each( function ( d, j ) {
                    select.append( '<option value="'+d+'">'+d+'</option>' )
                } );
            } );
        }
    } );
} );