Designing a View and Table Resource
View design involves performing one or more of these tasks, depending on your implementation requirements:
• Add resources for the view.
• Join tables by columns and specify join properties.
• Combine the output of multiple SQL selects.
• Specify global query options.
• Specify query options and query engine hints.
• Specify column output to include in or exclude from the view execution result.
• Apply functions on columns to transform result set values.
• Supply aliases for column names.
• Specify the sorting order for columns.
• Specify GROUP BY, HAVING, or EXPRESSION options.
• Specify constraints for the WHERE clause.
• Specifying indexes, primary keys, and foreign keys.
You can accomplish these tasks using the Model Panel, Grid Panel, SQL Panel, Columns Panel, Indexes Panel, and the Foreign Keys Panel.
The following sections describe how to perform these tasks: