How can I debug report SQL in my server log? - Developer Network Q&A https://community.onenetwork.com/sdk-forum/how-can-i-debug-report-sql-in-my-server-log/ BY Network Community Discussion Board en-US Wed, 22 Jul 2026 04:37:11 +0000 wpForo 60 Answer to: How can I debug report SQL in my server log? https://community.onenetwork.com/sdk-forum/how-can-i-debug-report-sql-in-my-server-log/#post-7946 Fri, 03 Mar 2023 15:53:07 +0000 This can be accomplished by turning the Report function to DEBUG within the JMX Console and then viewing the SQL within the server log.

Navigate to JMX conosle. For local instances, this is at http://localhost/jmx-console. Once there, click on “Logger=OneNetwork Logger Service”

623

 

Click “DEBUG” under the Reports Function

624

 

Navigate to and open the Report you need to view, in this instance the PickerReport you wish to view

625 626

 

View your Server log for report information. SQL Bind Variables are listed in Blue. The PickerReport SQL is listed in white.

627 628

 

With this data, you can set the bind variables as needed and then run in the database

629

 

]]> Developer Network Q&A jcourter https://community.onenetwork.com/sdk-forum/how-can-i-debug-report-sql-in-my-server-log/#post-7946 How can I debug report SQL in my server log? https://community.onenetwork.com/sdk-forum/how-can-i-debug-report-sql-in-my-server-log/#post-7945 Fri, 03 Mar 2023 15:48:43 +0000 I have a PickerReport and I need to see the underlying SQL that is called, including the bind variables that are used within the SQL. How can I retrieve this information?

]]> Developer Network Q&A jcourter https://community.onenetwork.com/sdk-forum/how-can-i-debug-report-sql-in-my-server-log/#post-7945