table

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 holding the table or crosstab cell data as displayed (after any grouping and aggregation). If no grouping or summarization is defined on a table, the table property is the same as the data 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 name as the second array index.

This property is read-only. To write data to an Editable Table, use setObject(row, col, value) or setCellValue(tableName, row, col, value).

Type

Two-dimensional array

Examples

Alert based on Table data

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

Compute a KPI from Table data

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

Either syntax below can be used in component script:

table                 // unqualified
TableView1.table      // qualified

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