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

Multiple Selection Parameter

RobertLacasse

Hello,
 
BIRT Version: 4.4.1
 
I have a ListBox Parameter with "Allow Multiple Values" checked. And in "beforeOpen" Script, I have following code:
this.queryText = this.queryText.replace(" and NumaricCol in (0)", " and NumaricCol in (" + params["p_Oprtr_ID"].value.join(",") + ")");
 
When I selected some (more than one) or All items from the listbox, it worked perfect. However, when I selected only one item, it took significant amount of time to get the result. I did this test many times, and this issue is persistent. I have tested the select statement of the DataSet in database, worked perfect with any scenario.
 
Could anybody please let me know if there is anything that I could try to figure out this issue?
Thanks in advance!!!

Find more posts tagged with

Comments

JFreeman

To start I would see if it may have something to do with the performing the join call on the array. Change the parameter back to single selection, remove the .join(",") and see if the issue persists. This will help narrow it down some.

RobertLacasse

Hello Jesse,
 
Thank you so much for your reply!!!
I did the test as you suggested:
take out the checkbox on "Allow Multiple Values", and changed the code in "beforeOpen" as following:
this.queryText = this.queryText.replace(" and NumaricCol in (0)", " and NumaricCol in (" + params["p_ID"].value + ")");
The issue persists. I got the result after waiting more than 3 minutes.
 
If i change "params["p_ID"].value" TO "params["p_ID"].value[0]", no result returned.
 
I do not think that .join(",") causes this issue, because i also tested with FOR() loop. It worked perfect with multiple items selected, but same issue for only one item selected.
 
Would you please let me know if there is anything else i could try out...
 
Thanks again!!!

JFreeman

Is there a difference in the amount of data being returned by the query when there is only 1 value selected?
 
Based on the information you have provided, the issue seems to be with the query itself when only a single value is being added.
 
It would be good to understand the timing of the events when the delay is happening. I would recommend enabling logging on the database, if it is not already, to log out when the connection from the designer occurs, what the query received is and when the data has been returned to the designer. This will give insight into the specifics of where the delay is happening.
 
I would also examine the query the database is receiving from the designer and test how long that query takes to run from the same machine as where the designer is installed but through a different application.

RobertLacasse

Thank you Jesse for your help!!!
The result returned was correct as expected every time, no matter one or multiple item(s) selected.
I will do more test...
Thanks!