data

Property is read-only. It cannot be set in script.

Table/Crosstab Components in Access Component Data for information about working with table data.

Two-dimensional array containing the original table or crosstab 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.

Type

Two-dimensional array

Examples

Alert based on Table data

for (var i=1; i < data.length; i++) {
  if (Query1.data[i]['Name'] == 'Web Bridge') {
    alert('Note: "Web Bridge" will be discontinued.');
  }
}

Compute a KPI from Table data

Text1.text = 'Grand total is ' + sum(Query1.data['Total']);

Either syntax below can be used in component script:

data                 // unqualified
TableView1.data      // qualified

For onInit/onRefresh scripts, and for component and property scripts on other components, the second (qualified) form is required.