Modify SQL Query

Use the Configure Conditions dialog box to view or modify the query as a SQL statement.

To modify a SQL Query

1. Click the [Export Layout Name] tab on the Export Files tab (for example, End of Month Report).

2. Click Modify Record Layouts. The Query Tool Built Export window appears.

3. Click the name of the detail record (for example, Detail Example). Information for the detail record appears.

4. Above the data grid, click Show Sql Query. The SQL Query Form dialog box appears.

5. To add a table or derived table to use as select columns, in the Additional JOINS box, type the JOIN clause. To view an example, double-click in the box.

6. To add a search condition, in the Additional WHERE clause box, type the WHERE clause. To view an example, double-click in the box.

7. To specify a sort order, in the ORDER BY clause box, type the ORDER BY clause. For example, "ORDER BY AccountID."

8. To verify that the SQL statement is valid after adding or modifying a clause, click Validate Query.

9. To rebuild the query after adding or modifying a clause, click Rebuild. Exchange Manager updates the SQL Query box to reflect your changes.

10. Click OK.

11. In the Query Tool Built Export window, click Save and Exit.

12. In the Clients pane toolbar, click Save. The Update Comment dialog box appears.

13. In the Update Comment box, type a comment regarding your changes and then click OK.

Related Topics

Query Export Detail Record