Right, I think Joe and I are trying to suggest using an ActiveLink and not a filter :-)
Brien On Thu, Oct 16, 2008 at 11:34 AM, Grooms, Frederick W < [EMAIL PROTECTED]> wrote: > A Filter does not use the @@: syntax (Evidenced by the v7.1.0 filter "AR > System Email GUID Generator") > I pulled the 38 length from Field 179 on the stock ARS form "AR System > Email Association" > > > Dwayne, > Out of curosity, try changing the field to 38 characters long (maybe > the command does not like fields 255 characters long. > > Fred > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of Joe DeSouza > Sent: Thursday, October 16, 2008 1:07 PM > To: arslist@ARSLIST.ORG > Subject: Re: Creating subfile records from list on submit > > The syntax for setting this as pointed out by Brien is $PROCESS$ > @@:Application-Generate-GUID > > The field doesn't have to be 255 characters long.. In fact its a BAD > idea to have it that long as you will not be able to INDEX that field. > > You are storing this ID here for the purpose of relationships, which > means your workflow would search this field to tie the records. If you > do not index this field, good luck performance-wise - actually wishing > you that will not help. What would help is to reduce the number of > characters from 255 to 30. GUID's are no longer or shorter than 30 > characters. Anything more is a waste of space. Anything less you're > shooting yourself in your foot.. > > Joe > > PS: Forgot in my previous emails that some of you have a problem on > lotus notes receiving mails in a non plain text format. So hope you'll > receive this in an acceptable format.. > > > ----- Original Message ---- > From: "Grooms, Frederick W" <[EMAIL PROTECTED]> > To: arslist@ARSLIST.ORG > Sent: Thursday, October 16, 2008 1:24:15 PM > Subject: Re: Creating subfile records from list on submit > > 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" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
