Thanks for the input Fred! I figured the issue out. Stupid developer trick. I had the permissions set incorrectly on the fields in question. It's working now.
On Wed, Dec 15, 2010 at 4:10 PM, Warren Baltimore <warrenbaltim...@gmail.com > wrote: > 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 > -- 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"
