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

Transaction Details Page

Highlighted
PPMRam
Collector

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
Frequent Visitor

Re: Transaction Details Page

Hi..

 

You can use below tables to get transaction details.

 

KWFL_STEP_TRANSACTION_HISTORY,

KWFL_STEP_TRANSACTIONS

 

Thanks!!

Mohit

PPMRam
Collector

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
Frequent Visitor

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
Honored 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
Honored 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

//Add this to "OnDomLoad" event