Hi Misi, I have not tried EXTERNAL() in Filter Run-If's....but will try it.
Most of time I have ended up using EXTERNAL() in table fields and actually it has worked out really well for us.We actually have a data manager form which tracks what external call was set at what time and what was the exact query on field that drives EXTERNAL(). Also, I have found "arlogdisplay" quite helpful in troubleshooting EXTERNAL().I have not yet digged in depth about SQL part..but yes I do agree if someone deletes a field which is part of a qualification then you might have an orphan reference of that field in the query. Thanks Chintan. --- On Thu, 9/6/12, Misi Mladoniczky <m...@rrr.se> wrote: From: Misi Mladoniczky <m...@rrr.se> Subject: Re: EXTERNAL in Filter Run-If To: arslist@ARSLIST.ORG Date: Thursday, September 6, 2012, 10:02 PM Hi, Why don't you try it then? In very rare circumstances EXTERNAL() is really needed. It has many of the bad side effects that direct SQL has, it the sense that what happens in an EXTERNAL()-qualification is not accessible to an analyzing tool. Filed references etc is more or less impossible to follow... Best Regards - Misi, RRR AB, http://rrr.se > I so want this functionality if it exists! :) > > Thanks > Chintan. > > --- On Wed, 9/5/12, Grooms, Frederick W <frederick.w.gro...@xo.com> wrote: > > From: Grooms, Frederick W <frederick.w.gro...@xo.com> > Subject: EXTERNAL in Filter Run-If > To: arslist@ARSLIST.ORG > Date: Wednesday, September 5, 2012, 11:13 AM > > ** > > > > > > > > > > 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 > > > > > > > _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
