It's not like using an overpowered ability in a video game. Just because you can do something doesn't necessarily mean it's a good idea. It's just begging for some kind of data integrity issue. What if BMC changes the underlying table structures? Plus, if you ever switch databases, the SQL will have to change.
-----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Matt Worsdell Sent: Wednesday, June 02, 2010 4:43 AM To: arslist@ARSLIST.ORG Subject: Re: ARERR 299 Too many levels in filter processing I fail to see why, Direct SQL is a legitimate built in option. > Hi, > > Direct SQL makes a system hard to manage. If there are built in options > other than Direct SQL, use them instead! > > Best Regards - Misi, RRR AB, http://www.rrr.se > > Products from RRR Scandinavia: > * RRR|License - Not enough Remedy licenses? Save money by optimizing. > * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. > Find these products, and many free tools and utilities, at http://rrr.se. > >> Another option would be to use a Direct SQL Action. >> >> Matt >> >> >>> Hi fellow listers, >>> >>> This is something which i had tried. >>> >>> My need was to change a field value in a form after a record is >>> submitted/modified and the record for which i need the field value >>> change >>> to >>> be made is the one which got submitted/modified. >>> >>> So I created a filter which gets triggerred(i.e on action Submit and >>> Modify)and then do a push field and change the value in the field for >>> the >>> same form-record. >>> >>> Now my problem here is that as I am doing the push in the same form for >>> changing a value in the field, "ARERR 299 Too many levels in filter >>> processing" occurs. I know this happens because the Push field action >>> ultimately triggers a submit/modify action on the same form and the >>> filter >>> get triggerred infinitely. >>> >>> Can anyone suggest me a different approach to this? >>> >>> Cheers :) >>> -- >>> View this message in context: >>> http://old.nabble.com/ARERR-299-Too-many-levels-in-filter-processing-tp2 8750990p28750990.html >>> Sent from the ARS (Action Request System) mailing list archive at >>> Nabble.com. >>> >>> ________________________________________________________________________ _______ >>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >>> attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are" >>> >>> >> >> ________________________________________________________________________ _______ >> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >> attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are" >> >> -- >> This message was scanned by ESVA and is believed to be clean. >> > > ________________________________________________________________________ _______ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are" > > ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are" This email and any files transmitted with it are confidential and intended solely for the individual or entity to whom they are addressed. If you have received this email in error destroy it immediately. *** Walmart Confidential *** _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
