Follow Along: Database Views - 1:37

In Discovery Hub you can create custom database views.

1. Watch the video:

2. Follow these steps:

  1. In the MDW, drag the Customer table to the views node.
  2. Name the view Resellers
  3. Add the clause at the bottom of the view script "WHERE [CustomerType] = 'Reseller'" using the CustomerType parameter.
  4. Remove the system fields and the CustomerType field from the view script.
  5. Deploy the view
  6. Read view fields.
  7. Edit the view & add the CustomerType field
  8. Deploy, & Synchronize view fields.