Yahoo! Developer Network Home - Help

YDN Site Search

# YUI Library Examples: DataTable Control (beta): Client-side Sorting

# DataTable Control (beta): Client-side Sorting

A custom sort handler has been defined in this example to enable custom nested sorting, such that clicking on the "States" Column will sort by states, and then by area code.

View example in new window.

## Sample Code for this Example

Data:

YAHOO.example.Data = { areacodes: [ {areacode: "201", state: "New Jersey"}, {areacode: "202", state: "Washington, DC"}, {areacode: "203", state: "Connecticut"}, ... ] }

CSS:

/* No custom CSS. */

Markup:

<div id="sort"></div>

JavaScript:

YAHOO.util.Event.addListener(window, "load", function() { YAHOO.example.CustomSort = new function() { // Custom sort handler to sort by state and then by areacode // where a and b are Record instances to compare this.sortStates = function(a, b, desc) { // Deal with empty values if(!YAHOO.lang.isValue(a)) { return (!YAHOO.lang.isValue(b)) ? 0 : 1; } else if(!YAHOO.lang.isValue(b)) { return -1; } // First compare by state var comp = YAHOO.util.Sort.compare; var compState = comp(a.getData("state"), b.getData("state"), desc); // If states are equal, then compare by areacode return (compState !== 0) ? compState : comp(a.getData("areacode"), b.getData("areacode"), desc); }; var myColumnDefs = [ {key:"areacode",label:"Area Codes",sortable:true}, {key:"state",label:"States",sortable:true,sortOptions:{sortFunction:this.sortStates}} ]; this.myDataSource = new YAHOO.util.DataSource(YAHOO.example.Data.areacodes.slice(0,25)); this.myDataSource.responseType = YAHOO.util.DataSource.TYPE_JSARRAY; this.myDataSource.responseSchema = { fields: ["areacode","state"] }; this.myDataTable = new YAHOO.widget.DataTable("sort", myColumnDefs, this.myDataSource, {sortedBy:{key:"areacode", dir:"asc"}}); }; });

### YUI Logger Output:

Note: Logging and debugging is currently turned off for this example.

Reload with logging
and debugging enabled.

### DataTable Control (beta) Examples:

- Basic Example
- Progressive Enhancement
- Custom Cell Formatting
- Nested Headers
- JSON Data Over XHR
- XML Data Over XHR With POST
- Textual Data Over XHR
- Local XML Data
- Adding and Deleting Rows
- Client-side Pagination
- Client-side Sorting
- Server-side Pagination
- Server-side Sorting
- Server-side Pagination and Sorting, with Browser History Manager
- XY-scrolling, Y-scrolling, and X-scrolling
- Row Selection
- Cell Selection
- Inline Cell Editing
- Context Menu Integration
- Showing, Hiding, and Reordering Columns.
- Highlighting Cells, Rows, or Columns
- Complex Example of Multiple Features
- Datatable with Autocomplete
- Skinning Model
- Configuring the Paginator
- Complex Application (included with examples for Layout Manager (beta))

### More DataTable Control (beta) Resources:

- User's Guide (external)
- API Documentation
- Cheat Sheet PDF (external)

Copyright © 2008 Yahoo! Inc. All rights reserved.

Privacy Policy - Terms of Service - Copyright Policy - Job Openings