SelectComponent

Description

Renders a select box to choose the correct option from. Will read values from a query, an array of values (when the parameter valuesArray is specified) or a xaction result set

Options

name
The name of the component
type
selectComponent
listeners
Array - Parameters who this component will react to
parameter
Variable where the selection is stored
valueAsId
Boolean False indicates the selector will have id/value. True indicates it will use value/value. Default: true
queryDefinition
MetaLayer object with the query definition (see MetaLayer options)
valuesArray
Array of Arrays - Use this to pass a default value to the selector
solution
Solution where the xaction solution is
path
Path where the xaction file is
action
Xaction file name
htmlObject
Id of the component (usually a div or a span tag) to be replaced by the result
refreshPeriod
Time in seconds for this component to refresh. Default is 0 (disabled)
executeAtStart
True to execute the component at start, false otherwise
tooltip
Tooltip to be displayed when mouse hovers
preExecution
Function - Function to be called before the component is executed
postExecution
Function - Function to be called after the component is executed
preChange
Function - Function to be called before the component is changed
postChange
Function - Function to be called after the component is changed

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