"If you issue the submit - and have not populated 179 - and then do a set fields in a filter say field-179-copy = $179$, I expect you will find a null on field-179-copy. (I have not done this.)"
Well, I think you should. I think you'll be surprised with the results. I never said that field 179 required a completed commit to the database. Yes, I said that about field Id 1. In that regard, I was wrong. Scott Parrish IT Prophets (770) 653-5203 www.itprophets.com From: Ben Chernys [mailto:[email protected]] Sent: Tuesday, December 07, 2010 2:32 AM To: [email protected] Subject: RE: GUID FIELD 179 Hi Scott, I am not wrong. If you issue the submit - and have not populated 179 - and then do a set fields in a filter say field-179-copy = $179$, I expect you will find a null on field-179-copy. (I have not done this.) Neither 1 not 179 require "a completed commit to the db". They are set automatically by the arserver code before doing the update sql statement but after the set of filters (phase 1) have fired. In the case of 179 if and only if it is not in the transaction on the submit nor set by wf - possibly not set to null by wf. The only advantage of 179 (and it is a big advantage) is that you can build your child records before the parent is saved (hopefully remembering to clean up those children when the parent is not saved) by setting a value with wf before the set of filters are done - thereby allowing the server code to skip its setting. As for auto-populate, it works as I have described above since the invention of the field in 6.3 (as you correctly identified its introduction) with this from the 6.3 arstruct.h /* Reserved for the GUID (Globally Unique */ /* ID) field of the current schema object.*/ /* The field will be a character field */ /* with the length of 38 characters. */ #define AR_RESERV_GUID 179L I note the comments have not been changed since (up to 7.6.03) though indeed the "Global-ness" aspects have been improved as have the database SQL issues with its early releases. Note also that it MUST be 38 characters else it is NOT considered a GUID field for auto-population. Cheers Ben Ben Chernys Senior Software Architect Software Tool House Inc. Canada / Deutschland / Germany Mobile: +49 171 380 2329 GMT + 1 + [ DST ] Email: Ben.Chernys _AT_ softwaretoolhouse.com<mailto:[email protected]> Web: www.softwaretoolhouse.com<http://www.softwaretoolhouse.com> Check out Software Tool House's free Diary Editor. Meta-Update, our premium ARS Data tool, lets you automate your imports, migrations, in no time at all, without programming, without staging forms, without merge workflow. http://www.softwaretoolhouse.com/ www.softwaretoolhouse.com From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Scott Parrish Sent: December-07-10 06:48 To: [email protected] Subject: Re: GUID FIELD 179 ** All, I believe the confusion surrounding field ID 179 is this: Prior to ARS 6.3, if you wanted to use a GUID for creating parent/child relationships, the GUID had to be created using the Application-Generate-GUID process (there was no field Id 179). In ARS 6.3, Remedy introduced field ID 179. This field is auto-populated by the system and is available throughout all three phases of filter processing (unlike the Request ID field). By adding field ID 179 to a form you can push the value of the field in a Phase 1 filter push that executes on submit (even though you have not specifically set the field's value). In addition, the value is also available for any active link push fields that execute on Submit. Chris Woyton's email below points out that the auto-population of this field does not work prior to 7.5. I cannot attest to whether it works in 6.3, but I know it works in 7.0 and above. Ben is correct, except that field ID 179 behaves differently than field ID 1. The value of field Id 179 is available immediately upon submit (population of the field does not rely upon the completed commit to the database). I hope I have not further confused the situation. Scott Parrish IT Prophets (770) 653-5203 www.itprophets.com<http://www.itprophets.com> From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Ben Chernys Sent: Tuesday, December 07, 2010 12:29 AM To: [email protected] Subject: Re: GUID FIELD 179 ** The GUID field has always (since its invention) been automatically populated ON SUBMIT - that is when all workflow has fired and the record is being written to the database - much like field 1. If you need it ahead of that (in filters or ALs) then you need to populate it. Cheers Ben Chernys www.softwaretoolhouse.com<http://www.softwaretoolhouse.com> From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Chris Woyton Sent: December-07-10 05:14 To: [email protected] Subject: Re: GUID FIELD 179 ** The GUID isn't automatically populated in earlier versions of ARS (I believe 7.5 is the first version which does). For lower versions you need to use a run process as you have been doing. Sounds like there's either a documentation bug or you're looking at a newer help file. On Mon, Dec 6, 2010 at 9:19 AM, Gadgil, Abhijeet <[email protected]<mailto:[email protected]>> wrote: Potentially you could write an active link on say lose focus of a field to call $PROCESS$ @@:Application-Generate-GUID and set the output to a field on the form This way you will have the GUID created. Now when you save / submit the request then an entry will be created in database. This way you can have the GUID created even before a entry is created at the database level hope that helps Regards, Abhijeet The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. ________________________________ From: Action Request System discussion list(ARSList) [ _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
