Designing Column Projections Using the Columns Panel
If an external client must receive the data according to a particular external schema with specific data type projections, you can use the Design Mode check box in the Columns panel. The Design Mode check box lets you design a projection of a view, so that you can do a top-down design from the SQL panel.
When you use the Columns panel to design the projections, the SQL implementation is not automatically updated in the SQL panel. You must make sure there is a match between the columns defined in the SELECT statement of the SQL and columns you designed in the Columns panel using the design mode, including the order in which they are provided; otherwise, the query will generate an error when executed.
To design column projections through the Columns panel
1. Open the Columns Panel in the view editor.
2. Check the Design Mode check box in the upper right corner.
Studio displays the warning below to let you know that changes you make to the Columns panel are not automatically made in the SQL panel which invalidates the SQL implementation; you must make the same edits in the SQL panel to ensure that the query works.
3. Highlight the row below which you want to add the column projection.
4. Click the Add button, and select a data type from the drop-down list.
A new row is created, with a default name and the selected data type for the new column projection.
5. Optionally, highlight the default column name and type a new column name.
6. If the data type needs to change, right-click the Type/Reference value for that row, select Change Type, and specify the correct data type for the column projection.
7. Edit the SQL to include your columns in the SELECT statement.
After you have specified all columns are specified in their result-set display order, you can use them in the SQL statement in the SQL panel. However, the SQL is not automatically updated to reflect the design you created in the Columns panel.