Anchor
_Toc402702614 _Toc402702614

Anchor
_Toc442889143 _Toc442889143

Linked views with multiple driving views

...

• Create a new model Dashboards and Forms 09, 10: Linked Views and presentation
• Drag the datasource Inventory DB onto the model
• Create database collectors and streams to read in all data from the following tables in this datasource:
  • SOURCE_PUBLISHER_LIST
  • SOURCE_BOOK_SUBJECT
• Run both streams to load data into CenterViewPhixFlow

A file containing a list of books can be found in the input files, at:
…\inputData\Books\BookList.xlsx

• Add a File Collector to your model
• Call this: Book List
• Navigate to the directory …\inputData\Books
• Select the file BookList.xlsx – and complete the automatic File Collector and Stream configuration
• Run your stream to load the book list into CenterViewPhixFlow
• Create a simple grid view on each of these streams to display all columns and all rows
  • Give the view on the stream Book List the name: Book List
• Create a new dashboard Review Book List
• Drag all three views you created onto the dashboard. E.g. create a layout such as:

...

• Set the Element Name of the list of publishers to Publishers
• Set the Element Name of the list of subjects to Subjects
• Add a filter to the list of books:
  • Name: by Publisher and Subject
  • Conditions
    • Where ALL the following are true
    • Publisher equals Publishers.Publisher
      • Press the ABC button on both - this will now say fx
    • Subject contains Subjects.Subject
      • Press the ABC button on both - this will now say fx

Here we use the operator contains because the subjects of books may be longer than the subject names in the subject list – but the subjects of books will contain the subject name

...

• Edit the filter on the list of books:
  • Update the condition on publisher, make this:
    • Publisher is in Publishers.Publisher
  • Press
• Select several publishers and a subject and press on either of the driving views
• You will see list of books update to show books that are by the selected publishers and on the selected subject