Thanks Nicky. That was it. My push action was taking the value from the form and not the database. That is why the logs looked OK. Thanks, Brian
________________________________ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Nicky Madjarov Sent: Friday, March 20, 2009 12:34 PM To: arslist@ARSLIST.ORG Subject: Re: Workflow Order Question ** Brian, When you have the PR open and doing some modifications on the related line items the push action actually updates the PR directly into the database. You need to refresh the content of the PO's field prior to creating HD ticket, for example, have a set firld from the same form for the same PR_ID. Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com ----- Original Message ----- From: Sokol, Brian <mailto:bso...@scholastic.com> Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Sent: Friday, March 20, 2009 11:18 AM Subject: Re: Workflow Order Question ** Hi Drew, I just tried and it also looks OK. Here are the results below. In my AL when I create the HD tkt I set the description field (ID 240000007) to: ($Request ID$ + " Placed. The PO #(s) for this order are ") + $PO Number$ Why is it that I do not see that info anywhere in the SQL log? I am by no means a SQL expert. Far from it. PO # Set:Fri Mar 20 2009 10:48:13.6040 <SQL > <TID: 0000000628> <RPC ID: 0000139219> <Queue: Fast > <Client-RPC: 390620 > <USER: ***** > /* Fri Mar 20 2009 10:48:13.6040 */UPDATE T832 SET C536870953=NULL,C536870952=' 12345',C5='*****',C6=1237560493 WHERE C1 = 'PR0000000001335' HD Tkt created: Fri Mar 20 2009 10:48:13.7750 0 */OK <SQL > <TID: 0000003008> <RPC ID: 0000139221> <Queue: Fast > <Client-RPC: 390620 > <USER: ***** > /* Fri Mar 20 2009 10:48:13.7750 */INSERT INTO T169 (C536871019,C536870977,C536870958,C536870914,C536870913,C536870912,C2600 00130,C260000128,C240000011,C240000006,C240000005,C240000002,C240000000, C200000012,C200000007,C200000006,C200000005,C200000004,C200000003,C8,C7, C179,C250000018,C230000009,C250000030,C250000016,C250000017,C240000016,C 260000126,C290100005,C290100004,C290100003,C300714900,C536870916,C536870 918,C300751500,C250000022,C250000021,C250000015,C250000014,C250000013,C3 00566100,C250000011,C4,C2,C240000009,C250000023,C250000032,C250907061,C2 60000129,C260000131,C260000132,C260000504,C260100001,C260800010,C2608001 10,C300265600,C300751400,C300836800,C3,C5,C6,C1) VALUES ('PO001279D84E93O6zDSQuoBXBAqAYC','ITCC Purchasing NY','Brian',1237560489,'Information Technology','Sokol',1,3,3,'ITCC Purchasing NY','*****','212-343-6494','*****','New York','557 Broadway','3003','Order Placed','Purchase Order','IT Services','IT Purchasing Purchase Order Submitted',4,'AG001279D84E93razDSQEj5ZBAPQoC','1020','MAINHELPDESK',2,NU LL,NULL,NULL,0,'Order Placed','Purchase Order','IT Services','Help Desk Case',1237560493,1237560493,1237560493,NULL,NULL,NULL,NULL,NULL,0,NULL,N ULL,'*****',0,1,1,0,0,0,0,1,'*****',1,0,0,0,0,1237560493,'*****',1237560 493,'HD0000000313197') <SQL > <TID: 0000003008> <RPC ID: 0000139221> <Queue: Fast > <Client-RPC: 390620 > <USER: ***** > /* Fri Mar 20 2009 10:48:13.7750 */OK ________________________________ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Drew Shuller Sent: Friday, March 20, 2009 10:12 AM To: arslist@ARSLIST.ORG Subject: Re: Workflow Order Question ** Brian, could you use a SQL log to confirm the information in the Workflow log? Drew From: "Sokol, Brian" Date: Fri, 20 Mar 2009 09:13:02 -0400 To: <arslist@ARSLIST.ORG> Subject: Re: Workflow Order Question Hi Kevin, No I can not use that. I need this at the time the tkt is created so that it is part of the email that is sent out at tkt creation. My original question is about workflow timing and the log file. Do the events occur in the same order as they appear in the log? The logs show the PO numbers getting populated before the HD tkt creation but they are not being pushed to the HD tkt at creation. ________________________________ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Begosh, Kevin Sent: Thursday, March 19, 2009 6:07 PM To: arslist@ARSLIST.ORG Subject: Re: Workflow Order Question ** I am sure someone will tell me if I am wrong but I think you might be able to use the last ID keyword.. I think Kevin Begosh, RSP Tech Ops Enterprise Business Services 301-791-3540 Phone 410-422-3623 Cell kevin.beg...@lmco.com From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Sokol, Brian Sent: Thursday, March 19, 2009 1:30 PM To: arslist@ARSLIST.ORG Subject: Workflow Order Question ** We have a custom purchasing application in Remedy. At the end of the purchasing process a Help Desk ticket (HD 5.6) is created. I am trying to populate the description field with our back end purchase order number. The Remedy purchase request may have more then 1 PO#. At the time that the HD tkt is created I am populating a field on the purchasing form with the PO numbers (they are on a sub form). The description field is not getting the PO number. I thought this was might be caused by the HD tkt being created before I populate the field with the PO numbers. I turned on AL and Filter logging and according to the logs the PO field is being populated and then the HD tkt is being created. So is the timing in the logs accurate? If so any idea why this is happening? Brian Sokol Manager, Desktop Services Scholastic Inc. 557 Broadway NY, NY 10012 (212) 343-6494 http://www.Scholastic.com <http://www.Scholastic.com> __Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"
