How to track a SData provider request to see the SQL that is fired.

Less than one minute read time.

Perhaps you want to control the logging to see the REST request get handled and then see the database interaction. You may want to see how SQL changes between users (e.g. Mayes/Admin/Ebden) and how that may effect the XML payload returned.

To see that information you need to set the logging level in the WEB-INF\log4j.properties file for the default log to INFO, you then have to change the logging level of jdbc.sqlonly.level in WEB-INF\Classes\logging.properties to FINE.

Note: If you are working with the beta you will get a huge amount of logging information. By the time the release is available the logs will be minimised so that only Sage CRM specific logs are logged to the file.