The first Remedy project I worked on, I was under the tutelage of an experienced Remedy consultant. He spoke of one of his first projects, where he was tasked with making some changes to an existing Remedy (probably v2.0) system. He opened the Admin tool, and found no Active Links or Filters. The reason? The person who built the system was a DBA who had built the entire system to run on Stored Procedures. I know that using Direct SQL isn't taking it to that extreme, but the point is that you need to consider the fact that whoever follows you might not be as much of a SQL expert as you feel you are. Good code is code that someone else can pick up and go with when you're not there to explain it to them.
Rick On Wed, Jun 2, 2010 at 6:09 AM, Donald Morton <[email protected]>wrote: > 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:[email protected]] On Behalf Of Matt Worsdell > Sent: Wednesday, June 02, 2010 4:43 AM > To: [email protected] > 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<http://old.nabble.com/ARERR-299-Too-many-levels-in-filter-processing-tp28750990p28750990.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" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
