Posted by [IP Address: 130.102.189.200] 'Crystal Golding' on July 30, 2001 at 00:57:54 EST:
I'm using PeopleTools version 7.58 and student admin for ANZ 7.60. I have created workflow that emails new applicants once their email address is enteredusing Application Agents. WF PeopleCode is on the EMAIL_ADDRESS record and the business event is triggered from in the ADM_APPL_ENTRY1 panel group, which contains the WF_FUNCTIONS_01 and APPR_WRK_01 panels.
My email has data from PERS_DATA_EFFDT, ACAD_PROG_TBL, TERM_VAL_TBL, ADM_APPL_PROG, ADM_APPLCTR_TBL, ADM_APPL_DATA and EMAIL_ADDRESSES.
All is ok except when I enter a new applicant who has more than one email address. When I do this, the email for the first email type contains all the data from all the records. The subsequent emails however contain only data from the ADM_APPLCTR_TBL and ADM_APPL_DATA records. All other data fields are blank in the second and latter emails.
Also, I have created a role for the OPRID entering the application. Using a role query and bind variables I can extract the operator's email address into the email. The format of the email address comes as ";email@somewhere.com". I am guessing the semi-colon is because I had to create the role query with a SELECT DISTINCT to prevent duplicate rows (as Query links in application security tables). How can I get rid of the semi-colon?