ListBox parameter with multiple default values (all) except "Null Value" and duplicate value

Hi All,
 
I have set up a simple report parameter group which contains a couple of parameters. Each parameter list contains all the items selected by default.

//Please note that all custom code received from Actuate Support is officially untested and unsupported.
//This is meant for guidance purposes only and should not be implemented in a production environment without proper testing.
//

//The following code will query a parameters dataset and return the result list from the parameters selected column.
//This will set the parameters default list with all possible values listed. 
//The parameter should be setup with the following settings:
// Display type: List Box
// Selection list values: Dynamic
// Allow Multiple Values: Checked
// 
//This code should be placed in a parameters "getDefaultValueList" method.
//Last updated: February 4th, 2015
//

//The following value should be changed to match the parameter name this code is in. 
THIS_PARAMETERS_NAME = "GroupName";
 
ã€€
//

//Gather Data Source Info
var dataSetName = reportContext.getDesignHandle().findParameter(THIS_PARAMETERS_NAME).getProperty("dataSetName"); //Get parameters dataset name
var columnName = reportContext.getDesignHandle().findParameter(THIS_PARAMETERS_NAME).getProperty("valueExpr").match( /"(.*?)"/ )[1]; //Get parameters dynamic column name
var dataSourceName = reportContext.getDesignHandle().findDataSet(dataSetName).getDataSourceName(); //String - DataSetHandle (Get DataSource Name for dataSetName)
 
//Import Classes
importClass(org.eclipse.birt.data.engine.api.querydefn.QueryDefinition); //Default implementation of the IQueryDefinition interface.
importClass(org.eclipse.birt.report.data.adapter.api.DataRequestSession); //Main entry point to Data Engine functionalities.
importClass(org.eclipse.birt.report.data.adapter.api.DataSessionContext); //Context information used to initialize a DataRequestSession.
 
//Prepare preQuery
var engineConfig = reportContext.getReportRunnable().getReportEngine().getConfig(); //EngineConfig - IReportEngine (Get report engine configurations)
var dataSourceHandle = reportContext.getDesignHandle().findDataSource(dataSourceName); //DataSourceHandle - ModuleHandleImpl (Get DataSource handle)
var dataSetHandle = reportContext.getDesignHandle().findDataSet(dataSetName); //DataSetHandle - ModuleHandleImpl (Get DataSet handle)
 
var iScriptContext = _jsContext.getScriptContext(); //IScriptContext - ScriptContext (org.eclipse.birt.core.script.ScriptContext)
var dataSessionContext = new DataSessionContext(DataSessionContext.MODE_DIRECT_PRESENTATION, reportContext.getDesignHandle(), iScriptContext, null); //Creates a DataEngine context in the provided mode, using the provided top level scope. Also sets the handle of the report design being executed. (int mode, ModuleHandle moduleHandle, ScriptContext scriptContext, ClassLoader classLoader)
var dataRequestSession = DataRequestSession.newSession(engineConfig, dataSessionContext); //DataRequestSession - DataRequestSession (PlatformConfig, DataSessionContext)
 
var DataModelAdapter = dataRequestSession.getModelAdaptor(); //IModelAdapter - DataRequestSession (Get DataModelAdapter)
var odaDataSourceAdapter = DataModelAdapter.adaptDataSource(dataSourceHandle); //BaseDataSourceDesign - IModelAdapter (Get OdaDataSourceAdapter)
var odaDataSetAdapter = DataModelAdapter.adaptDataSet(dataSetHandle); //BaseDataSetDesign - IModelAdapter (Get OdaDataSetAdapter)
 
odaDataSetAdapter.setDataSource(dataSourceName); //void - BaseDataSetDesign
dataRequestSession.defineDataSource( odaDataSourceAdapter ); //void - DataRequestSession
dataRequestSession.defineDataSet( odaDataSetAdapter ); //void - DataRequestSession
 
//Is this an iHub3 engine
try {iQueryDefinition = new QueryDefinition(true);} //iHub3 compatable (autoBinding)
catch(err) {
java.util.logging.Logger.getLogger("birt.report.logger").warning ("Not iHub3? (See error below)\n" + err + "\nTrying another way..."); //(OFF, SEVERE, WARNING, INFO, CONFIG, FINE, FINER, FINEST and ALL)
iQueryDefinition = new QueryDefinition( ); //Pre iHub3 compatable
iQueryDefinition.setAutoBinding(true); //void - QueryDefinition (Set autoBinding)
}
iQueryDefinition.setDataSetName( odaDataSetAdapter.getName() ); //Set the dataSetName Name of data set used by this query.
 
//Run Query 
var iPreparedQuery = dataRequestSession.prepare( iQueryDefinition ); //IPreparedQuery - DataRequestSession
var iQueryResults = iPreparedQuery.execute( null ); //IQueryResults - IPreparedQuery
var ri = iQueryResults.getResultIterator( ); //IResultIterator - IQueryResults
 
rsmd = ri.getResultMetaData(); //IResultMetaData - IBaseResultIterator (Get metadata handle)
cc = rsmd.getColumnCount(); //int - IBaseResultMetaData (Get column count)
 
for (var index=1;index<=cc;index++) //Loop through each column in the row (row 0). *Note: index starts with 1 for getColumnName looping
if(columnName == rsmd.getColumnName(index)) //Find column index of column name
break; //Break when found
 
var resultArray = []; //Set return array
while (ri.next()) //Loop through each row in the entire Data Set (row 1+) (iResultIterator)
resultArray.push(ri.getValue(rsmd.getColumnName(index))); //Push row values into return arrayÃ©}
 
//Close up
ri.close( ); //void - IBaseResultIterator
iQueryResults.close( ); //void - IBaseQueryResults
dataRequestSession.shutdown( ); //void - DataRequestSession
 
//Return resultArray to populate default value list with select all values
resultArray;
//

How to exclude
"Null Value" items and duplicate items
from the selection list?
 
Thanks

Find more posts tagged with

Comments

There are no comments yet