wm.tn.query:getSQL

Retrieves the SQL query that you executed. You must have the 'Show SQL' functional permission to use this service. For more information about functional permissions and configuring My webMethods to work with Trading Networks, see webMethods Trading Networks Administrator’s Guide.

queryInput	Document The filter criteria for the query, the sort order, and the column names that must be returned in the result set. For the structure of queryInput, see wm.tn.rec:queryInput.
queryType	String The type of query. Use one of the following values based on the query type: 1 - Document Query. Creates a query for documents saved in the Trading Networks database. 2 - Event Query. Queries the Trading Networks database for activity log entries. 3 - Task Query. Creates a query for delivery and service execution tasks. 4 - Profile Query. Creates a query for partner profiles in the Trading Networks database.
locale	String Optional. The locale for formatting the query results. Specify the two-letter ISO 639 language code for the language to use, and the two-letter ISO 3166 country code for the country that is associated with the language. Use the format: <languagecode>_<countrycode> For example, to localize for U.S. English, set the locale as 'en_US'.
IsMWS	String Optional. Defines whether the service is called from My webMethods Server or from a user using Designer. Valid values are: yes Default. Call the service from My webMethods Server. no Call the service using Designer.

sql	String. The retrieved SQL query.
svcResponse	Document Conditional. The error messages, if any, that resulted while retrieving the SQL. For the structure of svcResponse, see wm.tn.rec:svcResponse.