src/cm/media/js/lib/yui/yui_3.10.3/docs/datatable/datatable-dsget.html
author Yves-Marie Haussonne <ymh.work+github@gmail.com>
Fri, 09 May 2014 18:35:26 +0200
changeset 656 a84519031134
parent 525 89ef5ed3c48b
permissions -rw-r--r--
add link to "privacy policy" in the header test
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
525
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
     1
<!DOCTYPE html>
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
     2
<html lang="en">
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
     3
<head>
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
     4
    <meta charset="utf-8">
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
     5
    <title>Example: DataTable + DataSource.Get + JSON Data</title>
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
     6
    <link rel="stylesheet" href="http://fonts.googleapis.com/css?family=PT+Sans:400,700,400italic,700italic">
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
     7
    <link rel="stylesheet" href="../../build/cssgrids/cssgrids-min.css">
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
     8
    <link rel="stylesheet" href="../assets/css/main.css">
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
     9
    <link rel="stylesheet" href="../assets/vendor/prettify/prettify-min.css">
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
    10
    <link rel="shortcut icon" type="image/png" href="../assets/favicon.png">
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
    11
    <script src="../../build/yui/yui-min.js"></script>
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
    12
    
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
    13
</head>
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
    14
<body>
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
    15
<!--
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
    16
<a href="https://github.com/yui/yui3"><img style="position: absolute; top: 0; right: 0; border: 0;" src="https://s3.amazonaws.com/github/ribbons/forkme_right_darkblue_121621.png" alt="Fork me on GitHub"></a>
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
    17
-->
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
    18
<div id="doc">
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
    19
    <div id="hd">
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
    20
        <h1><img src="http://yuilibrary.com/img/yui-logo.png"></h1>
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
    21
    </div>
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
    22
    
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
    23
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
    24
            <h1>Example: DataTable + DataSource.Get + JSON Data</h1>
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
    25
    <div class="yui3-g">
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
    26
        <div class="yui3-u-3-4">
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
    27
            <div id="main">
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
    28
                <div class="content"><style scoped>
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
    29
/* css to counter global site css */
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
    30
.example table {
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
    31
    width: auto;
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
    32
}
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
    33
.example caption {
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
    34
    display: table-caption;
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
    35
}
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
    36
.example th,
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
    37
.example td {
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
    38
    border: 0 none;
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
    39
    text-transform :none;
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
    40
}
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
    41
</style>
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
    42
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
    43
<div class="intro">
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
    44
    <p>
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
    45
        This example shows how to populate a DataTable with data from the
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
    46
        Yahoo! Local webservice retrieved via a YQL query. First we create a
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
    47
        DataSource.Get instance pointing to YQL, then using the
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
    48
        DataTableDataSource plugin we can load data for pizza places near our
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
    49
        office.
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
    50
    </p>
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
    51
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
    52
    <p>
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
    53
        In this example, we render the DataTable first, then load data into it
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
    54
        in a separate call.
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
    55
    </p>
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
    56
</div>
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
    57
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
    58
<div class="example yui3-skin-sam">
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
    59
    <div id="pizza"></div>
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
    60
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
    61
<script>
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
    62
YUI().use("datatable", "datasource-get", "datasource-jsonschema", "datatable-datasource", function (Y) {
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
    63
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
    64
    var url = "http://query.yahooapis.com/v1/public/yql?format=json" +
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
    65
                  "&env=store%3A%2F%2Fdatatables.org%2Falltableswithkeys",
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
    66
        query = "&q=" + encodeURIComponent(
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
    67
                'select * from local.search ' +
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
    68
                'where zip = "94089" and query = "pizza"'),
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
    69
        dataSource,
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
    70
        table;
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
    71
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
    72
    dataSource = new Y.DataSource.Get({ source: url });
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
    73
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
    74
    dataSource.plug(Y.Plugin.DataSourceJSONSchema, {
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
    75
        schema: {
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
    76
            resultListLocator: "query.results.Result",
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
    77
            resultFields: [
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
    78
                "Title",
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
    79
                "Phone",
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
    80
                {
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
    81
                    key: "Rating",
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
    82
                    locator: "Rating.AverageRating",
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
    83
                    parser: function (val) {
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
    84
                        // YQL is returning "NaN" for unrated restaurants
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
    85
                        return isNaN(val) ? -1 : +val;
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
    86
                    }
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
    87
                }
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
    88
            ]
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
    89
        }
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
    90
    });
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
    91
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
    92
    table = new Y.DataTable({
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
    93
        columns: [
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
    94
            "Title",
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
    95
            "Phone",
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
    96
            {
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
    97
                key: "Rating",
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
    98
                formatter: function (o) {
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
    99
                    if (o.value === -1) {
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   100
                        o.value = '(none)';
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   101
                    }
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   102
                }
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   103
            }
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   104
        ],
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   105
        summary: "Pizza places near 98089",
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   106
        caption: "Table with JSON data from YQL"
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   107
    });
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   108
    
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   109
    table.plug(Y.Plugin.DataTableDataSource, { datasource: dataSource });
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   110
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   111
    table.render("#pizza");
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   112
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   113
    table.datasource.load({ request: query });
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   114
});
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   115
</script>
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   116
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   117
</div>
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   118
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   119
<h2>Populating Your DataTable with Remote Data Using DataSource.Get</h2>
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   120
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   121
<p>
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   122
    Your table can be easily popluated with remote JSON data from a JSONP
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   123
    webservice by creating a DataSource instance and using the
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   124
    DataTableDataSource plugin to load the data into a DataTable.
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   125
</p>
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   126
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   127
<p>Start with the <code>use()</code> statement:</p>
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   128
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   129
<pre class="code prettyprint">YUI().use(&quot;datatable&quot;, &quot;datasource-get&quot;, &quot;datasource-jsonschema&quot;, &quot;datatable-datasource&quot;, function(Y) {
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   130
});</pre>
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   131
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   132
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   133
<p>
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   134
    Next create a DataSource.Get instance pointing to YQL. The <a
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   135
    href="http://developer.yahoo.com/yql/console/">YQL Console</a> makes it
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   136
    easy to determine the REST URL we want to send. You also need to define the
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   137
    correct schema for the DataSourceJSONSchema plugin.
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   138
</p>
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   139
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   140
<pre class="code prettyprint">var dataSource = new Y.DataSource.Get({
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   141
    source: &quot;http:&#x2F;&#x2F;query.yahooapis.com&#x2F;v1&#x2F;public&#x2F;yql?&quot;+
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   142
        &quot;q=select%20*%20from%20local.search%20where%20zip%3D%2794089%27%20&quot;+
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   143
        &quot;and%20query%3D%27pizza%27&amp;format=json&amp;&quot;+
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   144
        &quot;env=store%3A%2F%2Fdatatables.org%2Falltableswithkeys&quot;
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   145
});
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   146
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   147
dataSource.plug(Y.Plugin.DataSourceJSONSchema, {
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   148
    schema: {
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   149
        resultListLocator: &quot;query.results.Result&quot;,
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   150
        resultFields: [ &quot;Title&quot;, &quot;Phone&quot;, &quot;Rating&quot; ]
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   151
    }
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   152
});</pre>
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   153
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   154
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   155
<p>
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   156
    This is a good time to call <code>sendRequest</code> to make sure the data returns as
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   157
    expected.
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   158
</p>
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   159
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   160
<pre class="code prettyprint">dataSource.sendRequest({
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   161
    callback: {
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   162
        success: function(e) {
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   163
            Y.log(e);
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   164
        }
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   165
    }
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   166
});</pre>
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   167
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   168
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   169
Results:
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   170
<pre class="code prettyprint">{
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   171
    &quot;query&quot;: {
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   172
        ...
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   173
        &quot;results&quot;: {
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   174
            &quot;Result&quot;:[
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   175
                {
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   176
                    &quot;Title&quot; : &quot;Giovannis Pizzeria&quot;,
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   177
                    &quot;Phone&quot; : &quot;(408) 734-4221&quot;,
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   178
                    ...
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   179
                    &quot;Rating&quot;: {
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   180
                        &quot;AverageRating&quot;: &quot;4&quot;,
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   181
                        ...
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   182
                    }
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   183
                },
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   184
                {
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   185
                    &quot;Title&quot; : &quot;Pizza&quot;,
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   186
                    &quot;Phone&quot; : &quot;(800) 555-1212&quot;,
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   187
                    ...
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   188
                    &quot;Rating&quot;: {
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   189
                        &quot;AverageRating&quot;:&quot;NaN&quot;,
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   190
                        ...
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   191
                    }
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   192
                },
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   193
                ...
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   194
            ]
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   195
        }
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   196
    }
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   197
}</pre>
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   198
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   199
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   200
<p>
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   201
    Uh oh. The <code>Rating</code> data we're receiving is an object rather than a single value.  It looks like <code>Rating.AverageRating</code> is what we want, but it's a numeric string, and sometimes the unfortunate value "NaN".
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   202
</p>
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   203
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   204
<p>
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   205
    We'll add a <code>locator</code> to the schema to extract the <code>Rating.AverageRating</code>
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   206
    value for our <code>Rating</code> data field, and also a <code>parser</code> that will convert
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   207
    the numeric string into a real number, using <code>-1</code> for restaurants that
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   208
    haven't received a rating yet.  It's a good policy to store the table model
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   209
    data as the appropriate type.
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   210
</p>
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   211
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   212
<pre class="code prettyprint">schema: {
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   213
    resultListLocator: &quot;query.results.Result&quot;,
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   214
    resultFields: [
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   215
        &quot;Title&quot;,
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   216
        &quot;Phone&quot;,
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   217
        {
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   218
            key: &quot;Rating&quot;,
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   219
            locator: &quot;Rating.AverageRating&quot;,
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   220
            parser: function (val) {
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   221
                return isNaN(val) : -1 : +val;
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   222
            }
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   223
        }
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   224
    ]
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   225
}</pre>
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   226
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   227
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   228
<p>
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   229
    Now that the DataSource is created properly, define the columns that you
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   230
    want your table to show. These columns map directly to the parameter names
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   231
    returned in the data.  We'll add a formatter to the <code>Rating</code> column to
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   232
    deal with those <code>-1</code>s, instead displaying "(none)".
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   233
</p>
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   234
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   235
<pre class="code prettyprint">var cols = [
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   236
    &quot;Title&quot;,
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   237
    &quot;Phone&quot;,
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   238
    {
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   239
        key: &quot;Rating&quot;,
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   240
        formatter: function (o) {
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   241
            &#x2F;&#x2F; formatters can either return the new content or update o.value
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   242
            if (o.value === -1) {
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   243
                o.value = &quot;(none)&quot;;
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   244
            }
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   245
        }
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   246
    }
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   247
];</pre>
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   248
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   249
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   250
<p>
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   251
    Now you are ready to create a DataTable using the columns you have defined.
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   252
    When you plug the instance with the DataTableDataSource plugin, point to
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   253
    your DataSource instance. After you render the table, load the data via the
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   254
    plugin.
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   255
</p>
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   256
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   257
<pre class="code prettyprint">var table = new Y.DataTable({
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   258
    columns : cols,
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   259
    summary : &quot;Pizza places near 98089&quot;,
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   260
    caption : &quot;Table with JSON data from YQL&quot;
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   261
});
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   262
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   263
table.plug(Y.Plugin.DataTableDataSource, { datasource: dataSource });
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   264
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   265
table.render(&quot;#pizza&quot;);
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   266
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   267
table.datasource.load();</pre>
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   268
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   269
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   270
<p>
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   271
    One final change you can make is to split the URL between the DataSource
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   272
    <code>source</code> value and the <code>request</code> value sent to the DataTableDataSource
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   273
    plugin. Splitting the URL this way facilitates making future requests to
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   274
    the same DataSource.  You can see this in the <a href="#fullcode">Full Code
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   275
    Listing</a> below.
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   276
</p>
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   277
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   278
<h2 id="fullcode">Full Code Listing</h2>
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   279
<p>
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   280
<strong>Note:</strong> be sure to add the <code>yui3-skin-sam</code> classname to the
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   281
page's <code>&lt;body&gt;</code> element or to a parent element of the widget in order to apply
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   282
the default CSS skin. See <a href="http://yuilibrary.com/yui/docs/tutorials/skins/">Understanding Skinning</a>.
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   283
</p> <!-- You need this skin class -->
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   284
<pre class="code prettyprint">&lt;body class=&quot;yui3-skin-sam&quot;&gt; &lt;!-- You need this skin class --&gt;</pre>
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   285
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   286
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   287
<pre class="code prettyprint">&lt;div id=&quot;pizza&quot;&gt;&lt;&#x2F;div&gt;
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   288
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   289
&lt;script&gt;
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   290
YUI().use(&quot;datatable&quot;, &quot;datasource-get&quot;, &quot;datasource-jsonschema&quot;, &quot;datatable-datasource&quot;, function (Y) {
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   291
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   292
    var url = &quot;http:&#x2F;&#x2F;query.yahooapis.com&#x2F;v1&#x2F;public&#x2F;yql?format=json&quot; +
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   293
                  &quot;&amp;env=store%3A%2F%2Fdatatables.org%2Falltableswithkeys&quot;,
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   294
        query = &quot;&amp;q=&quot; + encodeURIComponent(
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   295
                &#x27;select * from local.search &#x27; +
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   296
                &#x27;where zip = &quot;94089&quot; and query = &quot;pizza&quot;&#x27;),
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   297
        dataSource,
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   298
        table;
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   299
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   300
    dataSource = new Y.DataSource.Get({ source: url });
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   301
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   302
    dataSource.plug(Y.Plugin.DataSourceJSONSchema, {
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   303
        schema: {
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   304
            resultListLocator: &quot;query.results.Result&quot;,
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   305
            resultFields: [
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   306
                &quot;Title&quot;,
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   307
                &quot;Phone&quot;,
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   308
                {
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   309
                    key: &quot;Rating&quot;,
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   310
                    locator: &quot;Rating.AverageRating&quot;,
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   311
                    parser: function (val) {
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   312
                        &#x2F;&#x2F; YQL is returning &quot;NaN&quot; for unrated restaurants
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   313
                        return isNaN(val) ? -1 : +val;
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   314
                    }
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   315
                }
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   316
            ]
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   317
        }
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   318
    });
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   319
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   320
    table = new Y.DataTable({
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   321
        columns: [
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   322
            &quot;Title&quot;,
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   323
            &quot;Phone&quot;,
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   324
            {
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   325
                key: &quot;Rating&quot;,
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   326
                formatter: function (o) {
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   327
                    if (o.value === -1) {
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   328
                        o.value = &#x27;(none)&#x27;;
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   329
                    }
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   330
                }
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   331
            }
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   332
        ],
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   333
        summary: &quot;Pizza places near 98089&quot;,
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   334
        caption: &quot;Table with JSON data from YQL&quot;
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   335
    });
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   336
    
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   337
    table.plug(Y.Plugin.DataTableDataSource, { datasource: dataSource });
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   338
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   339
    table.render(&quot;#pizza&quot;);
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   340
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   341
    table.datasource.load({ request: query });
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   342
});
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   343
&lt;&#x2F;script&gt;</pre>
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   344
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   345
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   346
<h3>Lighten the module payload</h3>
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   347
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   348
<p>
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   349
    The <code>datatable</code> module includes a number of features not used in this
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   350
    example.  For a smaller module payload, use the <code>datatable-base</code> module.
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   351
</p>
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   352
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   353
<pre class="code prettyprint">&#x2F;&#x2F; datatable-base includes only basic table rendering, but in this case,
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   354
&#x2F;&#x2F; that&#x27;s enough.
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   355
YUI().use(&quot;datatable-base&quot;, &quot;datasource-get&quot;, &quot;datasource-jsonschema&quot;, &quot;datatable-datasource&quot;, function(Y) {
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   356
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   357
    ...
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   358
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   359
    var table = new Y.DataTable({
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   360
        columns : cols,
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   361
        summary : &quot;Pizza places near 98089&quot;,
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   362
        caption : &quot;Table with JSON data from YQL&quot;
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   363
    });
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   364
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   365
    table.plug(Y.Plugin.DataTableDataSource, { datasource: dataSource });
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   366
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   367
    table.render(&quot;#pizza&quot;);
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   368
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   369
    table.datasource.load();
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   370
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   371
});</pre>
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   372
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   373
</div>
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   374
            </div>
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   375
        </div>
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   376
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   377
        <div class="yui3-u-1-4">
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   378
            <div class="sidebar">
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   379
                
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   380
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   381
                
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   382
                    <div class="sidebox">
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   383
                        <div class="hd">
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   384
                            <h2 class="no-toc">Examples</h2>
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   385
                        </div>
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   386
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   387
                        <div class="bd">
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   388
                            <ul class="examples">
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   389
                                
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   390
                                    
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   391
                                        <li data-description="This example illustrates simple DataTable use cases.">
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   392
                                            <a href="datatable-basic.html">Basic DataTable</a>
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   393
                                        </li>
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   394
                                    
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   395
                                
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   396
                                    
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   397
                                        <li data-description="DataTable loaded with JSON data from a remote webservice via DataSource.Get">
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   398
                                            <a href="datatable-dsget.html">DataTable + DataSource.Get + JSON Data</a>
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   399
                                        </li>
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   400
                                    
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   401
                                
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   402
                                    
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   403
                                        <li data-description="DataTable loaded with XML data from a remote webservice via DataSource.IO.">
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   404
                                            <a href="datatable-dsio.html">DataTable + DataSource.IO + XML Data</a>
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   405
                                        </li>
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   406
                                    
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   407
                                
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   408
                                    
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   409
                                        <li data-description="Custom format data for display.">
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   410
                                            <a href="datatable-formatting.html">Formatting Row Data for Display</a>
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   411
                                        </li>
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   412
                                    
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   413
                                
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   414
                                    
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   415
                                        <li data-description="DataTable with nested column headers.">
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   416
                                            <a href="datatable-nestedcols.html">Nested Column Headers</a>
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   417
                                        </li>
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   418
                                    
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   419
                                
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   420
                                    
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   421
                                        <li data-description="DataTable with column sorting.">
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   422
                                            <a href="datatable-sort.html">Column Sorting</a>
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   423
                                        </li>
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   424
                                    
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   425
                                
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   426
                                    
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   427
                                        <li data-description="DataTable with vertical and/or horizontal scrolling rows.">
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   428
                                            <a href="datatable-scroll.html">Scrolling DataTable</a>
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   429
                                        </li>
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   430
                                    
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   431
                                
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   432
                                    
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   433
                                        <li data-description="Using DataTable&#x27;s recordType attribute to create calculated, sortable columns.">
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   434
                                            <a href="datatable-recordtype.html">Sortable generated columns</a>
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   435
                                        </li>
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   436
                                    
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   437
                                
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   438
                                    
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   439
                                        <li data-description="Populating one DataTable from details in the data of another.">
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   440
                                            <a href="datatable-masterdetail.html">Master and detail tables</a>
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   441
                                        </li>
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   442
                                    
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   443
                                
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   444
                                    
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   445
                                        <li data-description="Checkbox column that retains checked state when sorting.">
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   446
                                            <a href="datatable-chkboxselect.html">Checkbox select column</a>
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   447
                                        </li>
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   448
                                    
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   449
                                
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   450
                                    
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   451
                                
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   452
                            </ul>
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   453
                        </div>
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   454
                    </div>
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   455
                
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   456
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   457
                
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   458
                    <div class="sidebox">
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   459
                        <div class="hd">
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   460
                            <h2 class="no-toc">Examples That Use This Component</h2>
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   461
                        </div>
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   462
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   463
                        <div class="bd">
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   464
                            <ul class="examples">
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   465
                                
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   466
                                    
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   467
                                
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   468
                                    
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   469
                                
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   470
                                    
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   471
                                
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   472
                                    
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   473
                                
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   474
                                    
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   475
                                
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   476
                                    
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   477
                                
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   478
                                    
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   479
                                
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   480
                                    
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   481
                                
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   482
                                    
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   483
                                
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   484
                                    
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   485
                                
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   486
                                    
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   487
                                        <li data-description="Shows how to instantiate multiple Panel instances, and use nested modality to interact with a Datatable.">
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   488
                                            <a href="../panel/panel-form.html">Creating a Modal Form</a>
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   489
                                        </li>
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   490
                                    
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   491
                                
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   492
                            </ul>
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   493
                        </div>
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   494
                    </div>
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   495
                
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   496
            </div>
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   497
        </div>
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   498
    </div>
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   499
</div>
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   500
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   501
<script src="../assets/vendor/prettify/prettify-min.js"></script>
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   502
<script>prettyPrint();</script>
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   503
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   504
<script>
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   505
YUI.Env.Tests = {
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   506
    examples: [],
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   507
    project: '../assets',
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   508
    assets: '../assets/datatable',
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   509
    name: 'datatable-dsget',
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   510
    title: 'DataTable + DataSource.Get + JSON Data',
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   511
    newWindow: '',
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   512
    auto:  false 
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   513
};
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   514
YUI.Env.Tests.examples.push('datatable-basic');
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   515
YUI.Env.Tests.examples.push('datatable-dsget');
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   516
YUI.Env.Tests.examples.push('datatable-dsio');
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   517
YUI.Env.Tests.examples.push('datatable-formatting');
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   518
YUI.Env.Tests.examples.push('datatable-nestedcols');
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   519
YUI.Env.Tests.examples.push('datatable-sort');
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   520
YUI.Env.Tests.examples.push('datatable-scroll');
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   521
YUI.Env.Tests.examples.push('datatable-recordtype');
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   522
YUI.Env.Tests.examples.push('datatable-masterdetail');
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   523
YUI.Env.Tests.examples.push('datatable-chkboxselect');
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   524
YUI.Env.Tests.examples.push('panel-form');
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   525
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   526
</script>
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   527
<script src="../assets/yui/test-runner.js"></script>
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   528
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   529
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   530
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   531
</body>
89ef5ed3c48b Upgrades to yui 3.10.3
gibus
parents:
diff changeset
   532
</html>