The community will be in read-only from Tuesday 11:59pm (PST) to Wednesday 7:30am (PST)
The community will be in read-only from Tuesday 11:59pm (PST) to Wednesday 7:30am (PST)
Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Date and hour in the graphic of Workflow History

SOLVED
Go to solution
Highlighted
KeanChen
Super Collector

Date and hour in the graphic of Workflow History

Hi,

 

How I get the Date and hour in the graphic of Workflow History?

 

Thanks

 

Best Regards.

4 REPLIES
Jason Nichols K
Honored Contributor

Re: Date and hour in the graphic of Workflow History

That data is stored in the KWFL_WORKFLOW_INSTANCE_STEPS table.

KeanChen
Super Collector

Re: Date and hour in the graphic of Workflow History

Hi,

Thanks for your response, but How get the FL_WORKFLOW_INSTANCE_STEPS reference with request_id of proposal or project?

Thanks
Best Regards.
Jason Nichols K
Honored Contributor
Solution

Re: Date and hour in the graphic of Workflow History

You can use this code as a base for getting what you need:

 

    SELECT kwis.WORKFLOW_INSTANCE_STEP_ID 
    FROM KWFL_WORKFLOW_STEPS kws
       , KWFL_WORKFLOW_INSTANCES kwi
       , KWFL_WORKFLOW_INSTANCE_STEPS kwis
    WHERE kwi.TOP_INSTANCE_SOURCE_ID = requestID
      AND kwis.WORKFLOW_INSTANCE_ID = kwi.WORKFLOW_INSTANCE_ID
      AND kwis.WORKFLOW_STEP_ID = KWS.WORKFLOW_STEP_ID
      AND kws.STEP_NAME = '<Step Name>';

Mohit_Agrawal
Frequent Visitor

Re: Date and hour in the graphic of Workflow History

Hi Kean,

 

kwfl_workflow_instances table has a parameter top_instance_source_set_id which is Request_id (for a request or proposal).

 

You can get the workflow id from KWFL_WORKFLOWS table and use kwfl_workflow_steps table to get the step name for a workflow. Then you can use KWFL_WORKFLOW_INSTANCE_STEPS table to get the last updated time for any step.

 

Use SQL Join query for all these tables and you will get what you need.

 

Thanks!!

Mohit Agrawal

Click Kudos if you like this answer.. :)

 

//Add this to "OnDomLoad" event