How to display the SOQL code the Salesforce adapter generates for queries

Technique

Product: Reporting Server

Release: 8206

Primary OS: Linux

Solution Date: 2020-06-17

Problem

How to display the SOQL code the Salesforce adapter generates for queries.

Solution

The Reporting Server's STMTRACE trace component will display the SOQL.

Instead of enabling traces at the server level and having to reconfigure them for this one component, you can add the following statements to your query:

SET TRACEUSER=ON
SET TRACEOFF=ALL
SET TRACEON=STMTRACE//CLIENT

The //CLIENT will display the statements to your screen in most cases.

Information is published on an "as is" basis without a warranty of any kind. Information Builders, Inc. ("IBI") hereby represents that such information has not been subject to any formal testing or review by IBI. IBI assumes no responsibility for usage of such information, including the implementation of solutions associated therewith. The customer assumes responsibility for the results obtained from such information. IBI is not responsible for and shall not be held liable for the results obtained, including but not limited to any errors, delays or omissions. IBI disclaims any liability for the completeness or accuracy of such information.