Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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