I finally got a chance to try it and it worked LJ, The current system I have sounds a lot like your data driven system. One of the big places I have EXTERNAL() is for notifications. I have a form to hold notification definitions so as something changes on a ticket it uses a filter guide to find all matching notification definitions and send them out. Because the business keeps changing its mind on what it wants notified on I had implemented a field on the definition form to hold a pseudo SQL field that is evaluated in a set of filters (first pulls back the pseudo SQL field and the 2nd uses EXTERNAL() in the Run-If to determine if the notification is valid) of the guide. I just got a new requirement that a group of user(s) needs to be notified whenever a specific field changes value.
I am able to verify that on ARS 7.6.04 SP3 (on Linux) you can use both the TR and the DB formats in the EXTERNAL() of a filter Run-If. i.e. ‘TR.STATUS’ >= “Assigned” or ‘MyField’ != ‘DB. MyField’ You can also use the Field IDs 'TR.536870923' != $\NULL$ or '536870923' != 'DB.536870923' Fred -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Longwing, LJ CTR MDA/IC Sent: Friday, September 07, 2012 10:10 AM To: arslist@ARSLIST.ORG Subject: Re: EXTERNAL in Filter Run-If Paul, I once built a system that was so data driven that we virtually never needed to modify code on, and it became to the point where they started designating which of our data changes required change tickets because some of them were so powerful that they could 'take the system down'..... -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Campbell, Paul (Paul) Sent: Friday, September 07, 2012 8:56 AM To: arslist@ARSLIST.ORG Subject: Re: EXTERNAL in Filter Run-If We use External for Table field and Set Field criteria for lookup of data where the Business processes tend to change a good bit, but I can see several places where I could see using it in a Run-If as well. A well tested data change is easier to implement than a code change at my company since we don't have to adhere to an IT change windows to make a data change. Paul Campbell | Development Team Lead | TS&D SSBL, A2R WFE, and ESP Remedy Team | Avaya Client Services | | 1145 Sanctuary Parkway Lake View II Suite 110 Alpharetta, GA 30009 | | 678-421-5342 Everyone needs deadlines. Even the beavers. They loaf around all summer, but when they are faced with the winter deadline, they work like fury. If we didn’t have deadlines, we’d stagnate. Walt Disney -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W Sent: Wednesday, September 05, 2012 1:14 PM To: arslist@ARSLIST.ORG Subject: EXTERNAL in Filter Run-If ** Has anyone tried using a TR value with the EXTERNAL keyword of a filter Run-If? I.e. Say your Run-If has EXTERNAL( $zTmpQualification$ ) If zTmpQualification is ‘STATUS’ >= “Assigned” then the filter will fire whenever the status is >= Assigned What about if zTmpQualification is ‘TR.STATUS’ >= “Assigned” . Will the Filter fire only if someone is changing the status to >= Assigned? ARS version 7.6.04 SP3 on Linux Fred _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
