Skip to Content

Use the below steps to creating and using views.

Creating Views using multiple tables

1. Select the tables.

2. Click on Manager Views > Create View.

/wp-content/uploads/2013/12/01_336066.jpg

Output Schema columns for View

1. Select the columns from the multiple tables and insert it in Output Schema tab by clicking on ‘Add Columns’ Button.

/wp-content/uploads/2013/12/02_336071.jpg

2. Change the Data Type of the column by clicking on Data Type value of corresponding column.

3. It is the new feature available in IS 4.1.

/wp-content/uploads/2013/12/03_336072.jpg

Insert Join Conditions

1.      Click on Join Conditions tab.

2.      Click on ‘Add’ to add conditions.

3.      To add joins automatically based on Column names click on propose joins.

/wp-content/uploads/2013/12/04_336073.jpg

4. You can also add the Left Outer Join by selecting Join Type combo box.

5. Left Outer Join feature is provided from v4.1

/wp-content/uploads/2013/12/05_336074.jpg

Inserting Filter Condition

1.  Select the column and add it to the Filter Conditions tab by clicking on ‘Add Column’ button.

2. Select the required operator from Operator column.

3. Write the appropriate value.

4. Click on ‘Validate’ to check the correctness of the condition.

/wp-content/uploads/2013/12/06_336075.jpg

5. To write complex condition select the ‘Advanced Editor’ button.

/wp-content/uploads/2013/12/07_336078.jpg

Group By tab

1. Enables you to specify how the output records are grouped.

2. Only selected columns for Output Schema can be selected.

3. Group by columns can be added either by selecting and clicking on ‘Add Column’ or by clicking on ‘Propose Columns’ option available on Group By tab.

4. Click on ‘Validate’ to verify the correctness of the columns.

/wp-content/uploads/2013/12/09_336079.jpg

Please note that, in Group By tab it should have all the selected column of Output Schema or it should be blank. Otherwise, it will throw an error.

Adding Aggregate Function

1. Open Advance Expression Editor

/wp-content/uploads/2013/12/10_336080.jpg

2. Write the expression

/wp-content/uploads/2013/12/12_336081.jpg

3. Change the data type to Integer

/wp-content/uploads/2013/12/13_336156.jpg

Testing the View

1. In Workspace Home select the View

2. Expand it to check whether it contains the selected columns in ‘Output Schema’ tab./wp-content/uploads/2013/12/14_336082.jpg

3. Select the column and click on View Data

/wp-content/uploads/2013/12/15_336151.jpg

   4. Output window will appear showing the result based on selected condition

/wp-content/uploads/2013/12/16_336155.jpg

To report this post you need to login first.

2 Comments

You must be Logged on to comment or reply to a post.

Leave a Reply