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