Re: Verify Query and Field values
Okgranted...I have never tried a push to a dynamic form, static field...and then use a setfield with the Copy-Field-Value...I'd never considered doing it in that particular combination. Sounds a bit like a backhanded way of doing itbut you're right...would likely work...if you did a push of two fields into tmp fields...the value you want to set, and the field you want to set it intoand then have a filter on destination that takes the value and copies it to that fieldyea that would work...:) Thank you Carey...puts another tool in my bag...:) -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Carey Matthew Black Sent: Thursday, December 04, 2008 9:27 PM To: arslist@ARSLIST.ORG Subject: Re: Verify Query and Field values LJ, Uh.. maybe you can... (You did not mention what ARS version your using... but I think this function may also be in 6.3, but not Supported yet. ) Have you looked at this special run process ? Ref: Workflow-Objects-710.pdf , Pg 204. Application-Copy-Field-Value target_field_ID source_field_ID Copies a field on the current form to another field on the current form. Returns one of the following integers: 1-Indicates that the assignment failed. 0-Indicates that the assignment occurred. Yes this does not do a Push to the target form. However that can be done to a dynamic form name. You just need to set up a message bus that allows you to send one (or if you get really crazy more than one in the same push actions) field value change to the target record(s) and have filters on the targets that parse the message and set the local fields during the Modify. -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. On Thu, Dec 4, 2008 at 7:43 PM, LJ Longwing [EMAIL PROTECTED] wrote: NevermindGot it...:)This is for anyone else who wants to do something similar snip Oh...and in case anyone is wondering why I'm doing thisI need to be able to set a dynamic field, on a dynamic form with a dynamic value. I can't do this with advanced workflow because the field ID can't be dynamic...:)...just working around limitations of the appthis will allow me to specify via workflow what form I want the update to be performed on, with what qual, and set a dynamic field with a verified valid valuevery nice...because I was doing this through direct SQL previously...which I didn't like doing. ___ 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
Re: Verify Query and Field values
NevermindGot it...:)This is for anyone else who wants to do something similar Here is some basics just to help you out below...I have a form with 4 fields...Form, Query, Field, Value, these represent the form I want to update, the query I want to perform to do the update, the field I want to update, and the value I want to change that field to. Application-Parse-Qual $Form$ $Query$ This verifies that the form and qualification specified works...you can easily throw the results away... Application-Map-Names-To-Ids $Form$ $$Field$$ The second set of $ around $Field$ makes it look for that field...I don't want to have the $ around my field in my record...so I added it in the Filter...this gives me the Field ID of the field in question...which I use in the next statement Application-Parse-Val-SField $Form$ $Field ID$ $Form$ $Value$ This turns a set/push action into an internal representation...which I don't really care about...but if it errors out that means that if doing a setfield on 'current form' to the field I specified in the above filter to the value specified is invalid. So with these three filters, or I guess...3 actions in a single filter, I can verify that all 4 pieces of my record are valid optionswhich will hopefully ensure that my external program won't bomb because any one of them isn't 100% accurate. Oh...and in case anyone is wondering why I'm doing thisI need to be able to set a dynamic field, on a dynamic form with a dynamic value. I can't do this with advanced workflow because the field ID can't be dynamic...:)...just working around limitations of the appthis will allow me to specify via workflow what form I want the update to be performed on, with what qual, and set a dynamic field with a verified valid valuevery nice...because I was doing this through direct SQL previously...which I didn't like doing. -Original Message- From: LJ Longwing [mailto:[EMAIL PROTECTED] Sent: Thursday, December 04, 2008 5:06 PM To: arslist@ARSLIST.ORG Subject: Verify Query and Field values I'm working on a console that will allow for updates of data through an external program. I would like to verify that the Form, Query, Field, and Field value that they are choosing are valid before I call my external program. I found this runprocess that allows me to validate the Query Application-Parse-Qual form qualification_string This verifies that the Form and Qualification string are valid by converting them to an 'internal representation'...which I don't actually want...but it serves my purposes at the momentwhat I can't find is verification that the field they have specified to update, and the value they want to put in it are valid and won't violate any rules that Remedy has in place. For example if I have a selection field with values No/Yes, and they specify that field, I would like to throw an error if they specify that they want to set it to 'Heck Yes'or if they are wanting to set a Character field with 200 characters, but the field has a limit of 50, my program will error when trying to set it, guaranteed...but I want to catch it before I call my external program. Any suggestions? ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Verify Query and Field values
LJ, Uh.. maybe you can... (You did not mention what ARS version your using... but I think this function may also be in 6.3, but not Supported yet. ) Have you looked at this special run process ? Ref: Workflow-Objects-710.pdf , Pg 204. Application-Copy-Field-Value target_field_ID source_field_ID Copies a field on the current form to another field on the current form. Returns one of the following integers: 1—Indicates that the assignment failed. 0—Indicates that the assignment occurred. Yes this does not do a Push to the target form. However that can be done to a dynamic form name. You just need to set up a message bus that allows you to send one (or if you get really crazy more than one in the same push actions) field value change to the target record(s) and have filters on the targets that parse the message and set the local fields during the Modify. -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. On Thu, Dec 4, 2008 at 7:43 PM, LJ Longwing [EMAIL PROTECTED] wrote: NevermindGot it...:)This is for anyone else who wants to do something similar snip Oh...and in case anyone is wondering why I'm doing thisI need to be able to set a dynamic field, on a dynamic form with a dynamic value. I can't do this with advanced workflow because the field ID can't be dynamic...:)...just working around limitations of the appthis will allow me to specify via workflow what form I want the update to be performed on, with what qual, and set a dynamic field with a verified valid valuevery nice...because I was doing this through direct SQL previously...which I didn't like doing. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
