Open topic with navigation

The Query Design Process

Queries are designed visually in the Transformation workspace.

To design a query:

1. In the navigation menu, under Design, click Queries. The Query Object Editor opens.

2. In the Name field, specify a unique name for this query object.

3. In the Transformation workspace, drag and drop the required steps for the query from the Steps menu into the desired sequence. (By default, the Transformation window already includes a Data Source and Format step.)

   For example, to add a sort to the transformation, drag a Sort element from the Step list to the Transformation field and drop it on a link.

   Then, in the Properties tab, select a field to sort by.

   

4. Optionally, in the toolbar click Advanced, then set any advanced properties for the query object.

5. Click Save.

   A blank (empty) query object is displayed when this page is opened, and the Add New button on the toolbar is disabled until the blank query object is saved. After saving, you can add a new query object by clicking Add New.