query

Specifies the data block to be used by the Crosstab component. The available data blocks appear at the top of the Toolbox panel in Visual Composer.

Toolbox panel showing available data blocks for crosstab query binding

See the Crosstab.bindingInfo properties for additional data binding features.

Type

String

Example

Crosstab1.query = 'Sales';
Crosstab1.bindingInfo.rowFields = ['Category','Name'];
Crosstab1.bindingInfo.colFields = ['Region','State'];
Crosstab1.bindingInfo.measureFields = ['Total','Quantity Purchased'];

crosstab with row and column fields and measures bound from Sales query

Either syntax below can be used in component script:

query             // unqualified
Crosstab1.query   // qualified

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