1 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
4 <meta http-equiv="content-type" content="text/html; charset=utf-8" />
5 <link rel="shortcut icon" type="image/ico" href="http://www.datatables.net/media/images/favicon.ico" />
7 <title>DataTables example</title>
8 <style type="text/css" title="currentStyle">
9 @import "../../media/css/demo_page.css";
10 @import "../../media/css/demo_table.css";
12 <script type="text/javascript" language="javascript" src="../../media/js/jquery.js"></script>
13 <script type="text/javascript" language="javascript" src="../../media/js/jquery.dataTables.js"></script>
14 <script type="text/javascript" charset="utf-8">
17 * Function: fnGetColumnData
18 * Purpose: Return an array of table values from a particular column.
19 * Returns: array string: 1d data array
20 * Inputs: object:oSettings - dataTable settings object. This is always the last argument past to the function
21 * int:iColumn - the id of the column to extract the data from
22 * bool:bUnique - optional - if set to false duplicated values are not filtered out
23 * bool:bFiltered - optional - if set to false all the table data is used (not only the filtered)
24 * bool:bIgnoreEmpty - optional - if set to false empty values are not filtered from the result array
25 * Author: Benedikt Forchhammer <b.forchhammer /AT\ mind2.de>
27 $.fn.dataTableExt.oApi.fnGetColumnData = function ( oSettings, iColumn, bUnique, bFiltered, bIgnoreEmpty ) {
28 // check that we have a column id
29 if ( typeof iColumn == "undefined" ) return new Array();
31 // by default we only want unique data
32 if ( typeof bUnique == "undefined" ) bUnique = true;
34 // by default we do want to only look at filtered data
35 if ( typeof bFiltered == "undefined" ) bFiltered = true;
37 // by default we do not want to include empty values
38 if ( typeof bIgnoreEmpty == "undefined" ) bIgnoreEmpty = true;
40 // list of rows which we're going to loop through
43 // use only filtered rows
44 if (bFiltered == true) aiRows = oSettings.aiDisplay;
46 else aiRows = oSettings.aiDisplayMaster; // all row numbers
49 var asResultData = new Array();
51 for (var i=0,c=aiRows.length; i<c; i++) {
53 var aData = this.fnGetData(iRow);
54 var sValue = aData[iColumn];
56 // ignore empty values?
57 if (bIgnoreEmpty == true && sValue.length == 0) continue;
59 // ignore unique values?
60 else if (bUnique == true && jQuery.inArray(sValue, asResultData) > -1) continue;
62 // else push the value onto the result data array
63 else asResultData.push(sValue);
70 function fnCreateSelect( aData )
72 var r='<select><option value=""></option>', i, iLen=aData.length;
73 for ( i=0 ; i<iLen ; i++ )
75 r += '<option value="'+aData[i]+'">'+aData[i]+'</option>';
81 $(document).ready(function() {
82 /* Initialise the DataTable */
83 var oTable = $('#example').dataTable( {
85 "sSearch": "Search all columns:"
89 /* Add a select menu for each TH element in the table footer */
90 $("tfoot th").each( function ( i ) {
91 this.innerHTML = fnCreateSelect( oTable.fnGetColumnData(i) );
92 $('select', this).change( function () {
93 oTable.fnFilter( $(this).val(), i );
99 <body id="dt_example">
101 <div class="full_width big">
102 DataTables individual column filtering example (using select menus)
106 <p>This example is almost identical to <a href="multi_filter.html">individual column example</a> and provides the same functionality, but using <select> menus rather than input elements. The API plug-in function fnGetColumnData from Benedikt Forchhammer provides much of the logic processing required, and integration with a table is almost trivial.</p>
107 <p>One possible interaction chance would be to make use of fnGetColumnData's ability to get filtered data, so you could have the possible filtering values in the select menus to update to only those in the table, rather than all values.</p>
109 <h1>Live example</h1>
111 <table cellpadding="0" cellspacing="0" border="0" class="display" id="example">
114 <th>Rendering engine</th>
117 <th>Engine version</th>
127 <td class="center">4</td>
128 <td class="center">X</td>
135 <td class="center">5</td>
136 <td class="center">C</td>
143 <td class="center">5.5</td>
144 <td class="center">A</td>
151 <td class="center">6</td>
152 <td class="center">A</td>
156 <td>Internet Explorer 7</td>
158 <td class="center">7</td>
159 <td class="center">A</td>
163 <td>AOL browser (AOL desktop)</td>
165 <td class="center">6</td>
166 <td class="center">A</td>
171 <td>Win 98+ / OSX.2+</td>
172 <td class="center">1.7</td>
173 <td class="center">A</td>
178 <td>Win 98+ / OSX.2+</td>
179 <td class="center">1.8</td>
180 <td class="center">A</td>
185 <td>Win 98+ / OSX.2+</td>
186 <td class="center">1.8</td>
187 <td class="center">A</td>
192 <td>Win 2k+ / OSX.3+</td>
193 <td class="center">1.9</td>
194 <td class="center">A</td>
200 <td class="center">1.8</td>
201 <td class="center">A</td>
207 <td class="center">1.8</td>
208 <td class="center">A</td>
212 <td>Netscape 7.2</td>
213 <td>Win 95+ / Mac OS 8.6-9.2</td>
214 <td class="center">1.7</td>
215 <td class="center">A</td>
219 <td>Netscape Browser 8</td>
221 <td class="center">1.7</td>
222 <td class="center">A</td>
226 <td>Netscape Navigator 9</td>
227 <td>Win 98+ / OSX.2+</td>
228 <td class="center">1.8</td>
229 <td class="center">A</td>
234 <td>Win 95+ / OSX.1+</td>
235 <td class="center">1</td>
236 <td class="center">A</td>
241 <td>Win 95+ / OSX.1+</td>
242 <td class="center">1.1</td>
243 <td class="center">A</td>
248 <td>Win 95+ / OSX.1+</td>
249 <td class="center">1.2</td>
250 <td class="center">A</td>
255 <td>Win 95+ / OSX.1+</td>
256 <td class="center">1.3</td>
257 <td class="center">A</td>
262 <td>Win 95+ / OSX.1+</td>
263 <td class="center">1.4</td>
264 <td class="center">A</td>
269 <td>Win 95+ / OSX.1+</td>
270 <td class="center">1.5</td>
271 <td class="center">A</td>
276 <td>Win 95+ / OSX.1+</td>
277 <td class="center">1.6</td>
278 <td class="center">A</td>
283 <td>Win 98+ / OSX.1+</td>
284 <td class="center">1.7</td>
285 <td class="center">A</td>
290 <td>Win 98+ / OSX.1+</td>
291 <td class="center">1.8</td>
292 <td class="center">A</td>
296 <td>Seamonkey 1.1</td>
297 <td>Win 98+ / OSX.2+</td>
298 <td class="center">1.8</td>
299 <td class="center">A</td>
303 <td>Epiphany 2.20</td>
305 <td class="center">1.8</td>
306 <td class="center">A</td>
312 <td class="center">125.5</td>
313 <td class="center">A</td>
319 <td class="center">312.8</td>
320 <td class="center">A</td>
326 <td class="center">419.3</td>
327 <td class="center">A</td>
333 <td class="center">522.1</td>
334 <td class="center">A</td>
340 <td class="center">420</td>
341 <td class="center">A</td>
345 <td>iPod Touch / iPhone</td>
347 <td class="center">420.1</td>
348 <td class="center">A</td>
354 <td class="center">413</td>
355 <td class="center">A</td>
360 <td>Win 95+ / OSX.1+</td>
361 <td class="center">-</td>
362 <td class="center">A</td>
367 <td>Win 95+ / OSX.2+</td>
368 <td class="center">-</td>
369 <td class="center">A</td>
374 <td>Win 95+ / OSX.2+</td>
375 <td class="center">-</td>
376 <td class="center">A</td>
381 <td>Win 95+ / OSX.2+</td>
382 <td class="center">-</td>
383 <td class="center">A</td>
388 <td>Win 95+ / OSX.3+</td>
389 <td class="center">-</td>
390 <td class="center">A</td>
395 <td>Win 88+ / OSX.3+</td>
396 <td class="center">-</td>
397 <td class="center">A</td>
402 <td>Win 88+ / OSX.3+</td>
403 <td class="center">-</td>
404 <td class="center">A</td>
408 <td>Opera for Wii</td>
410 <td class="center">-</td>
411 <td class="center">A</td>
417 <td class="center">-</td>
418 <td class="center">A</td>
422 <td>Nintendo DS browser</td>
424 <td class="center">8.5</td>
425 <td class="center">C/A<sup>1</sup></td>
429 <td>Konqureror 3.1</td>
431 <td class="center">3.1</td>
432 <td class="center">C</td>
436 <td>Konqureror 3.3</td>
438 <td class="center">3.3</td>
439 <td class="center">A</td>
443 <td>Konqureror 3.5</td>
445 <td class="center">3.5</td>
446 <td class="center">A</td>
450 <td>Internet Explorer 4.5</td>
452 <td class="center">-</td>
453 <td class="center">X</td>
457 <td>Internet Explorer 5.1</td>
458 <td>Mac OS 7.6-9</td>
459 <td class="center">1</td>
460 <td class="center">C</td>
464 <td>Internet Explorer 5.2</td>
466 <td class="center">1</td>
467 <td class="center">C</td>
471 <td>NetFront 3.1</td>
472 <td>Embedded devices</td>
473 <td class="center">-</td>
474 <td class="center">C</td>
478 <td>NetFront 3.4</td>
479 <td>Embedded devices</td>
480 <td class="center">-</td>
481 <td class="center">A</td>
486 <td>Embedded devices</td>
487 <td class="center">-</td>
488 <td class="center">X</td>
494 <td class="center">-</td>
495 <td class="center">X</td>
501 <td class="center">-</td>
502 <td class="center">X</td>
507 <td>Windows Mobile 6</td>
508 <td class="center">-</td>
509 <td class="center">C</td>
515 <td class="center">-</td>
516 <td class="center">C</td>
519 <td>Other browsers</td>
522 <td class="center">-</td>
523 <td class="center">U</td>
537 <div class="spacer"></div>
540 <h1>Initialisation code</h1>
541 <pre class="brush: js;">(function($) {
543 * Function: fnGetColumnData
544 * Purpose: Return an array of table values from a particular column.
545 * Returns: array string: 1d data array
546 * Inputs: object:oSettings - dataTable settings object. This is always the last argument past to the function
547 * int:iColumn - the id of the column to extract the data from
548 * bool:bUnique - optional - if set to false duplicated values are not filtered out
549 * bool:bFiltered - optional - if set to false all the table data is used (not only the filtered)
550 * bool:bIgnoreEmpty - optional - if set to false empty values are not filtered from the result array
551 * Author: Benedikt Forchhammer <b.forchhammer /AT\ mind2.de>
553 $.fn.dataTableExt.oApi.fnGetColumnData = function ( oSettings, iColumn, bUnique, bFiltered, bIgnoreEmpty ) {
554 // check that we have a column id
555 if ( typeof iColumn == "undefined" ) return new Array();
557 // by default we only want unique data
558 if ( typeof bUnique == "undefined" ) bUnique = true;
560 // by default we do want to only look at filtered data
561 if ( typeof bFiltered == "undefined" ) bFiltered = true;
563 // by default we do not want to include empty values
564 if ( typeof bIgnoreEmpty == "undefined" ) bIgnoreEmpty = true;
566 // list of rows which we're going to loop through
569 // use only filtered rows
570 if (bFiltered == true) aiRows = oSettings.aiDisplay;
572 else aiRows = oSettings.aiDisplayMaster; // all row numbers
575 var asResultData = new Array();
577 for (var i=0,c=aiRows.length; i<c; i++) {
579 var aData = this.fnGetData(iRow);
580 var sValue = aData[iColumn];
582 // ignore empty values?
583 if (bIgnoreEmpty == true && sValue.length == 0) continue;
585 // ignore unique values?
586 else if (bUnique == true && jQuery.inArray(sValue, asResultData) > -1) continue;
588 // else push the value onto the result data array
589 else asResultData.push(sValue);
596 function fnCreateSelect( aData )
598 var r='<select><option value=""></option>', i, iLen=aData.length;
599 for ( i=0 ; i<iLen ; i++ )
601 r += '<option value="'+aData[i]+'">'+aData[i]+'</option>';
603 return r+'</select>';
607 $(document).ready(function() {
608 /* Initialise the DataTable */
609 var oTable = $('#example').dataTable( {
611 "sSearch": "Search all columns:"
615 /* Add a select menu for each TH element in the table footer */
616 $("tfoot th").each( function ( i ) {
617 this.innerHTML = fnCreateSelect( oTable.fnGetColumnData(i) );
618 $('select', this).change( function () {
619 oTable.fnFilter( $(this).val(), i );
623 <style type="text/css">
624 @import "../examples_support/syntax/css/shCore.css";
626 <script type="text/javascript" language="javascript" src="../examples_support/syntax/js/shCore.js"></script>
629 <h1>Other examples</h1>
630 <div class="demo_links">
631 <h2>Basic initialisation</h2>
633 <li><a href="../basic_init/zero_config.html">Zero configuration</a></li>
634 <li><a href="../basic_init/filter_only.html">Feature enablement</a></li>
635 <li><a href="../basic_init/table_sorting.html">Sorting data</a></li>
636 <li><a href="../basic_init/multi_col_sort.html">Multi-column sorting</a></li>
637 <li><a href="../basic_init/multiple_tables.html">Multiple tables</a></li>
638 <li><a href="../basic_init/hidden_columns.html">Hidden columns</a></li>
639 <li><a href="../basic_init/complex_header.html">Complex headers - grouping with colspan</a></li>
640 <li><a href="../basic_init/dom.html">DOM positioning</a></li>
641 <li><a href="../basic_init/flexible_width.html">Flexible table width</a></li>
642 <li><a href="../basic_init/state_save.html">State saving</a></li>
643 <li><a href="../basic_init/alt_pagination.html">Alternative pagination styles</a></li>
645 <a href="../basic_init/scroll_x.html">Horizontal</a> /
646 <a href="../basic_init/scroll_y.html">Vertical</a> /
647 <a href="../basic_init/scroll_xy.html">Both</a> /
648 <a href="../basic_init/scroll_y_theme.html">Themed</a> /
649 <a href="../basic_init/scroll_y_infinite.html">Infinite</a>
651 <li><a href="../basic_init/language.html">Change language information (internationalisation)</a></li>
652 <li><a href="../basic_init/themes.html">ThemeRoller themes (Smoothness)</a></li>
655 <h2>Advanced initialisation</h2>
658 <a href="../advanced_init/events_live.html">Live events</a> /
659 <a href="../advanced_init/events_pre_init.html">Pre-init</a> /
660 <a href="../advanced_init/events_post_init.html">Post-init</a>
662 <li><a href="../advanced_init/column_render.html">Column rendering</a></li>
663 <li><a href="../advanced_init/html_sort.html">Sorting without HTML tags</a></li>
664 <li><a href="../advanced_init/dom_multiple_elements.html">Multiple table controls (sDom)</a></li>
665 <li><a href="../advanced_init/length_menu.html">Defining length menu options</a></li>
666 <li><a href="../advanced_init/complex_header.html">Complex headers and hidden columns</a></li>
667 <li><a href="../advanced_init/dom_toolbar.html">Custom toolbar (element) around table</a></li>
668 <li><a href="../advanced_init/highlight.html">Row highlighting with CSS</a></li>
669 <li><a href="../advanced_init/row_grouping.html">Row grouping</a></li>
670 <li><a href="../advanced_init/row_callback.html">Row callback</a></li>
671 <li><a href="../advanced_init/footer_callback.html">Footer callback</a></li>
672 <li><a href="../advanced_init/sorting_control.html">Control sorting direction of columns</a></li>
673 <li><a href="../advanced_init/language_file.html">Change language information from a file (internationalisation)</a></li>
674 <li><a href="../advanced_init/defaults.html">Setting defaults</a></li>
675 <li><a href="../advanced_init/localstorage.html">State saving with localStorage</a></li>
676 <li><a href="../advanced_init/dt_events.html">Custom events</a></li>
681 <li><a href="../api/add_row.html">Dynamically add a new row</a></li>
682 <li><a href="../api/multi_filter.html">Individual column filtering (using "input" elements)</a></li>
683 <li><a href="../api/multi_filter_select.html">Individual column filtering (using "select" elements)</a></li>
684 <li><a href="../api/highlight.html">Highlight rows and columns</a></li>
685 <li><a href="../api/row_details.html">Show and hide details about a particular record</a></li>
686 <li><a href="../api/select_row.html">User selectable rows (multiple rows)</a></li>
687 <li><a href="../api/select_single_row.html">User selectable rows (single row) and delete rows</a></li>
688 <li><a href="../api/editable.html">Editable rows (with jEditable)</a></li>
689 <li><a href="../api/form.html">Submit form with elements in table</a></li>
690 <li><a href="../api/counter_column.html">Index column (static number column)</a></li>
691 <li><a href="../api/show_hide.html">Show and hide columns dynamically</a></li>
692 <li><a href="../api/api_in_init.html">API function use in initialisation object (callback)</a></li>
693 <li><a href="../api/tabs_and_scrolling.html">DataTables scrolling and tabs</a></li>
694 <li><a href="../api/regex.html">Regular expression filtering</a></li>
698 <div class="demo_links">
699 <h2>Data sources</h2>
701 <li><a href="../data_sources/dom.html">DOM</a></li>
702 <li><a href="../data_sources/js_array.html">Javascript array</a></li>
703 <li><a href="../data_sources/ajax.html">Ajax source</a></li>
704 <li><a href="../data_sources/server_side.html">Server side processing</a></li>
707 <h2>Server-side processing</h2>
709 <li><a href="../server_side/server_side.html">Obtain server-side data</a></li>
710 <li><a href="../server_side/custom_vars.html">Add extra HTTP variables</a></li>
711 <li><a href="../server_side/post.html">Use HTTP POST</a></li>
712 <li><a href="../server_side/ids.html">Automatic addition of IDs and classes to rows</a></li>
713 <li><a href="../server_side/object_data.html">Reading table data from objects</a></li>
714 <li><a href="../server_side/row_details.html">Show and hide details about a particular record</a></li>
715 <li><a href="../server_side/select_rows.html">User selectable rows (multiple rows)</a></li>
716 <li><a href="../server_side/jsonp.html">JSONP for a cross domain data source</a></li>
717 <li><a href="../server_side/editable.html">jEditable integration with DataTables</a></li>
718 <li><a href="../server_side/defer_loading.html">Deferred loading of Ajax data</a></li>
719 <li><a href="../server_side/pipeline.html">Pipelining data (reduce Ajax calls for paging)</a></li>
722 <h2>Ajax data source</h2>
724 <li><a href="../ajax/ajax.html">Ajax sourced data (array of arrays)</a></li>
725 <li><a href="../ajax/objects.html">Ajax sourced data (array of objects)</a></li>
726 <li><a href="../ajax/defer_render.html">Deferred DOM creation for extra speed</a></li>
727 <li><a href="../ajax/null_data_source.html">Empty data source columns</a></li>
728 <li><a href="../ajax/custom_data_property.html">Use a data source other than aaData (the default)</a></li>
729 <li><a href="../ajax/objects_subarrays.html">Read column data from sub-arrays</a></li>
730 <li><a href="../ajax/deep.html">Read column data from deeply nested properties</a></li>
735 <li><a href="../plug-ins/plugin_api.html">Add custom API functions</a></li>
736 <li><a href="../plug-ins/sorting_plugin.html">Sorting and automatic type detection</a></li>
737 <li><a href="../plug-ins/sorting_sType.html">Sorting without automatic type detection</a></li>
738 <li><a href="../plug-ins/paging_plugin.html">Custom pagination controls</a></li>
739 <li><a href="../plug-ins/range_filtering.html">Range filtering / custom filtering</a></li>
740 <li><a href="../plug-ins/dom_sort.html">Live DOM sorting</a></li>
741 <li><a href="../plug-ins/html_sort.html">Automatic HTML type detection</a></li>
746 <div id="footer" class="clear" style="text-align:center;">
748 Please refer to the <a href="http://www.datatables.net/usage">DataTables documentation</a> for full information about its API properties and methods.<br>
749 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.
752 <span style="font-size:10px;">
753 DataTables designed and created by <a href="http://www.sprymedia.co.uk">Allan Jardine</a> © 2007-2011<br>
754 DataTables is dual licensed under the <a href="http://www.datatables.net/license_gpl2">GPL v2 license</a> or a <a href="http://www.datatables.net/license_bsd">BSD (3-point) license</a>.