<p>I am using the FType iHub with BIRT OS Developer. I have data with a field that corresponds to security groups in iHub. I put the code below in the beforeOpen script on the DATA SET. I have created a MultiSelect Parameter called SecurityRoles.</p>
<p> </p>
<p>How do I set the parameter SecurityRoles equal to the aclArray in the beforeOpen script so I can use it is a WHERE condition in the DATA SET?</p>
<p> </p>
<div>function createAclArrayinBDPro(array){</div>
<div> var myStr = "";</div>
<div> for(var i in array){</div>
<div> myStr = myStr + array
+ ",";</div>
<div> logger.warning (myStr);</div>
<div> }</div>
<div> myStr = myStr.substring(0,myStr.length -1);</div>
<div> return myStr;</div>
<div>}</div>
<div> </div>
<div>function createAclArrayinServer(arraylist){</div>
<div> var myStr = "'";</div>
<div> for(i=0; i<arraylist.size(); i++){</div>
<div> myStr = myStr + arraylist + "','"; </div>
<div> }</div>
<div> myStr = myStr.substring(0,myStr.length-2);</div>
<div> return myStr;</div>
<div>}</div>
<div> </div>
<div> </div>
<div>var serverContext = reportContext.getAppContext().get("ServerContext");</div>
<div>var aclArray = "";</div>
<div> </div>
<div>// check to see if it's run on the server (BIRT Designer Pro or iHub)</div>
<div>//</div>
<div>if(serverContext.getVolumeName() == null) {</div>
<div>aclArray = createAclArrayinBDPro(reportContext.getAppContext().get("USER_ACL"));</div>
<div>}</div>
<div>else {</div>
<div>aclArray = createAclArrayinServer(serverContext.getUserRoles());</div>
<div>}</div>
<div> </div>
<div>theUsername = reportContext.getAppContext().get("ServerUserName") ;</div>
<div> </div>
