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"
