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; } } }

Parameter List Box Multiple Select

rmah

Hello,
 
I have a report I created in BIRT 2.6.1.
 
I have flattened a hierarchy in a multi-select list box. I am having an issue passing the parameter correctly when a parent is selected and want to return all child values.
 
The report pulls in application data details grouped by organizations.
 
An example:
User 1 wants to return all details of applications assigned to an Organization.
The report lists all organizations using a concatenation of the parent child relationships.
apps can be associated to any organization at any hierarchical level
 
Parameter List
RootOrganization
RootOrganization\ChildOrganization1
 
If the user selects RootOrganization, they want all of the subsequent organizations' applications.
 
How can I pass a parameter to the query that will allow multiple selections and also return child organizations when only the RootOrganization is selected.
 
Thank you in advance for all of your help!
 
<div> </div>

Find more posts tagged with

Comments

pricher

Hi,
 
The short answer to your question is that you will need to modify your query dynamically by writing script in the beforeOpen method of the query. The statement
 
this.queryText
 
will return the text of your data set query. From there, you can modify/add the WHERE clause programmatically based on the values passed from the report parameter. Not knowing exactly how your WHERE clause is currently built, it is hard for us to give you a working example.
 
Another thing you might consider is using cascading parameters. With cascading parameters, the values of the second parameter are based on user selection of the first parameter. If you make the second parameter optional, the query could be changed to use only the value of the first parameter if a null value is passed as the second parameter.
 
Just in case this scenario works for you, I have attached a quick example using Classic Models.
 
Hope this helps,
 
P.