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"
