Page History

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 (the yellow plus button on the top-right)

   Info
   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

Then select View
Image RemovedSelect a data source from the new popup window
Image Removed
2. 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
Click on the Edit View button (Note: Based on our multiple tables selection, this is the button in this popup window)
Image Removed
3. 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
4. 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

   Create and prepare a view. (See Creating a View for more information on how to do this.)

5. After creating the models and preparing the data, click on the Publish button
   
   
6. 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 has the view approval setting enabled, a new Approval Required field will appear, along with a shield icon
      
      
   4. In this approval required field, you You must add a message regarding the view approval that will be sent to the approver
   5. You can click on the Add tags link use add tags to connect tags to your view
7. Finally, click on the Request Approval button
8. Your view has been created and sent for approval. It will only be published if it gets approved by the selected appointed approver