General Info. Action * GetEmployees Description Action Class * com.bgs.db.events.BuidXMLView com.bgs.db.events.CloneRecords com.bgs.db.events.DBMetaDataAction com.bgs.db.events.ExportWizardAction com.bgs.db.events.GenericAction com.bgs.db.events.ImportWizardAction com.bgs.db.events.OnDemandSQLAction com.bgs.db.events.PassThruAction com.bgs.db.events.ReloadPropertiesAction com.bgs.db.events.ReportGenerateAction com.bgs.db.events.ReportWizardAction com.bgs.db.events.ShowPrinterFriendlyView com.bgs.db.events.SQLAction com.bgs.db.events.SQLManExecute com.bgs.db.events.SRDBOGenerator com.bgs.db.events.SRDefGenerator com.bgs.eai.SRSubmit javascript Scope * Record Global Validation Access Type * Default Read Only BS_AP_SCRIPT= BS_SCRIPT=StringBuffer ids\=new StringBuffer();\r\nStringBuffer names\=new StringBuffer();\r\n\r\nObject[][] data\=com.bgs.db.ConnectionManager.getInstance().getData("DemoDB","SELECT CONTACT_ID,LAST_NAME||','||FIRST_NAME||' '||MI FROM CRM_CONTACTS WHERE REL_TYPE\='Employee'",2);\r\nfor (int i\=0;i<data.length;i++){\r\n ids.append("|");\r\n ids.append(data[i][0]);\r\n names.append("|");\r\n names.append(data[i][1]);\r\n}\r\n\r\nif (ids.length()>0){\r\n ACTION_MSG\=ids.toString().substring(1)+"\#"+names.toString().substring(1);\r\n}else{\r\n ACTION_MSG\="";\r\n} Visual Display Order Icon Confirm Message Target Window WorkFlow Forwarding Failure Page