EVOLUTION-NINJA

Edit File: group_columns.html

<!DOCTYPE html>

<html>

<head>

<title>ColVis example - Group columns</title>

</style>

$(document).ready(function() {

$('#example').DataTable( {

dom: 'C<"clear">lfrtip',

colVis: {

exclude: [],

groups: [

{

title: "Engine",

columns: [ 0, 3 ]

{

title: "Client",

columns: [ 1, 2 ]

}

]

}

} );

</script>

</head>

<h1>ColVis example <span>Group columns</span></h1>

<p>It can be useful at times to show and hide multiple columns together - i.e. grouping them together. Groupings are defined by the <code>groups</code> array.

Create a group button by naming it (using the <code>title</code> option) and specifying by index which columns belong to it (using the <code>columns</code>

option).</p>

<p>Note also that this ability to create groups can be used in combination <code>exclude</code> to remove individual columns from the list (should you wish them to

only be used in the groups), or set <code>exclude = [ 'all' ]</code> to show only the grouping buttons (i.e. individual column control buttons will not be

shown).</p>

<p>For full information about the ColVis options, please refer to the <a href="//datatables.net/extensions/colvis/options">ColVis options documentation</a>.</p>

</div>

<thead>

<tr>

<th>Position</th>

<th>Office</th>

<th>Start date</th>

<th>Salary</th>

</tr>

</thead>

<tfoot>

<tr>

<th>Position</th>

<th>Office</th>

<th>Start date</th>

<th>Salary</th>

</tr>

</tfoot>

<tbody>

<tr>

<td>Tiger Nixon</td>

<td>System Architect</td>

<td>Edinburgh</td>

</tr>

<tr>

<td>Garrett Winters</td>

<td>Accountant</td>

<td>Tokyo</td>

</tr>

<tr>

<td>Ashton Cox</td>

<td>Junior Technical Author</td>

<td>San Francisco</td>

</tr>

<tr>

<td>Cedric Kelly</td>

<td>Senior Javascript Developer</td>

<td>Edinburgh</td>

</tr>

<tr>

<td>Airi Satou</td>

<td>Accountant</td>

<td>Tokyo</td>

</tr>

<tr>

<td>Brielle Williamson</td>

<td>Integration Specialist</td>

</tr>

<tr>

<td>Herrod Chandler</td>

<td>Sales Assistant</td>

<td>San Francisco</td>

</tr>

<tr>

<td>Rhona Davidson</td>

<td>Integration Specialist</td>

<td>Tokyo</td>

</tr>

<tr>

<td>Colleen Hurst</td>

<td>Javascript Developer</td>

<td>San Francisco</td>

</tr>

<tr>

<td>Sonya Frost</td>

<td>Software Engineer</td>

<td>Edinburgh</td>

</tr>

<tr>

<td>Jena Gaines</td>

<td>Office Manager</td>

<td>London</td>

</tr>

<tr>

<td>Quinn Flynn</td>

<td>Support Lead</td>

<td>Edinburgh</td>

</tr>

<tr>

<td>Charde Marshall</td>

<td>Regional Director</td>

<td>San Francisco</td>

</tr>

<tr>

<td>Haley Kennedy</td>

<td>Senior Marketing Designer</td>

<td>London</td>

</tr>

<tr>

<td>Tatyana Fitzpatrick</td>

<td>Regional Director</td>

<td>London</td>

</tr>

<tr>

<td>Michael Silva</td>

<td>Marketing Designer</td>

<td>London</td>

</tr>

<tr>

<td>Chief Financial Officer (CFO)</td>

</tr>

<tr>

<td>Gloria Little</td>

<td>Systems Administrator</td>

</tr>

<tr>

<td>Bradley Greer</td>

<td>Software Engineer</td>

<td>London</td>

</tr>

<tr>

<td>Personnel Lead</td>

<td>Edinburgh</td>

</tr>

<tr>

<td>Jenette Caldwell</td>

<td>Development Lead</td>

</tr>

<tr>

<td>Yuri Berry</td>

<td>Chief Marketing Officer (CMO)</td>

</tr>

<tr>

<td>Caesar Vance</td>

<td>Pre-Sales Support</td>

</tr>

<tr>

<td>Doris Wilder</td>

<td>Sales Assistant</td>

<td>Sidney</td>

</tr>

<tr>

<td>Angelica Ramos</td>

<td>Chief Executive Officer (CEO)</td>

<td>London</td>

</tr>

<tr>

<td>Gavin Joyce</td>

<td>Developer</td>

<td>Edinburgh</td>

</tr>

<tr>

<td>Jennifer Chang</td>

<td>Regional Director</td>

<td>Singapore</td>

</tr>

<tr>

<td>Brenden Wagner</td>

<td>Software Engineer</td>

<td>San Francisco</td>

</tr>

<tr>

<td>Fiona Green</td>

<td>Chief Operating Officer (COO)</td>

<td>San Francisco</td>

</tr>

<tr>

<td>Regional Marketing</td>

<td>Tokyo</td>

</tr>

<tr>

<td>Michelle House</td>

<td>Integration Specialist</td>

<td>Sidney</td>

</tr>

<tr>

<td>Suki Burks</td>

<td>Developer</td>

<td>London</td>

</tr>

<tr>

<td>Prescott Bartlett</td>

<td>Technical Author</td>

<td>London</td>

</tr>

<tr>

<td>Gavin Cortez</td>

<td>Team Leader</td>

<td>San Francisco</td>

</tr>

<tr>

<td>Martena Mccray</td>

<td>Post-Sales support</td>

<td>Edinburgh</td>

</tr>

<tr>

<td>Unity Butler</td>

<td>Marketing Designer</td>

<td>San Francisco</td>

</tr>

<tr>

<td>Howard Hatfield</td>

<td>Office Manager</td>

<td>San Francisco</td>

</tr>

<tr>

<td>Hope Fuentes</td>

<td>Secretary</td>

<td>San Francisco</td>

</tr>

<tr>

<td>Vivian Harrell</td>

<td>Financial Controller</td>

<td>San Francisco</td>

</tr>

<tr>

<td>Timothy Mooney</td>

<td>Office Manager</td>

<td>London</td>

</tr>

<tr>

<td>Jackson Bradshaw</td>

<td>Director</td>

</tr>

<tr>

<td>Olivia Liang</td>

<td>Support Engineer</td>

<td>Singapore</td>

</tr>

<tr>

<td>Bruno Nash</td>

<td>Software Engineer</td>

<td>London</td>

</tr>

<tr>

<td>Sakura Yamamoto</td>

<td>Support Engineer</td>

<td>Tokyo</td>

</tr>

<tr>

<td>Thor Walton</td>

<td>Developer</td>

</tr>

<tr>

<td>Finn Camacho</td>

<td>Support Engineer</td>

<td>San Francisco</td>

</tr>

<tr>

<td>Serge Baldwin</td>

<td>Data Coordinator</td>

<td>Singapore</td>

</tr>

<tr>

<td>Zenaida Frank</td>

<td>Software Engineer</td>

</tr>

<tr>

<td>Zorita Serrano</td>

<td>Software Engineer</td>

<td>San Francisco</td>

</tr>

<tr>

<td>Jennifer Acosta</td>

<td>Junior Javascript Developer</td>

<td>Edinburgh</td>

</tr>

<tr>

<td>Cara Stevens</td>

<td>Sales Assistant</td>

</tr>

<tr>

<td>Hermione Butler</td>

<td>Regional Director</td>

<td>London</td>

</tr>

<tr>

<td>Lael Greer</td>

<td>Systems Administrator</td>

<td>London</td>

</tr>

<tr>

<td>Jonas Alexander</td>

<td>Developer</td>

<td>San Francisco</td>

</tr>

<tr>

<td>Shad Decker</td>

<td>Regional Director</td>

<td>Edinburgh</td>

</tr>

<tr>

<td>Michael Bruce</td>

<td>Javascript Developer</td>

<td>Singapore</td>

</tr>

<tr>

<td>Donna Snider</td>

<td>Customer Support</td>

</tr>

</tbody>

</table>

<li class="active">Javascript</li>

<li>Server-side script</li>

</ul>

<p>The Javascript shown below is used to initialise the table shown in this example:</p><code class="multiline language-js">$(document).ready(function() {

$('#example').DataTable( {

dom: 'C&lt;&quot;clear&quot;&gt;lfrtip',

colVis: {

exclude: [],

groups: [

{

title: &quot;Engine&quot;,

columns: [ 0, 3 ]

{

title: &quot;Client&quot;,

columns: [ 1, 2 ]

}

]

}

} );

} );</code>

<p>In addition to the above code, the following Javascript library files are loaded for use in this example:</p>

<ul>

<li><a href="../../../media/js/jquery.js">../../../media/js/jquery.js</a></li>

<li><a href="../../../media/js/jquery.dataTables.js">../../../media/js/jquery.dataTables.js</a></li>

<li><a href="../js/dataTables.colVis.js">../js/dataTables.colVis.js</a></li>

</ul>

</div>

<p>The HTML shown below is the raw HTML table element, before it has been enhanced by DataTables:</p>

</div>

<div>

<p>This example uses a little bit of additional CSS beyond what is loaded from the library files (below), in order to correctly display the table. The

additional CSS used is shown below:</p><code class="multiline language-css"></code>

</div>

<p>The following CSS library files are loaded for use in this example to provide the styling of the table:</p>

<ul>

<li><a href="../../../media/css/jquery.dataTables.css">../../../media/css/jquery.dataTables.css</a></li>

<li><a href="../css/dataTables.colVis.css">../css/dataTables.colVis.css</a></li>

</ul>

</div>

<p>This table loads data by Ajax. The latest data that has been loaded is shown below. This data will update automatically as any additional data is

loaded.</p>

</div>

<p>The script used to perform the server-side processing for this table is shown below. Please note that this is just an example script using PHP. Server-side

processing scripts can be written in any language, using <a href="//datatables.net/manual/server-side">the protocol described in the DataTables

documentation</a>.</p>

</div>

</section>

</div>

<h2>Other examples</h2>

<h3><a href="./index.html">Examples</a></h3>

<li><a href="./simple.html">Basic initialisation</a></li>

<li><a href="./new_init.html">`new` initialisation</a></li>

<li><a href="./text.html">Custom button text</a></li>

<li><a href="./exclude_columns.html">Exclude columns from list</a></li>

<li><a href="./title_callback.html">Column button callback</a></li>

<li><a href="./button_order.html">Button ordering</a></li>

<li><a href="./mouseover.html">Mouseover activation</a></li>

<li class="active"><a href="./group_columns.html">Group columns</a></li>

<li><a href="./two_tables.html">Two tables with individual controls</a></li>

<li><a href="./two_tables_identical.html">Two tables with shared controls</a></li>

<li><a href="./restore.html">Restore / show all</a></li>

<li><a href="./jqueryui.html">jQuery UI styling</a></li>

</ul>

</div>

<p>Please refer to the <a href="http://www.datatables.net">DataTables documentation</a> for full information about its API properties and methods.<br>

Additionally, there are a wide range of <a href="http://www.datatables.net/extras">extras</a> and <a href="http://www.datatables.net/plug-ins">plug-ins</a>

which extend the capabilities of DataTables.</p>

<p class="copyright">DataTables designed and created by <a href="http://www.sprymedia.co.uk">SpryMedia Ltd</a> &#169; 2007-2015<br>

DataTables is licensed under the <a href="http://www.datatables.net/mit">MIT license</a>.</p>

</div>

</section>

</body>

</html>