The Set Field If is: 'Service Request ID' = $Service Request ID$\ I discovered something really weird. It works correctly if the change is made in the WUT. But it doesn't work when it comes from the Mid-Tier. I noticed some mention of a bug that sounded like that. I'm trying to find it now....
On Wed, Dec 15, 2010 at 3:17 PM, Grooms, Frederick W < frederick.w.gro...@xo.com> wrote: > Ok ... What is strange is I would have expected the log to show an update > where it was looking for the child by service request column instead of the > request ID (C1) of the child. > > What is your Push Field's IF statement? i.e.: 'Service Request ID on > Service Request Task' = $Service Request ID of Service Request$ > > > -----Original Message----- > From: Action Request System discussion list(ARSList) [mailto: > arsl...@arslist.org] On Behalf Of Warren Baltimore > Sent: Wednesday, December 15, 2010 2:05 PM > To: arslist@ARSLIST.ORG > Subject: Re: Parent Child Filter update problem > > ** > No. Just a simple 1 filter update. > > I tried a walk when the push field was balking and it was a bigger > disaster! > > What is weird, is one record gets updated, but not the second child.... > > -----Original Message----- > On Wed, Dec 15, 2010 at 3:00 PM, Grooms, Frederick W < > frederick.w.gro...@xo.com> wrote: > Are you doing a table walk? If you are doing multiple pushes then the > push must be in a Phase 1 filter (`!) > > Fred > > -----Original Message----- > From: Action Request System discussion list(ARSList) [mailto: > arsl...@arslist.org] On Behalf Of Warren Baltimore > Sent: Wednesday, December 15, 2010 1:55 PM > To: arslist@ARSLIST.ORG > Subject: Parent Child Filter update problem > > ** > ARS 6.3 running on Solaris > Oracle 10g > > I have 2 forms. Service Request (Parent) and Service Request Task (Child). > > I have field "Delivery Address" - 255 char field. > > I have a filter that says whenever Delivery Address != DB.Delivery Address > then run. > > The filter gets the db value and sets it to a temp field in first action - > This works fine > 2nd action updates a worklog with the temp field info. - This also works > fine. > 3rd action is my problem. I have tried it 2 ways. > > First way (partial failure) was to update all task forms that had the same > Service Request ID with a push field. This works, but only for the last > record it finds (as seen in the logs). None of the other children get > updated. The push was set to "Modify All Matching Requests". When I looked > at the logs, I also ran the sql log. It looks like the db is updating the > 2nd record but fails to do so for the first. > > SELECT C536870950 FROM T1907 WHERE C1 = 'VTSK00000000048' > UPDATE T1907 SET C536870950 = EMPTY_CLOB() WHERE C1 = 'VTSK00000000048' > SELECT C536870950 FROM T1907 WHERE C1 = 'VTSK00000000048' FOR UPDATE > Set LOB into the above row... > UPDATE T1907 SET C536870955='99 New York Avenue Washington, DC > 20001',C536870956=1309752000,C5='vvisual',C6=1292442282 WHERE C1 = > 'VTSK00000000049' > SELECT C536870950 FROM T1907 WHERE C1 = 'VTSK00000000049' > UPDATE T1907 SET C536870950 = EMPTY_CLOB() WHERE C1 = 'VTSK00000000049' > SELECT C536870950 FROM T1907 WHERE C1 = 'VTSK00000000049' FOR UPDATE > Set LOB into the above row... > COMMIT WORK > > 2nd way I tried was to do a filter guide that walks a table that lists all > tasks. That didn't work AT ALL!!!! > > Anybody have any idea what might be going on? > > > Warren R. Baltimore II > Remedy Developer > 410-533-5367 > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are" > > > > -- > Warren R. Baltimore II > Remedy Developer > 410-533-5367 > _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are" > -- Warren R. Baltimore II Remedy Developer 410-533-5367 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"