Project

General

Profile

1
<!DOCTYPE html>
2
<html>
3
<head>
4
	<meta charset="utf-8">
5
	<link rel="shortcut icon" type="image/ico" href="http://www.datatables.net/favicon.ico">
6
	<meta name="viewport" content="initial-scale=1.0, maximum-scale=2.0">
7

    
8
	<title>ColReorder example - Individual column filtering</title>
9
	<link rel="stylesheet" type="text/css" href="../../../media/css/jquery.dataTables.css">
10
	<link rel="stylesheet" type="text/css" href="../css/dataTables.colReorder.css">
11
	<link rel="stylesheet" type="text/css" href="../../../examples/resources/syntax/shCore.css">
12
	<link rel="stylesheet" type="text/css" href="../../../examples/resources/demo.css">
13
	<style type="text/css" class="init">
14

    
15
	</style>
16
	<script type="text/javascript" language="javascript" src="../../../media/js/jquery.js"></script>
17
	<script type="text/javascript" language="javascript" src="../../../media/js/jquery.dataTables.js"></script>
18
	<script type="text/javascript" language="javascript" src="../js/dataTables.colReorder.js"></script>
19
	<script type="text/javascript" language="javascript" src="../../../examples/resources/syntax/shCore.js"></script>
20
	<script type="text/javascript" language="javascript" src="../../../examples/resources/demo.js"></script>
21
	<script type="text/javascript" language="javascript" class="init">
22

    
23

    
24
$(document).ready(function() {
25
    // Setup - add a text input to each footer cell
26
    $('#example tfoot th').each( function () {
27
        var title = $('#example thead th').eq( $(this).index() ).text();
28
        $(this).html( '<input type="text" placeholder="Search '+title+'" />' );
29
    } );
30
 
31
    // DataTable
32
    var table = $('#example').DataTable( {
33
		dom: 'Rlfrtip'
34
	} );
35
     
36
    // Apply the filter
37
    $("#example tfoot input").on( 'keyup change', function () {
38
        table
39
            .column( $(this).parent().index()+':visible' )
40
            .search( this.value )
41
            .draw();
42
    } );
43
} );
44

    
45

    
46
	</script>
47
</head>
48

    
49
<body class="dt-example">
50
	<div class="container">
51
		<section>
52
			<h1>ColReorder example <span>Individual column filtering</span></h1>
53

    
54
			<div class="info">
55
				<p>This example of how to use ColReorder shows how it can with with DataTables' ability to do
56
				individual column filtering. The basic example is exactly the same as the DataTables column filtering
57
				example, but with ColReorder also added to the table (through the <code>R</code> option for <a href=
58
				"//datatables.net/reference/option/dom"><code class="option" title=
59
				"DataTables initialisation option">dom<span>DT</span></code></a>).</p>
60
			</div>
61

    
62
			<table id="example" class="display" cellspacing="0" width="100%">
63
				<thead>
64
					<tr>
65
						<th>Name</th>
66
						<th>Position</th>
67
						<th>Office</th>
68
						<th>Age</th>
69
						<th>Start date</th>
70
						<th>Salary</th>
71
					</tr>
72
				</thead>
73

    
74
				<tfoot>
75
					<tr>
76
						<th>Name</th>
77
						<th>Position</th>
78
						<th>Office</th>
79
						<th>Age</th>
80
						<th>Start date</th>
81
						<th>Salary</th>
82
					</tr>
83
				</tfoot>
84

    
85
				<tbody>
86
					<tr>
87
						<td>Tiger Nixon</td>
88
						<td>System Architect</td>
89
						<td>Edinburgh</td>
90
						<td>61</td>
91
						<td>2011/04/25</td>
92
						<td>$320,800</td>
93
					</tr>
94
					<tr>
95
						<td>Garrett Winters</td>
96
						<td>Accountant</td>
97
						<td>Tokyo</td>
98
						<td>63</td>
99
						<td>2011/07/25</td>
100
						<td>$170,750</td>
101
					</tr>
102
					<tr>
103
						<td>Ashton Cox</td>
104
						<td>Junior Technical Author</td>
105
						<td>San Francisco</td>
106
						<td>66</td>
107
						<td>2009/01/12</td>
108
						<td>$86,000</td>
109
					</tr>
110
					<tr>
111
						<td>Cedric Kelly</td>
112
						<td>Senior Javascript Developer</td>
113
						<td>Edinburgh</td>
114
						<td>22</td>
115
						<td>2012/03/29</td>
116
						<td>$433,060</td>
117
					</tr>
118
					<tr>
119
						<td>Airi Satou</td>
120
						<td>Accountant</td>
121
						<td>Tokyo</td>
122
						<td>33</td>
123
						<td>2008/11/28</td>
124
						<td>$162,700</td>
125
					</tr>
126
					<tr>
127
						<td>Brielle Williamson</td>
128
						<td>Integration Specialist</td>
129
						<td>New York</td>
130
						<td>61</td>
131
						<td>2012/12/02</td>
132
						<td>$372,000</td>
133
					</tr>
134
					<tr>
135
						<td>Herrod Chandler</td>
136
						<td>Sales Assistant</td>
137
						<td>San Francisco</td>
138
						<td>59</td>
139
						<td>2012/08/06</td>
140
						<td>$137,500</td>
141
					</tr>
142
					<tr>
143
						<td>Rhona Davidson</td>
144
						<td>Integration Specialist</td>
145
						<td>Tokyo</td>
146
						<td>55</td>
147
						<td>2010/10/14</td>
148
						<td>$327,900</td>
149
					</tr>
150
					<tr>
151
						<td>Colleen Hurst</td>
152
						<td>Javascript Developer</td>
153
						<td>San Francisco</td>
154
						<td>39</td>
155
						<td>2009/09/15</td>
156
						<td>$205,500</td>
157
					</tr>
158
					<tr>
159
						<td>Sonya Frost</td>
160
						<td>Software Engineer</td>
161
						<td>Edinburgh</td>
162
						<td>23</td>
163
						<td>2008/12/13</td>
164
						<td>$103,600</td>
165
					</tr>
166
					<tr>
167
						<td>Jena Gaines</td>
168
						<td>Office Manager</td>
169
						<td>London</td>
170
						<td>30</td>
171
						<td>2008/12/19</td>
172
						<td>$90,560</td>
173
					</tr>
174
					<tr>
175
						<td>Quinn Flynn</td>
176
						<td>Support Lead</td>
177
						<td>Edinburgh</td>
178
						<td>22</td>
179
						<td>2013/03/03</td>
180
						<td>$342,000</td>
181
					</tr>
182
					<tr>
183
						<td>Charde Marshall</td>
184
						<td>Regional Director</td>
185
						<td>San Francisco</td>
186
						<td>36</td>
187
						<td>2008/10/16</td>
188
						<td>$470,600</td>
189
					</tr>
190
					<tr>
191
						<td>Haley Kennedy</td>
192
						<td>Senior Marketing Designer</td>
193
						<td>London</td>
194
						<td>43</td>
195
						<td>2012/12/18</td>
196
						<td>$313,500</td>
197
					</tr>
198
					<tr>
199
						<td>Tatyana Fitzpatrick</td>
200
						<td>Regional Director</td>
201
						<td>London</td>
202
						<td>19</td>
203
						<td>2010/03/17</td>
204
						<td>$385,750</td>
205
					</tr>
206
					<tr>
207
						<td>Michael Silva</td>
208
						<td>Marketing Designer</td>
209
						<td>London</td>
210
						<td>66</td>
211
						<td>2012/11/27</td>
212
						<td>$198,500</td>
213
					</tr>
214
					<tr>
215
						<td>Paul Byrd</td>
216
						<td>Chief Financial Officer (CFO)</td>
217
						<td>New York</td>
218
						<td>64</td>
219
						<td>2010/06/09</td>
220
						<td>$725,000</td>
221
					</tr>
222
					<tr>
223
						<td>Gloria Little</td>
224
						<td>Systems Administrator</td>
225
						<td>New York</td>
226
						<td>59</td>
227
						<td>2009/04/10</td>
228
						<td>$237,500</td>
229
					</tr>
230
					<tr>
231
						<td>Bradley Greer</td>
232
						<td>Software Engineer</td>
233
						<td>London</td>
234
						<td>41</td>
235
						<td>2012/10/13</td>
236
						<td>$132,000</td>
237
					</tr>
238
					<tr>
239
						<td>Dai Rios</td>
240
						<td>Personnel Lead</td>
241
						<td>Edinburgh</td>
242
						<td>35</td>
243
						<td>2012/09/26</td>
244
						<td>$217,500</td>
245
					</tr>
246
					<tr>
247
						<td>Jenette Caldwell</td>
248
						<td>Development Lead</td>
249
						<td>New York</td>
250
						<td>30</td>
251
						<td>2011/09/03</td>
252
						<td>$345,000</td>
253
					</tr>
254
					<tr>
255
						<td>Yuri Berry</td>
256
						<td>Chief Marketing Officer (CMO)</td>
257
						<td>New York</td>
258
						<td>40</td>
259
						<td>2009/06/25</td>
260
						<td>$675,000</td>
261
					</tr>
262
					<tr>
263
						<td>Caesar Vance</td>
264
						<td>Pre-Sales Support</td>
265
						<td>New York</td>
266
						<td>21</td>
267
						<td>2011/12/12</td>
268
						<td>$106,450</td>
269
					</tr>
270
					<tr>
271
						<td>Doris Wilder</td>
272
						<td>Sales Assistant</td>
273
						<td>Sidney</td>
274
						<td>23</td>
275
						<td>2010/09/20</td>
276
						<td>$85,600</td>
277
					</tr>
278
					<tr>
279
						<td>Angelica Ramos</td>
280
						<td>Chief Executive Officer (CEO)</td>
281
						<td>London</td>
282
						<td>47</td>
283
						<td>2009/10/09</td>
284
						<td>$1,200,000</td>
285
					</tr>
286
					<tr>
287
						<td>Gavin Joyce</td>
288
						<td>Developer</td>
289
						<td>Edinburgh</td>
290
						<td>42</td>
291
						<td>2010/12/22</td>
292
						<td>$92,575</td>
293
					</tr>
294
					<tr>
295
						<td>Jennifer Chang</td>
296
						<td>Regional Director</td>
297
						<td>Singapore</td>
298
						<td>28</td>
299
						<td>2010/11/14</td>
300
						<td>$357,650</td>
301
					</tr>
302
					<tr>
303
						<td>Brenden Wagner</td>
304
						<td>Software Engineer</td>
305
						<td>San Francisco</td>
306
						<td>28</td>
307
						<td>2011/06/07</td>
308
						<td>$206,850</td>
309
					</tr>
310
					<tr>
311
						<td>Fiona Green</td>
312
						<td>Chief Operating Officer (COO)</td>
313
						<td>San Francisco</td>
314
						<td>48</td>
315
						<td>2010/03/11</td>
316
						<td>$850,000</td>
317
					</tr>
318
					<tr>
319
						<td>Shou Itou</td>
320
						<td>Regional Marketing</td>
321
						<td>Tokyo</td>
322
						<td>20</td>
323
						<td>2011/08/14</td>
324
						<td>$163,000</td>
325
					</tr>
326
					<tr>
327
						<td>Michelle House</td>
328
						<td>Integration Specialist</td>
329
						<td>Sidney</td>
330
						<td>37</td>
331
						<td>2011/06/02</td>
332
						<td>$95,400</td>
333
					</tr>
334
					<tr>
335
						<td>Suki Burks</td>
336
						<td>Developer</td>
337
						<td>London</td>
338
						<td>53</td>
339
						<td>2009/10/22</td>
340
						<td>$114,500</td>
341
					</tr>
342
					<tr>
343
						<td>Prescott Bartlett</td>
344
						<td>Technical Author</td>
345
						<td>London</td>
346
						<td>27</td>
347
						<td>2011/05/07</td>
348
						<td>$145,000</td>
349
					</tr>
350
					<tr>
351
						<td>Gavin Cortez</td>
352
						<td>Team Leader</td>
353
						<td>San Francisco</td>
354
						<td>22</td>
355
						<td>2008/10/26</td>
356
						<td>$235,500</td>
357
					</tr>
358
					<tr>
359
						<td>Martena Mccray</td>
360
						<td>Post-Sales support</td>
361
						<td>Edinburgh</td>
362
						<td>46</td>
363
						<td>2011/03/09</td>
364
						<td>$324,050</td>
365
					</tr>
366
					<tr>
367
						<td>Unity Butler</td>
368
						<td>Marketing Designer</td>
369
						<td>San Francisco</td>
370
						<td>47</td>
371
						<td>2009/12/09</td>
372
						<td>$85,675</td>
373
					</tr>
374
					<tr>
375
						<td>Howard Hatfield</td>
376
						<td>Office Manager</td>
377
						<td>San Francisco</td>
378
						<td>51</td>
379
						<td>2008/12/16</td>
380
						<td>$164,500</td>
381
					</tr>
382
					<tr>
383
						<td>Hope Fuentes</td>
384
						<td>Secretary</td>
385
						<td>San Francisco</td>
386
						<td>41</td>
387
						<td>2010/02/12</td>
388
						<td>$109,850</td>
389
					</tr>
390
					<tr>
391
						<td>Vivian Harrell</td>
392
						<td>Financial Controller</td>
393
						<td>San Francisco</td>
394
						<td>62</td>
395
						<td>2009/02/14</td>
396
						<td>$452,500</td>
397
					</tr>
398
					<tr>
399
						<td>Timothy Mooney</td>
400
						<td>Office Manager</td>
401
						<td>London</td>
402
						<td>37</td>
403
						<td>2008/12/11</td>
404
						<td>$136,200</td>
405
					</tr>
406
					<tr>
407
						<td>Jackson Bradshaw</td>
408
						<td>Director</td>
409
						<td>New York</td>
410
						<td>65</td>
411
						<td>2008/09/26</td>
412
						<td>$645,750</td>
413
					</tr>
414
					<tr>
415
						<td>Olivia Liang</td>
416
						<td>Support Engineer</td>
417
						<td>Singapore</td>
418
						<td>64</td>
419
						<td>2011/02/03</td>
420
						<td>$234,500</td>
421
					</tr>
422
					<tr>
423
						<td>Bruno Nash</td>
424
						<td>Software Engineer</td>
425
						<td>London</td>
426
						<td>38</td>
427
						<td>2011/05/03</td>
428
						<td>$163,500</td>
429
					</tr>
430
					<tr>
431
						<td>Sakura Yamamoto</td>
432
						<td>Support Engineer</td>
433
						<td>Tokyo</td>
434
						<td>37</td>
435
						<td>2009/08/19</td>
436
						<td>$139,575</td>
437
					</tr>
438
					<tr>
439
						<td>Thor Walton</td>
440
						<td>Developer</td>
441
						<td>New York</td>
442
						<td>61</td>
443
						<td>2013/08/11</td>
444
						<td>$98,540</td>
445
					</tr>
446
					<tr>
447
						<td>Finn Camacho</td>
448
						<td>Support Engineer</td>
449
						<td>San Francisco</td>
450
						<td>47</td>
451
						<td>2009/07/07</td>
452
						<td>$87,500</td>
453
					</tr>
454
					<tr>
455
						<td>Serge Baldwin</td>
456
						<td>Data Coordinator</td>
457
						<td>Singapore</td>
458
						<td>64</td>
459
						<td>2012/04/09</td>
460
						<td>$138,575</td>
461
					</tr>
462
					<tr>
463
						<td>Zenaida Frank</td>
464
						<td>Software Engineer</td>
465
						<td>New York</td>
466
						<td>63</td>
467
						<td>2010/01/04</td>
468
						<td>$125,250</td>
469
					</tr>
470
					<tr>
471
						<td>Zorita Serrano</td>
472
						<td>Software Engineer</td>
473
						<td>San Francisco</td>
474
						<td>56</td>
475
						<td>2012/06/01</td>
476
						<td>$115,000</td>
477
					</tr>
478
					<tr>
479
						<td>Jennifer Acosta</td>
480
						<td>Junior Javascript Developer</td>
481
						<td>Edinburgh</td>
482
						<td>43</td>
483
						<td>2013/02/01</td>
484
						<td>$75,650</td>
485
					</tr>
486
					<tr>
487
						<td>Cara Stevens</td>
488
						<td>Sales Assistant</td>
489
						<td>New York</td>
490
						<td>46</td>
491
						<td>2011/12/06</td>
492
						<td>$145,600</td>
493
					</tr>
494
					<tr>
495
						<td>Hermione Butler</td>
496
						<td>Regional Director</td>
497
						<td>London</td>
498
						<td>47</td>
499
						<td>2011/03/21</td>
500
						<td>$356,250</td>
501
					</tr>
502
					<tr>
503
						<td>Lael Greer</td>
504
						<td>Systems Administrator</td>
505
						<td>London</td>
506
						<td>21</td>
507
						<td>2009/02/27</td>
508
						<td>$103,500</td>
509
					</tr>
510
					<tr>
511
						<td>Jonas Alexander</td>
512
						<td>Developer</td>
513
						<td>San Francisco</td>
514
						<td>30</td>
515
						<td>2010/07/14</td>
516
						<td>$86,500</td>
517
					</tr>
518
					<tr>
519
						<td>Shad Decker</td>
520
						<td>Regional Director</td>
521
						<td>Edinburgh</td>
522
						<td>51</td>
523
						<td>2008/11/13</td>
524
						<td>$183,000</td>
525
					</tr>
526
					<tr>
527
						<td>Michael Bruce</td>
528
						<td>Javascript Developer</td>
529
						<td>Singapore</td>
530
						<td>29</td>
531
						<td>2011/06/27</td>
532
						<td>$183,000</td>
533
					</tr>
534
					<tr>
535
						<td>Donna Snider</td>
536
						<td>Customer Support</td>
537
						<td>New York</td>
538
						<td>27</td>
539
						<td>2011/01/25</td>
540
						<td>$112,000</td>
541
					</tr>
542
				</tbody>
543
			</table>
544

    
545
			<ul class="tabs">
546
				<li class="active">Javascript</li>
547
				<li>HTML</li>
548
				<li>CSS</li>
549
				<li>Ajax</li>
550
				<li>Server-side script</li>
551
			</ul>
552

    
553
			<div class="tabs">
554
				<div class="js">
555
					<p>The Javascript shown below is used to initialise the table shown in this
556
					example:</p><code class="multiline brush: js;">$(document).ready(function() {
557
    // Setup - add a text input to each footer cell
558
    $('#example tfoot th').each( function () {
559
        var title = $('#example thead th').eq( $(this).index() ).text();
560
        $(this).html( '&lt;input type=&quot;text&quot; placeholder=&quot;Search '+title+'&quot; /&gt;' );
561
    } );
562
 
563
    // DataTable
564
    var table = $('#example').DataTable( {
565
		dom: 'Rlfrtip'
566
	} );
567
     
568
    // Apply the filter
569
    $(&quot;#example tfoot input&quot;).on( 'keyup change', function () {
570
        table
571
            .column( $(this).parent().index()+':visible' )
572
            .search( this.value )
573
            .draw();
574
    } );
575
} );</code>
576

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

    
580
					<ul>
581
						<li><a href="../../../media/js/jquery.js">../../../media/js/jquery.js</a></li>
582
						<li><a href=
583
						"../../../media/js/jquery.dataTables.js">../../../media/js/jquery.dataTables.js</a></li>
584
						<li><a href="../js/dataTables.colReorder.js">../js/dataTables.colReorder.js</a></li>
585
					</ul>
586
				</div>
587

    
588
				<div class="table">
589
					<p>The HTML shown below is the raw HTML table element, before it has been enhanced by
590
					DataTables:</p>
591
				</div>
592

    
593
				<div class="css">
594
					<div>
595
						<p>This example uses a little bit of additional CSS beyond what is loaded from the library
596
						files (below), in order to correctly display the table. The additional CSS used is shown
597
						below:</p><code class="multiline brush: js;"></code>
598
					</div>
599

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

    
603
					<ul>
604
						<li><a href=
605
						"../../../media/css/jquery.dataTables.css">../../../media/css/jquery.dataTables.css</a></li>
606
						<li><a href="../css/dataTables.colReorder.css">../css/dataTables.colReorder.css</a></li>
607
					</ul>
608
				</div>
609

    
610
				<div class="ajax">
611
					<p>This table loads data by Ajax. The latest data that has been loaded is shown below. This data
612
					will update automatically as any additional data is loaded.</p>
613
				</div>
614

    
615
				<div class="php">
616
					<p>The script used to perform the server-side processing for this table is shown below. Please note
617
					that this is just an example script using PHP. Server-side processing scripts can be written in any
618
					language, using <a href="//datatables.net/manual/server-side">the protocol described in the
619
					DataTables documentation</a>.</p>
620
				</div>
621
			</div>
622
		</section>
623
	</div>
624

    
625
	<section>
626
		<div class="footer">
627
			<div class="gradient"></div>
628

    
629
			<div class="liner">
630
				<h2>Other examples</h2>
631

    
632
				<div class="toc">
633
					<div class="toc-group">
634
						<h3><a href="./index.html">Examples</a></h3>
635
						<ul class="toc active">
636
							<li><a href="./simple.html">Basic initialisation</a></li>
637
							<li><a href="./new_init.html">Initialisation using `new`</a></li>
638
							<li><a href="./alt_insert.html">Alternative insert styling</a></li>
639
							<li><a href="./realtime.html">Realtime updating</a></li>
640
							<li><a href="./state_save.html">State saving</a></li>
641
							<li><a href="./scrolling.html">Scrolling table</a></li>
642
							<li><a href="./predefined.html">Predefined column ordering</a></li>
643
							<li><a href="./reset.html">Reset ordering API</a></li>
644
							<li><a href="./colvis.html">ColVis integration</a></li>
645
							<li><a href="./fixedcolumns.html">FixedColumns integration</a></li>
646
							<li><a href="./fixedheader.html">FixedHeader integration</a></li>
647
							<li><a href="./jqueryui.html">jQuery UI styling</a></li>
648
							<li class="active"><a href="./col_filter.html">Individual column filtering</a></li>
649
							<li><a href="./server_side.html">Server-side processing</a></li>
650
						</ul>
651
					</div>
652
				</div>
653

    
654
				<div class="epilogue">
655
					<p>Please refer to the <a href="http://www.datatables.net">DataTables documentation</a> for full
656
					information about its API properties and methods.<br>
657
					Additionally, there are a wide range of <a href="http://www.datatables.net/extras">extras</a> and
658
					<a href="http://www.datatables.net/plug-ins">plug-ins</a> which extend the capabilities of
659
					DataTables.</p>
660

    
661
					<p class="copyright">DataTables designed and created by <a href=
662
					"http://www.sprymedia.co.uk">SpryMedia Ltd</a> &#169; 2007-2014<br>
663
					DataTables is licensed under the <a href="http://www.datatables.net/mit">MIT license</a>.</p>
664
				</div>
665
			</div>
666
		</div>
667
	</section>
668
</body>
669
</html>
(2-2/15)