File: example-child-rows-filtered.html

package info (click to toggle)
jquery-tablesorter 1%3A2.31.3%2Bdfsg1-3
links: PTS, VCS
area: main
in suites: bookworm
size: 5,056 kB
sloc: javascript: 19,495; sh: 14; makefile: 8
file content (634 lines) | stat: -rw-r--r-- 52,544 bytes
parent folder | download | duplicates (4)
<!DOCTYPE html>
<html>
<head>
	<meta charset="utf-8">
	<title>jQuery tablesorter 2.0 - Child Rows with Filter Widget</title>

	<!-- jQuery -->
	<script src="js/jquery-latest.min.js"></script>

	<!-- Demo stuff -->
	<link rel="stylesheet" href="css/jq.css">
	<link href="css/prettify.css" rel="stylesheet">
	<script src="js/prettify.js"></script>
	<script src="js/docs.js"></script>

	<!-- Tablesorter: required -->
	<link rel="stylesheet" href="../css/theme.blue.css">
	<script src="../js/jquery.tablesorter.js"></script>
	<!-- <script src="../js/jquery.tablesorter.widgets.js"></script> -->
	<script src="../js/widgets/widget-storage.js"></script>
	<script src="../js/widgets/widget-filter.js"></script>

	<!-- Tablesorter: pager -->
	<link rel="stylesheet" href="../addons/pager/jquery.tablesorter.pager.css">
	<script src="../js/widgets/widget-pager.js"></script>

	<style id="css">/* use class names to hide content for jQuery v3.0 - see https://github.com/jquery/jquery/issues/2308 */
.hidden { display: none; }

/* override child row hovering defined in the theme file */
#table2 tbody > tr.even.hover > td,
#table2 tbody > tr.even:hover > td,
#table2 tbody > tr.even:hover + tr.tablesorter-childRow > td,
#table2 tbody > tr.even:hover + tr.tablesorter-childRow + tr.tablesorter-childRow > td {
	background-color: #fff;
}
#table2 tbody > tr.odd.hover > td,
#table2 tbody > tr.odd:hover > td,
#table2 tbody > tr.odd:hover + tr.tablesorter-childRow > td,
#table2 tbody > tr.odd:hover + tr.tablesorter-childRow + tr.tablesorter-childRow > td {
	background-color: #ebf2fa;
}
#table2 tbody > tr.even:hover > td,
#table2 tbody > tr.odd:hover > td {
	background-color: #d9d9d9;
}
</style>

	<script id="js">$( function() {

	var $table1 = $( '#table1' )
		.tablesorter({
			theme : 'blue',
			// this is the default setting
			cssChildRow : "tablesorter-childRow",

			// initialize zebra and filter widgets
			widgets : [ "zebra", "filter", "pager" ],

			widgetOptions: {
				// output default: '{page}/{totalPages}'
				// possible variables: {page}, {totalPages}, {filteredPages}, {startRow}, {endRow}, {filteredRows} and {totalRows}
				pager_output: '{startRow} - {endRow} / {filteredRows} ({totalRows})',

				pager_removeRows: false,

				// include child row content while filtering, if true
				filter_childRows  : true,
				// class name applied to filter row and each input
				filter_cssFilter  : 'tablesorter-filter',
				// search from beginning
				filter_startsWith : false,
				// Set this option to false to make the searches case sensitive
				filter_ignoreCase : true
			}

		});

	// hide child rows - get in the habit of not using .hide()
	// See http://jsfiddle.net/Mottie/u507846y/ & https://github.com/jquery/jquery/issues/1767
	// and https://github.com/jquery/jquery/issues/2308
	// This won't be a problem in jQuery v3.0+
	$table1.find( '.tablesorter-childRow td' ).addClass( 'hidden' );

	// Toggle child row content (td), not hiding the row since we are using rowspan
	// Using delegate because the pager plugin rebuilds the table after each page change
	// "delegate" works in jQuery 1.4.2+; use "live" back to v1.3; for older jQuery - SOL
	$table1.delegate( '.toggle', 'click' ,function() {
		// use "nextUntil" to toggle multiple child rows
		// toggle table cells instead of the row
		$( this )
			.closest( 'tr' )
			.nextUntil( 'tr.tablesorter-hasChildRow' )
			.find( 'td' )
			.toggleClass( 'hidden' );
		return false;
	});

	// Toggle filter_childRows option
	$( 'button.toggle-combined' ).click( function() {
		var wo = $table1[0].config.widgetOptions,
		o = !wo.filter_childRows;
		wo.filter_childRows = o;
		$( '.state1' ).html( o.toString() );
		// update filter; include false parameter to force a new search
		$table1.trigger( 'search', false );
		return false;
	});

});</script>
<script id="js2">$(function() {

	var $table2 = $( '#table2' )
		.tablesorter({
			theme : 'blue',
			// this is the default setting
			cssChildRow : 'tablesorter-childRow',
			// initialize zebra and filter widgets
			widgets : [ 'zebra', 'filter' ],
			widgetOptions : {
				// include child row content while filtering, if true
				filter_childRows : true,
				// filter child row content by column; filter_childRows must also be true
				filter_childByColumn : true,
				// class name applied to filter row and each input
				filter_cssFilter : 'tablesorter-filter',
				// Set this option to false to make the searches case sensitive
				filter_ignoreCase : true,
				filter_reset: '.reset'
			}
		});

	// hide child rows - don't use .hide() because filtered rows get a "filtered" class
	// added to them, and style="display: table-row;" will override this class
	// See http://jsfiddle.net/Mottie/u507846y/ & https://github.com/jquery/jquery/issues/1767
	// and https://github.com/jquery/jquery/issues/2308
	// This won't be a problem in jQuery v3.0+
	$table2.find( '.tablesorter-childRow' ).addClass( 'hidden' );

	// Toggle child row content (td), not hiding the row since we are using rowspan
	// Using delegate because the pager plugin rebuilds the table after each page change
	// "delegate" works in jQuery 1.4.2+; use "live" back to v1.3; for older jQuery - SOL
	$table2.delegate( '.toggle', 'click' ,function() {
		// use "nextUntil" to toggle multiple child rows
		// toggle table cells instead of the row
		$( this )
			.closest( 'tr' )
			.nextUntil( 'tr.tablesorter-hasChildRow' )
			.toggleClass( 'hidden' );
		return false;
	});

	// Toggle filter_childByColumn option
	$( 'button.toggle-byColumn' ).click(function() {
		var wo = $table2[0].config.widgetOptions,
		o = !wo.filter_childByColumn;
		wo.filter_childByColumn = o;
		$('.state2').html( o.toString() );
		// update filter; include false parameter to force a new search
		$table2.trigger('search', false);
		return false;
	});

	// make demo search buttons work
	$( 'button[data-column]' ).on( 'click', function() {
		var $this = $( this ),
			totalColumns = $table2[0].config.columns,
			col = $this.data( 'column' ), // zero-based index or "all"
			filter = [];

		// text to add to filter
		filter[ col === 'all' ? totalColumns : col ] = $this.text();
		$table2.trigger( 'search', [ filter ] );
		return false;
	});

});</script>
</head>
<body>

<div id="banner">
	<h1>table<em>sorter</em></h1>
	<h2>Child Rows with Filter Widget</h2>
	<h3>Flexible client-side table sorting</h3>
	<a href="index.html">Back to documentation</a>
</div>

<div id="main">

	<div class="tip">
		<p><em>NOTE!</em></p>
		<ul>
			<li><span class="version">v2.22.0</span>,
				<ul>
					<li>Added <code>filter_childByColumn</code> to allow filtering to work on child row columns. See the <a href="#child-by-column">By Column</a> demo below.</li>
					<li>Extra white-space was added after each line in the child row content to account for the loss of white-space which occurs while processing cell content using <code>textContent</code>.</li>
					<li><span class="label warning">*NOTE*</span> Start getting in the habit of using a class name to hide content as <strong>jQuery 3.0+ will likely change how <code>show()</code> &amp; <code>hide()</code> work</strong> (<a href="https://github.com/jquery/jquery/issues/2308">ref</a>).</li>
				</ul>
				<p></p>
			</li>
			<li>As of <span class="version updated">v2.15.12</span>,
				<ul>
					<li>This demo includes the pager widget.</li>
					<li>Parents of child rows now have a <code>tablesorter-hasChildRow</code> class name added.</li>
					<li>The last row of each page now includes any child rows. For example, on page 1, click on the "SO71783" row link and the associated child row will now show, as it should</li>
					<li><span class="label label-info">NOTE!</span> A new css definition was added to every default theme; the "filtered" class name (set by the <code>filter_filteredRow</code> widgetOption) has been added to properly hide/show child rows when filtered.</li>
					<li>The additional code to always hide child row cells on <code>pagerChange</code> is no longer needed.</li>
				</ul>
			</li>
			<li>Click the link in the Order # column to reveal the hidden child row cells (<a href="http://www.pengoworks.com/workshop/jquery/tablesorter/tablesorter.htm">original demo</a>). This option is available in the original plugin.</li>
			<li>The filter widget will <strong>NOT work</strong> with the original tablesorter plugin.</li>
		</ul>
	</div>

	<h1>Demo</h1>
	Filter Child Row: <a href="#combined">Combined/Disabled</a> | <a href="#child-by-column">By Column</a>
	<p></p>
	<h3 id="combined">Combined Child Row Content</h3>
	<button type="button" class="toggle-combined">Toggle</button> <code>filter_childRows</code> : <span class="state1">true</span>

	<ul>
		<li>If true, the child row content is included in ALL filters. Enter "cali" (california) in any column filter and the same rows show up.</li>
		<li>When false, child row content is ignored. Enter "cali" and no rows will be found.</li>
	</ul>

	<div class="pager">
		<img src="../addons/pager/icons/first.png" class="first" alt="First" />
		<img src="../addons/pager/icons/prev.png" class="prev" alt="Prev" />
		<span class="pagedisplay"></span> <!-- this can be any element, including an input -->
		<img src="../addons/pager/icons/next.png" class="next" alt="Next" />
		<img src="../addons/pager/icons/last.png" class="last" alt="Last" />
		<select class="pagesize" title="Select page size">
			<option value="10">10</option>
			<option value="20">20</option>
			<option value="30">30</option>
			<option value="40">40</option>
		</select>
		<select class="gotoPage" title="Select page number"></select>
	</div>

	<table id="table1">
	<colgroup>
		<col width="85" />
		<col width="250" />
		<col width="100" />
		<col width="90" />
		<col width="70" />
	</colgroup>
	<thead>
		<tr>
			<th>Order #</th>
			<th>Customer</th>
			<th>PO</th>
			<th>Date</th>
			<th>Total</th>
		</tr>
	</thead>
	<tbody>
		<!-- First row expanded to reveal the layout -->
		<tr>
			<td rowspan="2"> <!-- rowspan="2" makes the table look nicer -->
				<a href="#" class="toggle">SO71774</a> <!-- link to toggle view of the child row -->
			</td>
			<td>Good Toys</td>
			<td>PO348186287</td>
			<td>Jul 20, 2007</td>
			<td>$972.78</td>
		</tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Shipping Address</div> <div>99700 Bell Road <br>Auburn, California 95603</div></td></tr>
		<tr><td rowspan="2"><a href="#" class="toggle">SO71775</a></td><td>Cycle Clearance</td><td>PO58159451</td><td>May 6, 2007</td><td>$2,313.13</td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Shipping Address</div> <div>2255 254th Avenue Se <br>Albany, Oregon 97321</div></td></tr>
		<tr><td rowspan="2"><a href="#" class="toggle">SO71776</a></td><td>West Side Mart</td><td>PO19952192051</td><td>May 12, 2007</td><td>$87.09</td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Shipping Address</div> <div>251 The Metro Center <br>Wokingham, England RG41 1QW</div></td></tr>
		<tr><td rowspan="3"><a href="#" class="toggle">SO71777</a></td><td>Demand Distributors</td><td>PO20097113391</td><td>Apr 26, 2007</td><td>$1,267.82</td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Comment</div> <div>Please send ATTN: Judy</div></td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Shipping Address</div> <div>25102 Springwater <br>Wenatchee, Washington 98801</div></td></tr>
		<tr><td rowspan="2"><a href="#" class="toggle">SO71778</a></td><td>Purchase Mart</td><td>PO19894146890</td><td>Apr 18, 2007</td><td>$1,503.98</td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Shipping Address</div> <div>Wrentham Village <br>Wrentham, Massachusetts 02093</div></td></tr>
		<tr><td rowspan="2"><a href="#" class="toggle">SO71779</a></td><td>Initial Bike Company</td><td>PO19633118218</td><td>Dec 20, 2007</td><td>$48,425.55</td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Shipping Address</div> <div>789 West Alameda <br>Westminster, Colorado 80030</div></td></tr>
		<tr><td rowspan="2"><a href="#" class="toggle">SO71780</a></td><td>Nearby Cycle Shop</td><td>PO19604173239</td><td>Aug 29, 2007</td><td>$42,452.65</td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Shipping Address</div> <div>Burgess Hill <br>Edward Way <br>West Sussex, England RH15 9UD</div></td></tr>
		<tr><td rowspan="3"><a href="#" class="toggle">SO71781</a></td><td>Sundry Sporting Goods</td><td>PO19401117806</td><td>Mar 9, 2008</td><td>$29,262.41</td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Comment</div> <div>Please send ATTN: Rudolph</div></td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Shipping Address</div> <div>595 Burning Street <br>Vancouver, British Columbia V7L 4J4</div></td></tr>
		<tr><td rowspan="2"><a href="#" class="toggle">SO71782</a></td><td>Professional Sales and Service</td><td>PO19372114749</td><td>Jul 27, 2007</td><td>$43,962.79</td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Shipping Address</div> <div>57251 Serene Blvd <br>Van Nuys, California 91411</div></td></tr>
		<tr><td rowspan="2"><a href="#" class="toggle">SO71783</a></td><td>Eastside Department Store</td><td>PO19343113609</td><td>May 15, 2007</td><td>$92,663.56</td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Shipping Address</div> <div>9992 Whipple Rd <br>Union City, California 94587</div></td></tr>
		<tr><td rowspan="2"><a href="#" class="toggle">SO71784</a></td><td>Action Bicycle Specialists</td><td>PO19285135919</td><td>Nov 30, 2007</td><td>$119,960.82</td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Shipping Address</div> <div>Warrington Ldc Unit 25/2 <br>Woolston, England WA1 4SY</div></td></tr>
		<tr><td rowspan="3"><a href="#" class="toggle">SO71785</a></td><td>Metro Cycle Shop</td><td>PO19169115427</td><td>Feb 1, 2008</td><td>$39,805.12</td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Comment</div> <div>Please send ATTN: Henry</div></td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Shipping Address</div> <div>2507 Pacific Ave S <br>Tacoma, Washington 98403</div></td></tr>
		<tr><td rowspan="2"><a href="#" class="toggle">SO71786</a></td><td>Greater Bike Store</td><td>PO17690128583</td><td>Dec 7, 2007</td><td>$4,657.19</td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Shipping Address</div> <div>55 Lakeshore Blvd East <br>Toronto, Ontario M4B 1V6</div></td></tr>
		<tr><td rowspan="2"><a href="#" class="toggle">SO71787</a></td><td>Fun Toys and Bikes</td><td>PO18038111279</td><td>Jun 1, 2007</td><td>$38,211.11</td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Shipping Address</div> <div>6500 East Grant Road <br>Tucson, Arizona 85701</div></td></tr>
		<tr><td rowspan="2"><a href="#" class="toggle">SO71788</a></td><td>Reliable Retail Center</td><td>PO17951176595</td><td>Jul 10, 2007</td><td>$1,806.12</td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Shipping Address</div> <div>609 Evans Avenue <br>Toronto, Ontario M4B 1V4</div></td></tr>
		<tr><td rowspan="3"><a href="#" class="toggle">SO71789</a></td><td>Eastside Parts Shop</td><td>PO17516128941</td><td>May 22, 2007</td><td>$143.50</td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Comment</div> <div>Please send ATTN: Andrew</div></td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Shipping Address</div> <div>7000 Victoria Park Avenue <br>Toronto, Ontario M4B 1V4</div></td></tr>
		<tr><td rowspan="2"><a href="#" class="toggle">SO71790</a></td><td>Successful Sales Company</td><td>PO17487184338</td><td>Apr 15, 2007</td><td>$5,306.48</td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Shipping Address</div> <div>7009 Sw Hall Blvd. <br>Tigard, Oregon 97223</div></td></tr>
		<tr><td rowspan="2"><a href="#" class="toggle">SO71791</a></td><td>Convenient Sales and Service</td><td>PO17139191080</td><td>Nov 14, 2007</td><td>$26,692.85</td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Shipping Address</div> <div>950 Gateway Street <br>Springfield, Oregon 97477</div></td></tr>
		<tr><td rowspan="2"><a href="#" class="toggle">SO71792</a></td><td>Corner Bicycle Supply</td><td>PO17545115036</td><td>Mar 17, 2008</td><td>$67,683.32</td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Shipping Address</div> <div>2511 Baker Road <br>Toronto, Ontario M4B 1V7</div></td></tr>
		<tr><td rowspan="3"><a href="#" class="toggle">SO71793</a></td><td>Mountain Toy Store</td><td>PO17226152414</td><td>Sep 5, 2007</td><td>$1,943.93</td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Comment</div> <div>Please send ATTN: Marvin</div></td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Shipping Address</div> <div>First Colony Mall <br>Sugar Land, Texas 77478</div></td></tr>
		<tr><td rowspan="2"><a href="#" class="toggle">SO71794</a></td><td>Vigorous Exercise Company</td><td>PO17574111985</td><td>Dec 14, 2007</td><td>$87,770.74</td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Shipping Address</div> <div>9950 Ferrand Drive, 9th Floor <br>Toronto, Ontario M4B 1V4</div></td></tr>
		<tr><td rowspan="2"><a href="#" class="toggle">SO71795</a></td><td>Bike Part Wholesalers</td><td>PO17371184627</td><td>Feb 6, 2008</td><td>$41,224.10</td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Shipping Address</div> <div>254a Baker Street <br>Botany <br>Sydney, New South Wales 1002</div></td></tr>
		<tr><td rowspan="2"><a href="#" class="toggle">SO71796</a></td><td>Extreme Riding Supplies</td><td>PO17052159664</td><td>Jul 13, 2007</td><td>$63,686.27</td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Shipping Address</div> <div>Riverside <br>Sherman Oaks, California 91403</div></td></tr>
		<tr><td rowspan="3"><a href="#" class="toggle">SO71797</a></td><td>Riding Cycles</td><td>PO16501134889</td><td>Dec 2, 2007</td><td>$86,222.81</td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Comment</div> <div>Please send ATTN: Jon</div></td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Shipping Address</div> <div>Galashiels <br>Liverpool, England L4 4HB</div></td></tr>
		<tr><td rowspan="2"><a href="#" class="toggle">SO71798</a></td><td>Work and Play Association</td><td>PO16994135863</td><td>Jan 20, 2008</td><td>$40,048.63</td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Shipping Address</div> <div>2533 Eureka Rd. <br>Southgate, Michigan 48195</div></td></tr>
		<tr><td rowspan="2"><a href="#" class="toggle">SO71799</a></td><td>Metro Sports Equipment</td><td>PO15486196616</td><td>Oct 18, 2007</td><td>$23,080.67</td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Shipping Address</div> <div>6, rue des Pyrenees <br>Saint Ouen, Loir et Cher 41100</div></td></tr>
		<tr><td rowspan="2"><a href="#" class="toggle">SO71800</a></td><td>Quick Parts and Service</td><td>PO15544127760</td><td>Feb 19, 2008</td><td>$37,253.44</td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Shipping Address</div> <div>99954 Boul. Laurier, Local 060, Place <br>Sainte-Foy, Quebec G1W</div></td></tr>
		<tr><td rowspan="3"><a href="#" class="toggle">SO71801</a></td><td>Getaway Inn</td><td>PO15515173664</td><td>Mar 6, 2008</td><td>$47,720.54</td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Comment</div> <div>Please send ATTN: Min</div></td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Shipping Address</div> <div>54, avenue des Ternes <br>Saint Ouen, Loir et Cher 41100</div></td></tr>
		<tr><td rowspan="2"><a href="#" class="toggle">SO71802</a></td><td>Blue-Ribbon Bike Company</td><td>PO15457184141</td><td>Sep 22, 2007</td><td>$42,013.42</td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Shipping Address</div> <div>790 Shelbyville Road <br>Saint Matthews, Kentucky 40207</div></td></tr>
		<tr><td rowspan="2"><a href="#" class="toggle">SO71803</a></td><td>World of Bikes</td><td>PO15341174104</td><td>Mar 1, 2008</td><td>$43,964.97</td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Shipping Address</div> <div>660 Lindbergh <br>Saint Louis, Missouri 63103</div></td></tr>
		<tr><td rowspan="2"><a href="#" class="toggle">SO71804</a></td><td>Bikes for Two</td><td>PO14906114459</td><td>Aug 18, 2007</td><td>$2,431.21</td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Shipping Address</div> <div>63 West Beaver Creek <br>Richmond Hill, Ontario L4E 3M5</div></td></tr>
		<tr><td rowspan="3"><a href="#" class="toggle">SO71805</a></td><td>Nationwide Supply</td><td>PO14703194514</td><td>Jun 27, 2007</td><td>$76,535.55</td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Comment</div> <div>Please send ATTN: Pilar</div></td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Shipping Address</div> <div>4250 Concord Road <br>Rhodes, New South Wales 2138</div></td></tr>
		<tr><td rowspan="2"><a href="#" class="toggle">SO71806</a></td><td>Valley Toy Store</td><td>PO14790111844</td><td>Jun 2, 2007</td><td>$20,261.90</td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Shipping Address</div> <div>252851 Rowan Place <br>Richmond, British Columbia V6B 3P7</div></td></tr>
		<tr><td rowspan="2"><a href="#" class="toggle">SO71807</a></td><td>Courteous Bicycle Specialists</td><td>PO14935135211</td><td>Oct 28, 2007</td><td>$656.84</td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Shipping Address</div> <div>995 Crescent <br>Richmond Hill, Ontario L4E 3M5</div></td></tr>
		<tr><td rowspan="2"><a href="#" class="toggle">SO71808</a></td><td>Odometers and Accessories Company</td><td>PO14761198562</td><td>Oct 28, 2007</td><td>$42,231.51</td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Shipping Address</div> <div>253711 Mayfield Place, Unit 150 <br>Richmond, British Columbia V6B 3P7</div></td></tr>
		<tr><td rowspan="3"><a href="#" class="toggle">SO71809</a></td><td>Fitness Bike Accessories</td><td>PO14645153239</td><td>Jan 12, 2008</td><td>$3,743.42</td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Comment</div> <div>Please send ATTN: John</div></td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Shipping Address</div> <div>Level 7 <br>114 Albert Road <br>Rhodes, New South Wales 2138</div></td></tr>
		<tr><td rowspan="2"><a href="#" class="toggle">SO71810</a></td><td>Two-Seater Bikes</td><td>PO13804148315</td><td>May 27, 2007</td><td>$1,093.53</td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Shipping Address</div> <div>5700 Legacy Dr <br>Plano, Texas 75074</div></td></tr>
		<tr><td rowspan="2"><a href="#" class="toggle">SO71811</a></td><td>Racing Toys</td><td>PO13717180066</td><td>Feb 26, 2008</td><td>$3,493.04</td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Shipping Address</div> <div>9228 Via Del Sol <br>Phoenix, Arizona 85004</div></td></tr>
		<tr><td rowspan="2"><a href="#" class="toggle">SO71812</a></td><td>Fashionable Bikes and Accessories</td><td>PO13543115747</td><td>Apr 28, 2007</td><td>$35,146.04</td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Shipping Address</div> <div>Sports Store At Park City <br>Park City, Utah 84098</div></td></tr>
		<tr><td rowspan="3"><a href="#" class="toggle">SO71813</a></td><td>Liquidation Sales</td><td>PO13630186295</td><td>Jan 17, 2008</td><td>$12,707.47</td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Comment</div> <div>Please send ATTN: Jenny</div></td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Shipping Address</div> <div>No. 6 <br>Millenium Court <br>Perth, South Australia 6006</div></td></tr>
		<tr><td rowspan="2"><a href="#" class="toggle">SO71814</a></td><td>Our Sporting Goods Store</td><td>PO12818173864</td><td>May 31, 2007</td><td>$7,517.54</td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Shipping Address</div> <div>6030 Conroy Road <br>Ottawa, Ontario K4B 1S3</div></td></tr>
		<tr><td rowspan="2"><a href="#" class="toggle">SO71815</a></td><td>Thrifty Parts and Sales</td><td>PO13021155785</td><td>Jan 1, 2008</td><td>$1,261.44</td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Shipping Address</div> <div>Oxnard Outlet <br>Oxnard, California 93030</div></td></tr>
		<tr><td rowspan="2"><a href="#" class="toggle">SO71816</a></td><td>Engineered Bike Systems</td><td>PO12992180445</td><td>Jul 29, 2007</td><td>$3,754.97</td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Shipping Address</div> <div>123 Camelia Avenue <br>Oxnard, California 93030</div></td></tr>
		<tr><td rowspan="3"><a href="#" class="toggle">SO71817</a></td><td>Home Town Bike Store</td><td>PO12905185178</td><td>May 21, 2007</td><td>$689.96</td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Comment</div> <div>Please send ATTN: Danielle</div></td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Shipping Address</div> <div>955 Green Valley Crescent <br>Ottawa, Ontario K4B 1S1</div></td></tr>
		<tr><td rowspan="2"><a href="#" class="toggle">SO71818</a></td><td>Utilitarian Sporting Goods</td><td>PO12470139718</td><td>Apr 25, 2007</td><td>$61,356.31</td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Shipping Address</div> <div>4635 S. Harrison Blvd. <br>Ogden, Utah 84401</div></td></tr>
		<tr><td rowspan="2"><a href="#" class="toggle">SO71819</a></td><td>Fabrikam Inc., West</td><td>PO12354153257</td><td>May 19, 2007</td><td>$41,746.15</td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Shipping Address</div> <div>46460 West Oaks Drive <br>Novi, Michigan 48375</div></td></tr>
		<tr><td rowspan="2"><a href="#" class="toggle">SO71820</a></td><td>Racing Sales and Service</td><td>PO12673129941</td><td>Apr 26, 2007</td><td>$68,686.02</td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Shipping Address</div> <div>510, avenue de Villiers <br>Orleans, Loiret 45000</div></td></tr>
		<tr><td rowspan="3"><a href="#" class="toggle">SO71821</a></td><td>Bike Goods </td><td>PO11977190694</td><td>May 25, 2007</td><td>$5,904.88</td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Comment</div> <div>Please send ATTN: Gary</div></td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Shipping Address</div> <div>254075 Biscayne Blvd. <br>North Miami Beach, Florida 33162</div></td></tr>
		<tr><td rowspan="2"><a href="#" class="toggle">SO71822</a></td><td>Popular Bike Lines</td><td>PO11774139099</td><td>Dec 19, 2007</td><td>$31,191.60</td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Shipping Address</div> <div>Level 7 <br>80 Arthur Street <br>Newcastle, New South Wales 2300</div></td></tr>
		<tr><td rowspan="2"><a href="#" class="toggle">SO71823</a></td><td>Enterprise Center</td><td>PO11310159994</td><td>Sep 7, 2007</td><td>$2,818.81</td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Shipping Address</div> <div>Kurfürstenstr 574 <br>München, Hessen 80074</div></td></tr>
		<tr><td rowspan="2"><a href="#" class="toggle">SO71824</a></td><td>Outdoor Equipment Store</td><td>PO11455162600</td><td>Oct 29, 2007</td><td>$115,117.41</td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Shipping Address</div> <div>6 Cotton Road <br>Nashua, New Hampshire 03064</div></td></tr>
		<tr><td rowspan="3"><a href="#" class="toggle">SO71825</a></td><td>One Bike Company</td><td>PO11165197222</td><td>Dec 28, 2007</td><td>$4,824.62</td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Comment</div> <div>Please send ATTN: Shanay</div></td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Shipping Address</div> <div>5 place Ville-Marie <br>Montreal, Quebec H1Y 2H7</div></td></tr>
		<tr><td rowspan="2"><a href="#" class="toggle">SO71826</a></td><td>Rodeway Bike Store</td><td>PO11397155355</td><td>Oct 29, 2007</td><td>$40,083.06</td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Shipping Address</div> <div>Winterfeldtstr 5557 <br>Kreditorenbuchhaltung <br>Münster, Saarland 48001</div></td></tr>
		<tr><td rowspan="2"><a href="#" class="toggle">SO71827</a></td><td>Metal Processing Company</td><td>PO11107195325</td><td>Aug 22, 2007</td><td>$9,247.52</td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Shipping Address</div> <div>770 Notre Datme Quest Bureau 800 <br>Montreal, Quebec H1Y 2H7</div></td></tr>
		<tr><td rowspan="2"><a href="#" class="toggle">SO71828</a></td><td>Grand Industries</td><td>PO11194153355</td><td>Aug 10, 2007</td><td>$52,553.87</td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Shipping Address</div> <div>6333 Cote Vertu <br>Montreal, Quebec H1Y 2H7</div></td></tr>
		<tr><td rowspan="3"><a href="#" class="toggle">SO71829</a></td><td>Family Cycle Store</td><td>PO10962123279</td><td>Jul 16, 2007</td><td>$40,095.88</td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Comment</div> <div>Please send ATTN: James</div></td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Shipping Address</div> <div>660 Saint-Jacques, Bureau 400 <br>Montreal, Quebec H1Y 2H8</div></td></tr>
		<tr><td rowspan="2"><a href="#" class="toggle">SO71830</a></td><td>Petroleum Products Distributors</td><td>PO10875112195</td><td>Nov 8, 2007</td><td>$55,088.00</td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Shipping Address</div> <div>20225 Lansing Ave <br>Montreal, Quebec H1Y 2H7</div></td></tr>
		<tr><td rowspan="2"><a href="#" class="toggle">SO71831</a></td><td>Tachometers and Accessories</td><td>PO10295111084</td><td>Aug 8, 2007</td><td>$2,228.06</td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Shipping Address</div> <div>Wymbush <br>Milton Keynes, England MK8 8DF</div></td></tr>
		<tr><td rowspan="2"><a href="#" class="toggle">SO71832</a></td><td>Closest Bicycle Store</td><td>PO10353140756</td><td>Sep 3, 2007</td><td>$39,531.61</td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Shipping Address</div> <div>Garamonde Drive, Wymbush <br>PO Box 4023 <br>Milton Keynes, England MK8 8ZD</div></td></tr>
		<tr><td rowspan="3"><a href="#" class="toggle">SO71833</a></td><td>Another Bicycle Company</td><td>PO10411123072</td><td>Jan 26, 2008</td><td>$70,377.54</td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Comment</div> <div>Please send ATTN: Stanley</div></td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Shipping Address</div> <div>567 Sw Mcloughlin Blvd <br>Milwaukie, Oregon 97222</div></td></tr>
		<tr><td rowspan="2"><a href="#" class="toggle">SO71834</a></td><td>Rustic Bike Store</td><td>PO377116268</td><td>Feb 22, 2008</td><td>$2,310.51</td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Shipping Address</div> <div>Buergermeister-ulrich-str 3000 <br>Buchhaltung <br>Augsburg, Bayern 86150</div></td></tr>
		<tr><td rowspan="2"><a href="#" class="toggle">SO71835</a></td><td>Running and Cycling Gear</td><td>PO870120974</td><td>Jun 13, 2007</td><td>$71,605.92</td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Shipping Address</div> <div>No. 60 Bellis Fair Parkway <br>Bellingham, Washington 98225</div></td></tr>
		<tr><td rowspan="2"><a href="#" class="toggle">SO71836</a></td><td>Safe Cycles Shop</td><td>PO841118259</td><td>Sep 13, 2007</td><td>$90,216.85</td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Shipping Address</div> <div>2681 Eagle Peak <br>Bellevue, Washington 98004</div></td></tr>
		<tr><td rowspan="3"><a href="#" class="toggle">SO71837</a></td><td>Riders Company</td><td>PO1624180133</td><td>Aug 24, 2007</td><td>$39,989.36</td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Comment</div> <div>Please send ATTN: Kim</div></td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Shipping Address</div> <div>Tanger Factory <br>Branch, Minnesota 55056</div></td></tr>
		<tr><td rowspan="2"><a href="#" class="toggle">SO71838</a></td><td>Cycles Sales and Repair</td><td>PO1305123041</td><td>Sep 7, 2007</td><td>$15,165.23</td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Shipping Address</div> <div>3387, rue Marbeuf <br>Bobigny, Seine Saint Denis 93000</div></td></tr>
		<tr><td rowspan="2"><a href="#" class="toggle">SO71839</a></td><td>Front Runner Bikes</td><td>PO1537119063</td><td>Jan 26, 2008</td><td>$75,173.33</td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Shipping Address</div> <div>DeSouth Square <br>Bradenton, Florida 34205</div></td></tr>
		<tr><td rowspan="2"><a href="#" class="toggle">SO71840</a></td><td>Community Department Stores</td><td>PO1450191043</td><td>Oct 2, 2007</td><td>$1,234.39</td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Shipping Address</div> <div>3639, rue des Grands Champs <br>Boulogne-sur-Mer, Pas de Calais 62200</div></td></tr>
		<tr><td rowspan="3"><a href="#" class="toggle">SO71841</a></td><td>Rural Cycle Emporium</td><td>PO1798133189</td><td>Nov 23, 2007</td><td>$112,758.77</td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Comment</div> <div>Please send ATTN: Kathleen</div></td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Shipping Address</div> <div>6388 Lake City Way <br>Burnaby, British Columbia V5A 3A6</div></td></tr>
		<tr><td rowspan="2"><a href="#" class="toggle">SO71842</a></td><td>Price-Cutter Discount Bikes</td><td>PO1740169151</td><td>Nov 22, 2007</td><td>$12.91</td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Shipping Address</div> <div>6700 Boul Taschereau <br>Brossard, Quebec J4Z 1C5</div></td></tr>
		<tr><td rowspan="2"><a href="#" class="toggle">SO71843</a></td><td>Future Bikes</td><td>PO2001122796</td><td>Jun 24, 2007</td><td>$7,775.72</td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Shipping Address</div> <div>67255 - 8th Street N.E., Suite 350 <br>Calgary, Alberta T2P 2G8</div></td></tr>
		<tr><td rowspan="2"><a href="#" class="toggle">SO71844</a></td><td>Sales and Supply Company</td><td>PO2813198985</td><td>Jun 12, 2007</td><td>$48,077.41</td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Shipping Address</div> <div>Corporate Ofc A/p <br>123 Fourth Ave <br>Chantilly, Virginia 20151</div></td></tr>
		<tr><td rowspan="3"><a href="#" class="toggle">SO71845</a></td><td>Trailblazing Sports</td><td>PO2697119362</td><td>Mar 4, 2008</td><td>$45,992.37</td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Comment</div> <div>Please send ATTN: Frank</div></td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Shipping Address</div> <div>251340 E. South St. <br>Cerritos, California 90703</div></td></tr>
		<tr><td rowspan="2"><a href="#" class="toggle">SO71846</a></td><td>Sports Store</td><td>PO2378131604</td><td>Jul 2, 2007</td><td>$2,711.41</td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Shipping Address</div> <div>Internet House, 3399 Science Park <br>Cambridge, England CB4 4BZ</div></td></tr>
		<tr><td rowspan="2"><a href="#" class="toggle">SO71847</a></td><td>Camping and Sports Store</td><td>PO18502143784</td><td>Jul 15, 2007</td><td>$119,981.15</td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Shipping Address</div> <div>400-25155 West Pender St <br>Vancouver, British Columbia V7L 4J4</div></td></tr>
		<tr><td rowspan="2"><a href="#" class="toggle">SO71848</a></td><td>Locks Company</td><td>PO18763153352</td><td>Nov 9, 2007</td><td>$16,667.88</td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Shipping Address</div> <div>70259 West Sunnyview Ave <br>Visalia, California 93291</div></td></tr>
		<tr><td rowspan="3"><a href="#" class="toggle">SO71849</a></td><td>Principal Bike Company</td><td>PO18125130930</td><td>Jan 18, 2008</td><td>$25,746.16</td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Comment</div> <div>Please send ATTN: Alvaro</div></td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Shipping Address</div> <div>Mountain Square <br>Upland, California 91786</div></td></tr>
		<tr><td rowspan="2"><a href="#" class="toggle">SO71850</a></td><td>Quitting Business Distributors</td><td>PO18241134627</td><td>Aug 28, 2007</td><td>$10,492.47</td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Shipping Address</div> <div>University Plaza <br>Tampa, Florida 33602</div></td></tr>
		<tr><td rowspan="2"><a href="#" class="toggle">SO71851</a></td><td>Rapid Bikes</td><td>PO18299133687</td><td>Jun 17, 2007</td><td>$51,104.88</td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Shipping Address</div> <div>992 St Clair Ave East <br>Toronto, Ontario M4B 1V7</div></td></tr>
		<tr><td rowspan="2"><a href="#" class="toggle">SO71852</a></td><td>Painters Bicycle Specialists</td><td>PO20213171866</td><td>Mar 24, 2008</td><td>$10,406.62</td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Shipping Address</div> <div>9975 Union St. <br>Waterbury, Connecticut 06710</div></td></tr>
		<tr><td rowspan="3"><a href="#" class="toggle">SO71853</a></td><td>Famous Bike Shop</td><td>PO18531164420</td><td>May 3, 2007</td><td>$4,578.20</td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Comment</div> <div>Please send ATTN: Jim</div></td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Shipping Address</div> <div>999 West Georgia St. <br>Vancouver, Ontario V5T 1Y9</div></td></tr>
		<tr><td rowspan="2"><a href="#" class="toggle">SO71854</a></td><td>Helpful Sales and Repair Service </td><td>PO16385143469</td><td>Nov 11, 2007</td><td>$36,819.69</td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Shipping Address</div> <div>Licensing Account <br>Seaford, Victoria 3198</div></td></tr>
		<tr><td rowspan="2"><a href="#" class="toggle">SO71855</a></td><td>Self-Contained Cycle Parts Company</td><td>PO18589189353</td><td>Jun 23, 2007</td><td>$429.62</td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Shipping Address</div> <div>12, rue des Grands Champs <br>Verrieres Le Buisson, Essonne 91370</div></td></tr>
		<tr><td rowspan="2"><a href="#" class="toggle">SO71856</a></td><td>Transport Bikes</td><td>PO16530177647</td><td>Nov 18, 2007</td><td>$665.43</td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Shipping Address</div> <div>25130 South State Street <br>Sandy, Utah 84070</div></td></tr>
		<tr><td rowspan="3"><a href="#" class="toggle">SO71857</a></td><td>First Cycle Store</td><td>PO16269151631</td><td>Jan 4, 2008</td><td>$37,400.41</td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Comment</div> <div>Please send ATTN: Mike</div></td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Shipping Address</div> <div>25250 N 90th St <br>Scottsdale, Arizona 85257</div></td></tr>
		<tr><td rowspan="2"><a href="#" class="toggle">SO71858</a></td><td>Thrilling Bike Tours</td><td>PO16153112278</td><td>Oct 6, 2007</td><td>$15,275.20</td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Shipping Address</div> <div>4660 Rodeo Road <br>Santa Fe, New Mexico 87501</div></td></tr>
		<tr><td rowspan="2"><a href="#" class="toggle">SO71859</a></td><td>Bike World</td><td>PO16182112142</td><td>Apr 11, 2007</td><td>$8,654.14</td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Shipping Address</div> <div>60025 Bollinger Canyon Road <br>San Ramon, California 94583</div></td></tr>
		<tr><td rowspan="2"><a href="#" class="toggle">SO71860</a></td><td>Vinyl and Plastic Goods Corporation</td><td>PO17835163979</td><td>Feb 20, 2008</td><td>$3,651.79</td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Shipping Address</div> <div>No. 25800-130 King Street West <br>Toronto, Ontario M4B 1V5</div></td></tr>
		<tr><td rowspan="3"><a href="#" class="toggle">SO71861</a></td><td>Two Bike Shops</td><td>PO14152156429</td><td>Nov 30, 2007</td><td>$2,430.32</td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Comment</div> <div>Please send ATTN: Jim</div></td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Shipping Address</div> <div>35525-9th Street Sw <br>Puyallup, Washington 98371</div></td></tr>
		<tr><td rowspan="2"><a href="#" class="toggle">SO71862</a></td><td>Fad Outlet</td><td>PO14065190039</td><td>Feb 19, 2008</td><td>$1,622.62</td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Shipping Address</div> <div>2550 Ne Sandy Blvd <br>Portland, Oregon 97205</div></td></tr>
		<tr><td rowspan="2"><a href="#" class="toggle">SO71863</a></td><td>Sports Products Store</td><td>PO16124166561</td><td>Apr 30, 2007</td><td>$3,673.32</td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Shipping Address</div> <div>Po Box 252525 <br>Santa Ana, California 92701</div></td></tr>
		<tr><td rowspan="2"><a href="#" class="toggle">SO71864</a></td><td>Good Bike Shop</td><td>PO14268188903</td><td>Oct 9, 2007</td><td>$37,623.76</td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Shipping Address</div> <div>99433 S. Greenbay Rd. <br>Racine, Wisconsin 53182</div></td></tr>
		<tr><td rowspan="3"><a href="#" class="toggle">SO71865</a></td><td>Neighborhood Bicycle Storehouse</td><td>PO15109136609</td><td>May 30, 2007</td><td>$290.23</td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Comment</div> <div>Please send ATTN: Cecilia</div></td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Shipping Address</div> <div>69, boulevard Tremblay <br>Roncq, Nord 59223</div></td></tr>
		<tr><td rowspan="2"><a href="#" class="toggle">SO71866</a></td><td>Exchange Parts Inc.</td><td>PO14297151936</td><td>Jan 27, 2008</td><td>$43,277.65</td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Shipping Address</div> <div>7700 Green Road <br>Raleigh, North Carolina 27603</div></td></tr>
		<tr><td rowspan="2"><a href="#" class="toggle">SO71867</a></td><td>Vigorous Sports Store</td><td>PO13050111529</td><td>Jul 29, 2007</td><td>$1,170.54</td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Shipping Address</div> <div>Banbury <br>Oxon, England OX16 8RS</div></td></tr>
		<tr><td rowspan="2"><a href="#" class="toggle">SO71868</a></td><td>Cycle Merchants</td><td>PO14210134527</td><td>Aug 15, 2007</td><td>$1,932.67</td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Shipping Address</div> <div>575 Rue St Amable <br>Quebec, Quebec G1R</div></td></tr>
		<tr><td rowspan="3"><a href="#" class="toggle">SO71869</a></td><td>Certified Sports Supply</td><td>PO14877155420</td><td>Feb 21, 2008</td><td>$143.50</td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Comment</div> <div>Please send ATTN: Gabriele</div></td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Shipping Address</div> <div>250551 Shellbridge Way <br>Richmond, British Columbia V6B 3P7</div></td></tr>
		<tr><td rowspan="2"><a href="#" class="toggle">SO71870</a></td><td>Accessories Network</td><td>PO13195134898</td><td>Feb 1, 2008</td><td>$1,903.38</td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Shipping Address</div> <div>699bis, rue des Peupliers <br>Paris, Seine (Paris) 75008</div></td></tr>
		<tr><td rowspan="2"><a href="#" class="toggle">SO71871</a></td><td>Remote Bicycle Specialists</td><td>PO14239120760</td><td>Aug 10, 2007</td><td>$2,168.53</td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Shipping Address</div> <div>No. 2000-25080 Beaver Hall Hill <br>Quebec, Quebec G1R</div></td></tr>
		<tr><td rowspan="2"><a href="#" class="toggle">SO71872</a></td><td>First Center</td><td>PO13137112099</td><td>Jan 2, 2008</td><td>$215.91</td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Shipping Address</div> <div>22, rue Lafayette <br>Pantin, Seine Saint Denis 93500</div></td></tr>
		<tr><td rowspan="3"><a href="#" class="toggle">SO71873</a></td><td>Incomparable Bicycle Store</td><td>PO12325121185</td><td>Jul 5, 2007</td><td>$5,941.29</td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Comment</div> <div>Please send ATTN: Faith</div></td></tr>
		<tr class="tablesorter-childRow"><td colspan="4"><div class="bold">Shipping Address</div> <div>99 Edgewater Drive <br>Norwood, Massachusetts 02062</div></td></tr>
	</tbody>
</table>

	<h1>Javascript</h1>
	<div id="javascript">
		<pre class="prettyprint lang-javascript"></pre>
	</div>
	<h1>HTML</h1>
	<div>
		<pre class="prettyprint lang-html">&lt;table class=&quot;tablesorter&quot;&gt;
  &lt;colgroup&gt;
    &lt;col width=&quot;85&quot; /&gt;
    &lt;col width=&quot;250&quot; /&gt;
    &lt;col width=&quot;100&quot; /&gt;
    &lt;col width=&quot;90&quot; /&gt;
    &lt;col width=&quot;70&quot; /&gt;
  &lt;/colgroup&gt;
  &lt;thead&gt;
    &lt;tr&gt;
      &lt;th&gt;Order #&lt;/th&gt;
      &lt;th&gt;Customer&lt;/th&gt;
      &lt;th&gt;PO&lt;/th&gt;
      &lt;th&gt;Date&lt;/th&gt;
      &lt;th&gt;Total&lt;/th&gt;
    &lt;/tr&gt;
  &lt;/thead&gt;
  &lt;tbody&gt;
    &lt;tr&gt;
      &lt;td rowspan=&quot;2&quot;&gt; &lt;!-- rowspan=&quot;2&quot; makes the table look nicer --&gt;
        &lt;a href=&quot;#&quot; class=&quot;toggle&quot;&gt;SO71774&lt;/a&gt; &lt;!-- link to toggle view of the child row --&gt;
      &lt;/td&gt;
      &lt;td&gt;Good Toys&lt;/td&gt;
      &lt;td&gt;PO348186287&lt;/td&gt;
      &lt;td&gt;Jul 20, 2007&lt;/td&gt;
      &lt;td&gt;$972.78&lt;/td&gt;
    &lt;/tr&gt;
    &lt;tr class=&quot;tablesorter-childRow&quot;&gt;
      &lt;td colspan=&quot;4&quot;&gt;
        &lt;div class=&quot;bold&quot;&gt;Shipping Address&lt;/div&gt;
        &lt;div&gt;99700 Bell Road&lt;br&gt;Auburn, California 95603&lt;/div&gt;
      &lt;/td&gt;
    &lt;/tr&gt;
    &lt;tr&gt;
      &lt;td rowspan=&quot;2&quot;&gt; &lt;!-- rowspan=&quot;2&quot; makes the table look nicer --&gt;
        &lt;a href=&quot;#&quot; class=&quot;toggle&quot;&gt;SO71775&lt;/a&gt; &lt;!-- link to toggle view of the child row --&gt;
      &lt;/td&gt;
      &lt;td&gt;Cycle Clearance&lt;/td&gt;
      &lt;td&gt;PO58159451&lt;/td&gt;
      &lt;td&gt;May 6, 2007&lt;/td&gt;
      &lt;td&gt;$2,313.13&lt;/td&gt;
    &lt;/tr&gt;
    &lt;tr class=&quot;tablesorter-childRow&quot;&gt;
      &lt;td colspan=&quot;4&quot;&gt;
        &lt;div class=&quot;bold&quot;&gt;Shipping Address&lt;/div&gt;
        &lt;div&gt;2255 254th Avenue Se&lt;br&gt;Albany, Oregon 97321&lt;/div&gt;
      &lt;/td&gt;
    &lt;/tr&gt;

    &lt;!-- View page source for complete HTML markup --&gt;

  &lt;/tbody&gt;
&lt;/table&gt;

&lt;div id=&quot;pager&quot; class=&quot;pager&quot;&gt;
  &lt;form&gt;
    &lt;input type=&quot;button&quot; value=&quot;&amp;lt;&amp;lt;&quot; class=&quot;first&quot; /&gt;
    &lt;input type=&quot;button&quot; value=&quot;&amp;lt;&quot; class=&quot;prev&quot; /&gt;
    &lt;input type=&quot;text&quot; class=&quot;pagedisplay&quot;/&gt;
    &lt;input type=&quot;button&quot; value=&quot;&amp;gt;&quot; class=&quot;next&quot; /&gt;
    &lt;input type=&quot;button&quot; value=&quot;&amp;gt;&amp;gt;&quot; class=&quot;last&quot; /&gt;
    &lt;select class=&quot;pagesize&quot;&gt;
      &lt;option selected=&quot;selected&quot;  value=&quot;10&quot;&gt;10&lt;/option&gt;
      &lt;option value=&quot;20&quot;&gt;20&lt;/option&gt;
      &lt;option value=&quot;30&quot;&gt;30&lt;/option&gt;
      &lt;option value=&quot;40&quot;&gt;40&lt;/option&gt;
    &lt;/select&gt;
  &lt;/form&gt;
&lt;/div&gt;</pre>
	</div>

<hr>

<h3 id="child-by-column">childByColumn</h3>
<button type="button" class="toggle-byColumn">Toggle</button> <code>filter_childByColumn</code> : <span class="state2">true</span>
<ul>
	<li>This option requires the <code>filter_childRow</code> option to be set to <code>true</code> in order to work.</li>
	<li>If <code>true</code>, child row content can be filtered in the same manner as regular rows. Try searching for values <button type="button" data-column="1">&lt;1000</button> in the "FastCar" column, or values between <button type="button" data-column="2">3000 - 4000</button> in the "RapidZoo" column. Only one match in a child row is required to show the entire parent/child group.</li>
	<li>If <code>false</code>, child row content will be grouped together and included in any column search; as was the behavior before this option was added.</li>
	<li>Extra css was added to override the theme row highlighting to group parent/child highlighting; it just doesn't look that good and it may be removed from the themes in the future.</li>
</ul>
<button type="button" class="reset">Reset Search</button>
<div id="demo"><table id="table2" class="tablesorter">
	<thead>
		<tr>
			<th>Region</th>
			<th class="sorter-currency">FastCar</th>
			<th class="sorter-currency">RapidZoo</th>
			<th class="sorter-currency">SuperGlue</th>
		</tr>
	</thead>
	<tbody>
		<tr><td><a href="#" class="toggle">Middle</a></td><td>FCIDM2015Q1</td><td>RZIDM2015Q1</td><td>SGIDM2015Q1</td></tr>
		<tr class="tablesorter-childRow"><td>Joseph</td><td>$ 423</td><td>$ 182</td><td>$ 255</td></tr>
		<tr class="tablesorter-childRow"><td>Lawrence</td><td>$ 1,908</td><td>$ 1,642</td><td>$ 2,593</td></tr>
		<tr class="tablesorter-childRow"><td>Maria</td><td>$ 1,502</td><td>$ 1,969</td><td>$ 3,408</td></tr>
		<tr class="tablesorter-childRow"><td>Matt</td><td>$ 1,170</td><td>$ 1,093</td><td>$ 2,039</td></tr>
		<tr><td><a href="#" class="toggle">North</a></td><td>FCIDN2015Q1</td><td>RZIDN2015Q1</td><td>SGIDN2015Q1</td></tr>
		<tr class="tablesorter-childRow"><td>Joseph</td><td>$ 3,643</td><td>$ 2,846</td><td>$ 1,574</td></tr>
		<tr class="tablesorter-childRow"><td>Lawrence</td><td>$ 3,456</td><td>$ 2,658</td><td>$ 1,685</td></tr>
		<tr class="tablesorter-childRow"><td>Maria</td><td>$ 3,235</td><td>$ 2,616.99</td><td>$ 1,612.33</td></tr>
		<tr class="tablesorter-childRow"><td>Matt</td><td>$ 3,868</td><td>$ 2,926</td><td>$ 1,254</td></tr>
		<tr><td><a href="#" class="toggle">West</a></td><td>FCIDW2015Q1</td><td>RZIDW2015Q1</td><td>SGIDW2015Q1</td></tr>
		<tr class="tablesorter-childRow"><td>Joseph</td><td>$ 5,507</td><td>$ 3,186</td><td>$ 4,882</td></tr>
		<tr class="tablesorter-childRow"><td>Lawrence</td><td>$ 4,082</td><td>$ 4,272</td><td>$ 6,124</td></tr>
		<tr class="tablesorter-childRow"><td>Maria</td><td>$ 5,520</td><td>$ 4,461</td><td>$ 4,872</td></tr>
		<tr class="tablesorter-childRow"><td>Matt</td><td>$ 5,737</td><td>$ 4,598</td><td>$ 4,233</td></tr>
	</tbody>
</table>
</div>

	<h1>CSS</h1>
	<div id="css">
		<pre class="prettyprint lang-css"></pre>
	</div>
	<h1>Javascript</h1>
	<div id="javascript2">
		<pre class="prettyprint lang-javascript"></pre>
	</div>
	<h1>HTML</h1>
	<div id="html">
		<pre class="prettyprint lang-html"></pre>
	</div>

<div class="next-up">
	<hr />
	Next up: <a href="example-option-sort-order.html">Set an initial sorting order direction &rsaquo;&rsaquo;</a>
</div>

</div>

</body>
</html>