05-13-2009 03:41 PM
We have the following scenario:
Project workflow changes from
Step 3 (Project Complete - Final Review)
Step 4 (Project Completed - Exit - Success)
When a user takes action on Step 2 decision step to complete the project, the workflow would go to a manual decision step 3 (Project Complete - Final Review status).
In the project request type, how could we add a field which would be automatically populated and visible when step 2 goes to step 3?? This field should include the date and time when the change from step 2 to step 3 occured. We would like the user to see the date/time when the action on Step 2 was taken to go to step 3 of the project.
In the database, kcrt_transactions table gives this transaction history. But to add it to the request, how should I go about, and what are the tokens I should use, along with validation to implement this kind of field in project request type?
Thanks in advance for your help!
I was wondering if it is possible to add the status and date/time field in a project flow.
05-13-2009 10:21 PM
Please add a execution step after Decision step 2.
In that execution step write a 'ksc_store' command like the one below
ksc_store REQ.TOKEN_NAME = sysdate
I am not 100% sure whether it will work, but it is worth to give a try.
05-14-2009 03:35 AM
If you just want to track data between two steps then i would suggets you to use the Dynamic Rule in the request on before save which will store the curent date and time in the fields.
But the data in this field will change at each time whenever you will move to nexts step or will save the request.
Hope this will help you.
05-14-2009 10:06 AM
This field would display the date and time when the project was approved in Step 1 and moved over to Step 2 (Complete) - which is sort of officially the completion stage of the project.
Any thoughts? Thanks!
05-14-2009 01:02 PM
We need to have a field which would be populated with the date/time stamp when the project was moved from Step 1(Approval) to
Once we have this field, we would have it displayed in Search Requests, so that users could search the project request type using this date field to display when the projects moved from Step 1 to Step 2. They want a field in the request itself, so when they open up any project which has been closed, they should see this field displaying the date only for step where it transition from step 1 to step 2.
Would be lovely if you could brainstorm on this one!!!
08-25-2009 05:02 PM
Workflow Scope: Requests
Execution Type: Workflow Step Commands
Page Response: Finish Execution before displaying the request page to the user
Command: ksc_store TARGET_DATE_FIELD_TOKEN="[SYS.ITG_TIME_STAMP]","[S
This works with PPM 7.5