CMS: Adding Filters and Sorts to Datasets to Control Live Site Content
7 min read
Add filters to CMS (Content Management System) datasets to only show certain items in their connected page elements. To choose the order in which the items appear, add sort conditions to the datasets. In both cases, you choose which collection fields to use for filtering or sorting the collection items.
Filters and sorts you add to the dataset have no effect on how items appear in your collection views. If you enable the "Mirror on Site" feature to use the collection's order on your live site, sorts you add to the dataset override the order from your mirrored collection. You can only apply filters and sorts to datasets that are set to the Read or Read & Write mode.
Adding filters to your dataset
Add filters to datasets to choose which collection items appear in the connected elements (e.g. repeaters, galleries, input elements). Dataset filters do not affect the items that appear in your collection views. You can add filters to your collection views if you want to only see certain items in the collections, without affecting live site content.
Wix Editor
Studio Editor
- Go to the relevant page in your editor.
- Go to the relevant dataset settings:
- Click CMS on the left.
- Click Manage Page Connections.
- Click the More Actions icon next to the relevant dataset and select Dataset settings.
- Click + Add Filter under Filter.
- Click the Field drop-down and select the field you want to apply the filter to.
- Click the Condition drop-down and choose the condition you want to use in the filter. The options vary based on the field type that is being filtered.
- (If necessary) Select the Value source:
- Manual entry: Enter the value you want to filter by in the Value field.
- Another dataset: Select the dataset and field you want to filter from the relevant drop-downs.
- Click Add Filter.
- Publish your site when you are ready to make the changes go live.
Adding sort conditions to your dataset
By default, datasets sort items by creation date with the newest items appearing first in the connected page elements (e.g. repeaters, galleries, input elements). You can add sort conditions to datasets to control the order in which the items appear on your site. Dataset sorts override the order in any collections in which you've enabled the "Mirror on Site" feature. However, dataset sorts do not affect the order in which items appear in your collection views.
Wix Editor
Studio Editor
- Go to the relevant page in your editor.
- Go to the relevant dataset settings:
- Click CMS on the left.
- Click Manage Page Connections.
- Click the More Actions icon next to the relevant dataset and select Dataset settings.
- Click Add new sort in the Sort section.
Tip: To edit an existing sort condition, hover over it, click the More Actions icon and select Edit. - Click the Field drop-down and select the field you want to sort.
- Click the Order drop-down and choose the order in which you want the content to appear.
- Click Add Sort.
- Publish your site when you are ready to make the changes go live.
FAQs
Click below for answers to common questions about filtering and sorting items.
Can I hide fields in my collection to prevent them from appearing on the page?
Can I control the order in which the items display on my live site from my collection?
How can I sort my items in a more logical way when using a mixture of letters and numbers in a Text field type?
What happens if no collection items match my dataset filter criteria?
Did this help?
|