Project and Portfolio Management Practitioners Forum
cancel

[QUESTION] SQL Query

Highlighted
rgdalisay
Contributor.

[QUESTION] SQL Query

Salutations,

 

Do you guys have any idea on how to query this?

Kindly see attached screenshot.

 

Really appreciate if you could advice on what tables to look for them.

 

Thanks in advace.

3 REPLIES
erik_c
Respected Contributor.

Re: [QUESTION] SQL Query

Hi,

 

Take a peek at KWFL_STEP_TRANSACTION_HISTORY - you'll have to join to a couple other tables to complete the picture but that should get you started.

Nick Bucher
Trusted Contributor.

Re: [QUESTION] SQL Query

An easy way to get the SQL query is to use the JDBC Logging.

 

You can activate the JDBC logging at runtime in the workbench.

It is in the menu under Edit->Debug Settings

Then you have to tick Enable JDBC Logging... After that you should open a request in the browser.

Then you should deactivate the login as fast as possible, so the JDBC log file stay small...

 

You find the JDBC logfile with your query in the log directory of your application server.

 

Regards, Nick

Utkarsh_Mishra
Acclaimed Contributor.

Re: [QUESTION] SQL Query

Here you go...

 

Shortcut:

 

select  * from KWFL_STEP_TRANSACTION_HIST_V where TOP_INSTANCE_SOURCE_SET_ID =<Request ID..>

 

or

 

select LAST_UPDATED_BY, LAST_UPDATE_DATE from KWFL_STEP_TRANSACTIONS

WHERE WORKFLOW_STEP_ID =(SELECT WORKFLOW_STEP_ID FROM KWFL_WORKFLOW_STEPS_NLS WHERE STEP_NAME

LIKE'<--your step name--->')

AND WORKFLOW_INSTANCE_STEP_ID in(select WORKFLOW_INSTANCE_STEP_ID

from KWFL_WORKFLOW_INSTANCE_STEPS WHERE WORKFLOW_INSTANCE_ID IN

(select WORKFLOW_INSTANCE_ID from KWFL_WORKFLOW_INSTANCES

where INSTANCE_SOURCE_ID =<--Reuqest ID-->)) ;

....

 

 

Cheers..
Utkarsh Mishra

-- Remember to give Kudos to answers! (click the KUDOS star)