Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

[QUESTION] SQL Query

Highlighted
rgdalisay
Occasional Advisor

[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
Regular Collector

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
Super Collector

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
Honored 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)
//Add this to "OnDomLoad" event