QueryComponent
Description
Excecutes a query (sql or mdx) and stores the result in the component result.
Options
- name
- The name of the component
- type
queryComponent- listeners
- Array - Parameters who this component will react to
- htmlObject
- Id of the component (usually a div or a span tag)
- refreshPeriod
- Time in seconds for this component to refresh. Default is 0 (disabled)
- executeAtStart
- True to execute the component at start, false otherwise
- preExecution
- Function - Function to be called before the component is executed
- postExecution
- Function - Function to be called after the component is executed
- resultvar
- variable where the result will be stored (note: the old method of accessing
this object's property "result" is still supported
- queryDefinition
- MetaLayer object with the definition of pivot (see MetaLayer options)
MetaLayer options
- queryType
- Type of query to read results from. Can be sql or mdx. Default: mdx
- jndi
- Connection to use for the query
- query
- sql or mdx Query to execute
- cube
- Cube name to use when queryType is mdx
- catalog
- Mondrian schema to use when queryType is mdx
Sample