Trading Networks 10.7 | Administering and Monitoring B2B Transactions | Trading Networks Built-In Services Reference | Query Folder | Summary of Elements in this Folder | wm.tn.query:getSQL
 
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.
Input Parameters
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.
Output Parameters
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.