Thanks, Fred! Re: "You may have to look in the filter logs to see what is going on." That is where I got the "**** Error while performing filter action: Error 38" message. I guess I should have said that.
Dwayne ---- Original message ---- >Date: Thu, 16 Oct 2008 12:24:15 -0500 >From: "Grooms, Frederick W" <[EMAIL PROTECTED]> >Subject: Re: Creating subfile records from list on submit >To: arslist@ARSLIST.ORG > >Error 38 is "Filter or escalation set field process returned an error." > >A filter or escalation was performing a Set Fields action using the >option to run a process and return a value, but the process returned an >error message. The text of the message returned is displayed with this >error. The error terminates the operation being performed, and the >current transaction is rejected. No update to the database occurs. > > >The Filter Set Fields action is $PROCESS$ Application-Generate-GUID >which is what you have. You may have to look in the filter logs to see >what is going on. > >Fred > > >-----Original Message----- >From: Action Request System discussion list(ARSList) >[mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin >Sent: Thursday, October 16, 2008 12:03 PM >To: arslist@ARSLIST.ORG >Subject: Re: Creating subfile records from list on submit > >Yes, it's 255. > >Dwayne > >---- Original message ---- >>Date: Thu, 16 Oct 2008 11:26:07 -0500 >>From: "Grooms, Frederick W" >>Subject: Re: Creating subfile records from list on submit >>To: arslist@ARSLIST.ORG >> >>Just off hand ... Is your Temp ID field at least 38 characters big? >> >>-----Original Message----- >>From: Action Request System discussion list(ARSList) >>[mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin >>Sent: Thursday, October 16, 2008 11:21 AM >>To: arslist@ARSLIST.ORG >>Subject: Re: Creating subfile records from list on submit >> >>Thank you, Joe and Frederick ! >> >>I am trying the "Application-Generate-GUID" method. >>My Filter does a "Set Fields" that sets a "Temp ID" field to: >>$PROCESS$ Application-Generate-GUID >> >>I get, "**** Error while performing filter action: Error 38" >> >>I couldn't find anything about Error 38 in the BMC Knowledge Base. >> >>I tried putting quotes around "Application-Generate-GUID" even tho I >>knew that was wrong, but got the same error. >> >>Any idea what I am doing wrong? >> >>Dwayne >> >>---- Original message ---- >>>Date: Wed, 15 Oct 2008 14:22:45 -0700 >>>From: Joe DeSouza >>>Subject: Re: Creating subfile records from list on submit >>>To: arslist@ARSLIST.ORG >>> >>> ** >>> You could also have the system generate a GUID on >>> the parent record and store it in a hidden field >>> that you could use to bind the child records to the >>> parent record by pushing the GUID instead of the >>> EntryID.. Create the GUID on opening the parent >>> record if the GUID field is null, and use this. >>> >>> Use Application-Generate-GUID in a Set Fields Run >>> process to generate it. >>> >>> Joe >>> ----- Original Message ---- >>> From: "Grooms, Frederick W" >>> To: arslist@ARSLIST.ORG >>> Sent: Wednesday, October 15, 2008 4:49:33 PM >>> Subject: Re: Creating subfile records from list on >>> submit >>> >>> We put a Display Only "Processing ID" field on the >>> 3rd form and have the main form push to the 3rd form >>> (Standard Phase 2 action). All workflow on the 3rd >>> form takes into account if Processing ID is Null or >>> not. i.e. Data validation takes place if Processing >>> ID = $NULL$. If Processing ID != $NULL$ then it >>> pushes data to the subform (again standard Phase 2 >>> action). >>> >>> Just to keep things clear we rename Modified Date >>> and Last Modified By to Touched Date and Touched By >>> and have our own Modified Date and Last Modified By >>> fields that are filled in by a filter when >>> Processing ID = $NULL$. >>> >>> Fred >>> >>> -----Original Message----- >>> From: Action Request System discussion list(ARSList) >>> [mailto:[EMAIL PROTECTED] On Behalf Of Dwayne >>> Martin >>> Sent: Wednesday, October 15, 2008 3:44 PM >>> To: arslist@ARSLIST.ORG >>> Subject: Creating subfile records from list on >>> submit >>> >>> Dear List, >>> >>> I have a main form and a subfile form. The subfile >>> has two (actually more, but this is just for >>> illustration) fields, a Parent ID field that >>> contains the Entry ID of the main form, and an Info >>> field. On submission of the main form, I use a >>> filter to retrieve a list from a third form, then >>> process that list to create subfile entries. Eg, it >>> would retrieve a list like: >>> >>> abcde >>> hijkl >>> mnopq >>> >>> Then if the main form Request ID is 87 it should >>> produce subfile entries >>> of: >>> >>> Parent ID: 87 >>> Info: abdde >>> >>> Parent ID: 87 >>> Info: hijkl >>> >>> Parent ID: 87 >>> Info: mnopq. >>> >>> So, on submission of the main form, filters process >>> the list, and move each entry on the list into a >>> temp field and do a Push Field to create the subfile >>> record. >>> >>> Here's the problem. Push Fields get deferred to >>> phase 2, and by that time the temp field is >>> overwritten so no subfile records get created. If I >>> add `! to the end if the filter name, the filter >>> runs in phase 1, but the main form Entry ID hasn't >>> been created yet. >>> >>> The ideal would be to run the workflow in an Active >>> Link "After Submit," but there are times when the >>> main form itself is created via Push Field action, >>> so the Active Links won't run. >>> >>> Any suggestions? >>> >>> (ARS 7.1, patch 3, RH Linux server, Oracle 10.2 db) >>> >>> Dwayne Martin >>> James Madison University >> > >_______________________________________________________________________________ >UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"