Request for View Approval

In this section, we look at how to create a view which requires authorisation to be published; we will use the same sub-folder we enabled the view approval setting for for this process.

1. Click on the create icon

   Depending on the layout chosen by your administrator, you might be missing this icon. Instead, click on the Create button located at the top-left of your screen

2. Then select View
3. Select a data source from the new popup window
4. In the second step, select your preferred view type (in our example, we will choose the most-used type, 'multiple tables'). Click here for more information on all these types and how to continue with each. Then based on the above selection, fill the rest of the type related fields
5. Click on the Edit View button (Note: Based on our multiple tables selection, this is the button in this popup window)
6. Once you get to the View Builder page, start adding tables to your view and creating relationships between them. (Click here to learn more about creating views through this builder <<link to prev. confluence page.>>)
   1. Drag two or more tables to the canvas
   2. Click on the edit table properties/settings icon of a table and select columns to include from the database table
   3. Repeat the above step for the second table
   4. Click on the join table/relationship icon on a table to make the joining popup window appear
   5. Create a joining rule by selecting a column from one of the tables, then choose an operator for this rule and finally select a column from the other table; then click on Add
   6. You can create more rules this way; Once done, click on the Save & Close button
7. Once you are done adding tables and joining them, click on the Prepare button to view the data that will be included in your view
8. After creating the models and preparing the data, click on the Publish button
9. Add details of this new view in the Save View popup window
   1. Give your view a name and add a description of it
   2. Select the folder for your view
   3. If the folder you have selected, requires approval, a new Approval Required field will appear
   4. In this textbox, you must add a message regarding the view that will be sent to the approver
   5. You can click on the Add tags link to connect tags to your view
10. Finally, click on the Request Approval button
11. Your view has been created and sent for approval. It will only be published if it gets approved by the selected approver