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:[email protected]] On Behalf Of Drew Shuller
Sent: Friday, March 20, 2009 10:12 AM
To: [email protected]
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: <[email protected]>
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:[email protected]] On Behalf Of Begosh, Kevin
Sent: Thursday, March 19, 2009 6:07 PM
To: [email protected]
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
[email protected]
From: Action Request System discussion list(ARSList)
[mailto:[email protected]] On Behalf Of Sokol, Brian
Sent: Thursday, March 19, 2009 1:30 PM
To: [email protected]
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___
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"
