Order by Columns Tab

Use the Order by Columns tab to specify how you want the system to display the results. You specify sort criteria for the columns that you have selected and the order of the records for each column. Click the Add ordering button to add a column name, then change the column name by clicking the column name in the row that you want to change and selecting a new name from the drop-down list box. Use the Move Up and Move Down buttons to change the order of the column names that you enter. You can specify the order of the records within a column to be ascending or descending by selecting the row that has the column name and then clicking the ASC or DESC name under the Ordering column and selecting a new order from the drop-down list box.

After you complete the specifications for your Select call, click Next to see a preview page. The preview page shows a conceptual SQL statement based on the specifications you have entered. You can use the Back button to return to a previous page and modify your specifications. When you are satisfied with the specifications you have entered, click Finish. The wizard creates a Select database operation call where your cursor is located in the business service code, and it produces accompanying code. You must modify the Select call to include the appropriate value objects and to complete the generated code.