Project and Portfolio Management Practitioners Forum
cancel

Transaction Details Page

Highlighted
PPMRam
Super Contributor.

Transaction Details Page

Hi All,

 

Need help in finding the query used in data displayed on the Transaction Details page. Transaction Details link exist under Status section of the request. Is it possible to get the query? Able to find the jsp page details but not able to find the query details for that page.

 

Thanks in advance........

 

 

Regards,

 

5 REPLIES
Mohit_Agrawal
Outstanding Contributor.

Re: Transaction Details Page

Hi..

 

You can use below tables to get transaction details.

 

KWFL_STEP_TRANSACTION_HISTORY,

KWFL_STEP_TRANSACTIONS

 

Thanks!!

Mohit

PPMRam
Super Contributor.

Re: Transaction Details Page

Hi Mohit,

 

Thanks for your reply. But am looking for the query used in that page. If you have any idea please let us know.

 

Regards,

Mohit_Agrawal
Outstanding Contributor.

Re: Transaction Details Page

can you please tell me the exact requirement?

do you want a query to display , what all actions were taken on a request as each phase.. ?

 

Thanks!

Mohit

Jim Esler
Acclaimed Contributor.

Re: Transaction Details Page

You can capture some SQL queries by enabling JDBC logging and executing the related activity. This is done with the Workbench by selecting Edit/Debug settings. The log file will be under server/<name>/log. Turn debug logging off as soon as you can as the log file grows rapidly. It is best to do this in a relatively idle non-production instance so the log is small.

Erik Cole
Acclaimed Contributor.

Re: Transaction Details Page

SELECT LAST_UPDATE_DATE, STEP_LABEL, STEP_NAME, USER_COMMENT, KCRT_REQUEST_UTIL.get_wf_step_status_txn_dtls(STEP_TRANSACTION_ID, STATUS, RESULT_VALUE, VISIBLE_RESULT_VALUE) as VISIBLE_RESULT_VALUE, VISIBLE_ERROR_VALUE, ERROR_MESSAGE, USERNAME, STATUS_MEANING, UNIQUE_STEP_IDENTIFIER from kwfl_step_transaction_hist_v where TOP_INSTANCE_SOURCE_SET_ID = ? AND TOP_INSTANCE_SOURCE_TYPE_CODE = ? AND CURRENT_FLAG <> ? order by step_transaction_history_id