nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

zsh

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

Matthew L.

You can suppress duplicate values in the default selection list by checking for the value in the return array before adding a new value to the array.
Also to ignore all "Null Value" values, you can add a check in the duplicate value check if statement.
See code example:
 
//Replace these lines of code
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Ã©}
//With these lines of code:
<pre class="_prettyXprint _lang-js">
var columnValue="";
while (ri.next()){ //Loop through each row in the entire Data Set (row 1+) (iResultIterator)
columnValue = ri.getValue(rsmd.getColumnName(index)); //Get column value
if(resultArray.indexOf(columnValue) == -1 && columnValue != "Null Value"){resultArray.push(columnValue);} //Prevent "Null Value" & duplicates in array
}
</pre>

zsh

Hi Matthew,
 
Thanks for the quick response!
The is almost perfect as the condition should filter out unneccessary items

Matthew L.

Sorry for the confusion.
However the FOR statement (while true) will execute the command(s) immediately following it.
If a {block} of code follows the FOR statement then everything in the block will execute.
However if it's a single line, then only the single line of code will execute within the FOR loop.
 
Per the explanation below, see the source link for more details:
statement
<div>A statement that is executed as long as the condition evaluates to true. To execute multiple statements within the loop, use a block statement ({ ... }) to group those statements. To execute no statement within the loop, use an empty statement ( ; )</div>
<div>
source: <a data-ipb='nomediaparse' href='https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Statements/for'>https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Statements/for</a>
<div> </div>
</div>
So per my example, see comments for each line explanation:
<pre class="_prettyXprint _lang-js">
for (var index=1;index<=cc;index++) //While this line is true, execute only the following line
if(columnName == rsmd.getColumnName(index)) //If this line is true, execute only the following line
break; //This line is only seen by the IF statement, however when executed will cause the FOR loop to break
</pre>
Another way to look at it is:
<pre class="_prettyXprint _lang-js">
for (var index=1;index<=cc;index++){
if(columnName == rsmd.getColumnName(index)){
break;
}
}
</pre>
This is also valid:
<pre class="_prettyXprint _lang-js">
for(var index=1;index<=cc;index++){if(columnName == rsmd.getColumnName(index)){break;}}
</pre>

zsh

Thanks for the clarification. It was useful as I am new to JS.
 
Regarding the solution, while it seems perfect, the result is not as it is expected, though. Duplicated "Null Value" items are eliminated, only one still appears in the list. However, other duplicated values are still present. 
Another issue is that not all the items became selected by default...
 
I am going to try recreating the problem with a dummy database.
 
Thanks

Matthew L.

Sorry I think I misinterpreted the solution for you:
 
Try changing the following line:
if(resultArray.indexOf(columnValue) == -1 && columnValue != "Null Value"){resultArray.push(columnValue);}// && = AND
 
To:
if(resultArray.indexOf(columnValue) == -1 || columnValue != "Null Value"){resultArray.push(columnValue);}// || = OR
 
I think this will correct the issue.
 
Or if you are wanting "Null Value" to be selected as a default value as well, try:
if(resultArray.indexOf(columnValue) == -1){resultArray.push(columnValue);}// || = OR

zsh

I have recreated the issue on a sample Derby database of NetBeans:

zsh

Another way would be suitable to achieve my goal is, inserting an item "ALL" to the top of the selection list.
This extra item would be able to make the selection.
 
Do you think that it would be feasible?