data
Two dimensional array containing the original table data (prior to grouping and aggregation) If no grouping or summarization is defined for the table, the 'data' property is the same as the 'table' property. Otherwise, 'data' holds the raw data and 'table' holds the summarized data. The data can be referenced using the row number as the first array index and the column number or label as the second array index. This property is read-only.
Type
Two-dimensional array
Example 1
for (var i=1; i<data.length; i++) {
if (Query1.data[i]['Name'] == 'Web Bridge') {
alert('Note: "Web Bridge" will be discontinued.');
}
}
Example 2
Text1.text = 'Grand total is ' + sum(Query1.data['Total']);
See Also
Accessing Table Data, for information about working with table data.
| << commit(type) | © 1996-2013 InetSoft Technology Corporation (v11.4) | data.length >> |