Re: Workflow Order Question

[Sokol, Brian]

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
24007) 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 

   
  /* Fri Mar 20 2009 10:48:13.6040
*/UPDATE T832 SET C536870953=NULL,C536870952='
12345',C5='*',C6=1237560493 WHERE C1 = 'PR01335'

HD Tkt created: Fri Mar 20 2009 10:48:13.7750 

0 */OK

   
  /* Fri Mar 20 2009 10:48:13.7750
*/INSERT INTO T169
(C536871019,C536870977,C536870958,C536870914,C536870913,C536870912,C2600
00130,C26128,C24011,C24006,C24005,C24002,C24000,
C20012,C20007,C20006,C20005,C20004,C20003,C8,C7,
C179,C25018,C23009,C25030,C25016,C25017,C24016,C
26126,C29015,C29014,C29013,C300714900,C536870916,C536870
918,C300751500,C25022,C25021,C25015,C25014,C25013,C3
00566100,C25011,C4,C2,C24009,C25023,C25032,C250907061,C2
6129,C26131,C26132,C26504,C26011,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')

   
  /* 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: 
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 

Re: Workflow Order Question

[Nicky Madjarov]

Workflow Order QuestionBrian,

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 
  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 24007) 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 
/* Fri Mar 20 2009 10:48:13.6040 */UPDATE T832 SET 
C536870953=NULL,C536870952=' 12345',C5='*',C6=1237560493 WHERE C1 = 
'PR01335'

  HD Tkt created: Fri Mar 20 2009 10:48:13.7750 

  0 */OK

/* Fri Mar 20 2009 10:48:13.7750 */INSERT INTO T169 
(C536871019,C536870977,C536870958,C536870914,C536870913,C536870912,C26130,C26128,C24011,C24006,C24005,C24002,C24000,C20012,C20007,C20006,C20005,C20004,C20003,C8,C7,C179,C25018,C23009,C25030,C25016,C25017,C24016,C26126,C29015,C29014,C29013,C300714900,C536870916,C536870918,C300751500,C25022,C25021,C25015,C25014,C25013,C300566100,C25011,C4,C2,C24009,C25023,C25032,C250907061,C26129,C26131,C26132,C26504,C26011,C260800010,C260800110,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,NULL,NULL,NULL,0,'Order
 Placed','Purchase Order','IT Services','Help Desk 
Case',1237560493,1237560493,1237560493,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'*',0,1,1,0,0,0,0,1,'*',1,0,0,0,0,1237560493,'*',1237560493,'HD000313197')

        /* 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: 
  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 
i

Re: Workflow Order Question

[Phil Murnane]

Brian:

If I understand your model correctly, it's something like this:

hd_ticket--1:1-->purchase_request--1:n-->line_ltem--1:n-->po_number
(note this is intended to be a data relationship diagram, not a chronological 
diagram)

As a developer, rather than focusing on making sure the hd_ticket gets the 
final state of all the related data, I would focus on making sure the data 
foreign to each table is consistent at all times.  Then it doesn't matter 
if/when they change a foreign data element from a (grand)child record.  In this 
case, applying this idea results in several tasks:

1. any time po_number data is changed, make sure any summary (foreign) data on 
the line_item parent is accurately reflected
2. any time a line_item changes, make sure any summary data on the 
purchase_request parent is accurately reflected
3. any time a purchase_request changes, make sure any summary data on the 
hd_ticket parent is accurately reflected

At execution time, you'll have to make sure that 1 (above) completes before 2, 
and that 2 completes before 3.  Implementing this is fairly straightforward 
except for when concurrent updates from different users can occur.  BMC uses 
tricks like forcing a save on a child record before allowing the manual 
creation/update of a parent record.

To summarize: I'm suggesting re-engineering the workflow to avoid the data sync 
errors.  After all, you have plenty of spare time during your work day, right? 
:-^

--Phil





From: "Sokol, Brian" 
To: arslist@ARSLIST.ORG
Sent: Friday, March 20, 2009 10:45:36 AM
Subject: Re: Workflow Order Question

** Workflow Order Question 
Rick here is what I am doing. I have a purchase request 
form which has a table linked to a subform. The subform contains the items 
purchased on the purchase request. Our purchasing department goes in and adds 
the JD Edwards PO number to each line item at the time of purchase. Some 
purchase requests have more then one PO number. When the purchasing department 
has placed the order they click on a button to generate a HD ticket. Here is 
the 
order of the workflow:
 
AL sets a flag on each line item for that purchase 
request
Filter fires on modify for the line item table and pushes 
the PO number to a temp field on the purchase request form
Filter fires on modify on the purchase request form on 
modify and copies the temp Po info to the PO field  (PO = PO + PO 
Temp)
AL fires and does a Push to create the HD 
tkt
 
I know I could copy the PO numbers at the time they are set 
but I am afraid that the purchasing dept will make a mistake and then change a 
PO number. Then I would have both the old and new PO number. By doing it at 
the time of HD tkt creation I know I have the final numbers.
 
The workflow log shows the PO numbers being set on the 
purchase request form:
PO Number (536870952) =  12345 
98765
 
and then the HD tkt being created but the PO number is not 
copied:
 
(24007) = PR01333 Placed. The PO #(s) for this order are 
 
That is why I questioned if the log timings were 
accurate.
 
Brian



 From: Action Request System discussion 
list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Rick 
Cook
Sent: Friday, March 20, 2009 9:55 AM
To: arslist@ARSLIST.ORG
Subject: Re: Workflow Order 
Question

** Actually, people use LastId 
for that exact purpose all the time. 

Rick 
Sent from my Verizon Wireless BlackBerry

 From: "Sokol, Brian" 
Date: Fri, 20 Mar 
2009 09:13:02 -0400
To: 
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

Re: Workflow Order Question

[Sokol, Brian]

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 24007) 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 

   
  /* Fri Mar 20 2009 10:48:13.6040
*/UPDATE T832 SET C536870953=NULL,C536870952='
12345',C5='*',C6=1237560493 WHERE C1 = 'PR01335'

HD Tkt created: Fri Mar 20 2009 10:48:13.7750 

0 */OK

   
  /* Fri Mar 20 2009 10:48:13.7750
*/INSERT INTO T169
(C536871019,C536870977,C536870958,C536870914,C536870913,C536870912,C2600
00130,C26128,C24011,C24006,C24005,C24002,C24000,
C20012,C20007,C20006,C20005,C20004,C20003,C8,C7,
C179,C25018,C23009,C25030,C25016,C25017,C24016,C
26126,C29015,C29014,C29013,C300714900,C536870916,C536870
918,C300751500,C25022,C25021,C25015,C25014,C25013,C3
00566100,C25011,C4,C2,C24009,C25023,C25032,C250907061,C2
6129,C26131,C26132,C26504,C26011,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,'HD000313197')

   
  /* 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: 
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 

Re: Workflow Order Question

[Sokol, Brian]

Rick here is what I am doing. I have a purchase request form which has a
table linked to a subform. The subform contains the items purchased on
the purchase request. Our purchasing department goes in and adds the JD
Edwards PO number to each line item at the time of purchase. Some
purchase requests have more then one PO number. When the purchasing
department has placed the order they click on a button to generate a HD
ticket. Here is the order of the workflow:
 
AL sets a flag on each line item for that purchase request
Filter fires on modify for the line item table and pushes the PO number
to a temp field on the purchase request form
Filter fires on modify on the purchase request form on modify and copies
the temp Po info to the PO field  (PO = PO + PO Temp)
AL fires and does a Push to create the HD tkt
 
I know I could copy the PO numbers at the time they are set but I am
afraid that the purchasing dept will make a mistake and then change a PO
number. Then I would have both the old and new PO number. By doing it at
the time of HD tkt creation I know I have the final numbers.
 
The workflow log shows the PO numbers being set on the purchase request
form:
PO Number (536870952) =  12345 98765
 
and then the HD tkt being created but the PO number is not copied:
 (24007) = PR01333 Placed. The PO #(s) for
this order are 
 
That is why I questioned if the log timings were accurate.
 
Brian



From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Rick Cook
Sent: Friday, March 20, 2009 9:55 AM
To: arslist@ARSLIST.ORG
Subject: Re: Workflow Order Question


** 
Actually, people use LastId for that exact purpose all the time. 

Rick 

Sent from my Verizon Wireless BlackBerry



From: "Sokol, Brian" 
Date: Fri, 20 Mar 2009 09:13:02 -0400
To: 
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___ 

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"

Re: Workflow Order Question

[Drew Shuller]

Workflow Order QuestionBrian, 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: 
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



  __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"

Re: Workflow Order Question

[Begosh, Kevin]

I remember using that awhile ago in 6 for something like that and it
worked for me.  I have also used after submit in a AL to display that ID
in a dialog for a custom form I created.

 

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 Rick Cook
Sent: Friday, March 20, 2009 7:55 AM
To: arslist@ARSLIST.ORG
Subject: Re: Workflow Order Question

 

**

Actually, people use LastId for that exact purpose all the time. 

Rick

Sent from my Verizon Wireless BlackBerry



From: "Sokol, Brian" 
Date: Fri, 20 Mar 2009 09:13:02 -0400
To: 
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:ar
l...@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 .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___ 


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"

Re: Workflow Order Question

[Rick Cook]

Actually, people use LastId for that exact purpose all the time. 

Rick
Sent from my Verizon Wireless BlackBerry

-Original Message-
From: "Sokol, Brian" 

Date: Fri, 20 Mar 2009 09:13:02 
To: 
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___ 

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"

Re: Workflow Order Question

[Sokol, Brian]

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___ 

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"

Re: Workflow Order Question

[patchsk]

I didn't hear remedy logs being in-accurate.
If I understand correctly you are doing a push fields from your
Purchasing Form to HelpDesk Form.
Its been a while I worked on HPD5.6
Try to get the filter logs from server side. May be some other filter
on HPD is clearing out PO.
If possible paste/email the logs, that will give us more info.

On Mar 19, 12:30 pm, "Sokol, Brian"  wrote:
> 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
>
> ___
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"

Re: Workflow Order Question

[Begosh, Kevin]

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   

 

__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"