Displaying Content from Multiple Database Collections Using Datasets
When you have related information stored in more than one collection, you can filter one dataset by a second dataset. This allows you to use one dataset to control the content displayed by the second dataset.
To filter by dataset you need two collections, where each collection has a field that contains the same information as the other. For example, you might have a book collection with an author field and an author collection also with an author field, plus other fields with additional author information.
To create a filter by dataset:
- Add and set up a dataset if you don't already have a page that has a dataset connected to a collection. This is the main dataset for your filter.
- Add a second dataset to the page and connect it to the second collection.
- Select the second dataset.
- Click Settings.
- Click + Add Filter.
- Select the field that contains the same information in both collections.
- Add a condition from the dropdown menu.
- Click the arrow next to Value and choose Dataset.
- Select your main dataset.
- Select the field in the main dataset that contains the same information.
- Click + Add Filter.
- Important: Don't forget to add elements to your page and connect them to the datasets to display the information on your site.
Looking for advanced information?
Learn more about filtering one dataset by a second dataset.
Did this help?
|