AutocompleteBoxComponent

Description

Renders a auto complete box to choose the correct option from.

Options

name: The name of the component
type: autocompleteBox
parameter: Variable where the selection is stored
listeners: Array - Parameters who this component will react to
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
preExecution: Function - Function to be called before the component is executed
postExecution: Function - Function to be called after the component is executed
preChange: Function(value) - Function to be called before the component is changed
postChange: Function(value) - Function to be called after the component is changed
queryDefinition: MetaLayer object with the definition of the query (see MetaLayer options)
selectMulti: Allow multiple selection. Default: false
minTextLenght: The minimal word length to check if there is a match
matchType: The type of the word match (fromStart/all). Default: fromStart
scrollHeight: The size of the scrollbar. Default: Not defined (without scrollbar)
showApplyButton: Show apply Button in multi selection mode. Default: true
tooltip: Tooltip to be displayed when mouse hovers
autoUpdateFunction: Function to be called every X second according to the autoUpdateTimeout setting
autoUpdateTimeout: timeout in milliseconds to call the function defined by autoUpdateFunction. Default 3 secs
reloadOnUpdate: on update event the component should be reloaded or only update the list of values

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

MetaLayerHome2 = {
clientSelectorDefinition: {
	queryType: 'mdx',
	jndi: "SampleData",
	catalog: "mondrian:/SteelWheels",
	query: function(){
		return "select NON EMPTY {[Measures].[Sales]} ON COLUMNS," +
		"NON EMPTY TopCount( Filter([Customers].[All Customers].Children,"+
		"(Left([Customers].CurrentMember.Name, Len(\""+clients+"\")) = \""+clients+"\")),100.0,[Measures].[Sales]) ON ROWS "+
		"from [SteelWheelsSales]";
		}
	}
}

clientSelector =
{
  name: "clientSelector",
  type: "autocompleteBox",
  matchType: "fromStart",
  queryDefinition: MetaLayerHome2.clientSelectorDefinition,
  selectMulti: true,
  showApplyButton: true,
  minTextLenght: 0,
  scrollHeight: 250,
  parameter:"clients",
  htmlObject: "sampleObject",
  reloadOnUpdate:true,
  autoUpdateTimeout:3000,
  executeAtStart: true,
  autoUpdateFunction:function()
  {
		if(!clients)
			clients="";
		console.log("!update");
		var inputValue=$("#autoboxInput").val();
		console.log("inputValue;"+inputValue);
		console.log("clients;"+clients);
		if(clients!=inputValue)
		{
			clients=inputValue;
			Dashboards.update(clientSelector);
		}
  }
}

Dashboards.init([clientSelector]);
Dashboards.finishedInit = false;