Service Studio 6.0 Help
Advanced Query Editor
The Advanced Query editor Show picture, allows you to type and test your advanced queries.
The Advanced Query Editor is divided into two sections:
The upper section, where the query input/output is defined:
Input Parameters: Input parameters necessary to your query.
Output Structure: Entities and/or structures that define the layout of the output record of the query.
The lower section, where the query is also defined:
SQL: Where you type the SQL statement to be executed and other commands regarding your query execution.
Verify button: Verifies that the SQL you typed is correct and focuses the SQL tab of this editor
The query testing area allows you to test the query with different test values for its parameters. Iteratively, you can re-test the query if the SQL is changed.
Execute Advanced Queries | Test Query