Using a multivalue parameter in an in clause

JasonW

Example beforeOpen Script

var parmcount = params["parmorders"].value.length
var whereclause = "";
if ( parmcount > 0 ){
  whereclause = " where customernumber in ( "
}
for ( i=0; i < parmcount; i++ ){
  if( i == 0 ){
	whereclause = whereclause + params["parmorders"].value[i];
  } else {
	whereclause = whereclause + " , " + params["parmorders"].value[i];
  }
}
if ( parmcount > 0 ){
  this.queryText = this.queryText + whereclause + " ) ";
}