Datablist provides powerful features to browse your items. Among them:
Searching through your items is simple. Datablist performs a full-text search on all of your item property values in seconds.
The search input is located in the collection header. A fast way to start a search is using the keyboard shortcut Ctrl + f.
Items can be sorted on any visible property by clicking on the property column. Property values can be sorted in ascending or descending order.
Sort items using the drop-down menu available on each column.
Or using the "Manage Order" button.
The first time you sort by a property, Datablist asks you to index your property data. Just click "Add an index". Datablist will process all the data from the selected property and create an internal index. This index will be then used to rank your items.
This index will be automatically updated when you add new items or update existing ones.
An arrow is shown next to the column name when a column is sorted.
Change sorting direction
To the change sorting direction, click again on the "Sort by XX" menu item.
Or from the "Manage Ordering" menu.
To remove any sorting condition and switch back to the default sorting, click on "Remove sorting" from the column menu.
Or click on "Default" in the "Manage Ordering" menu.
Order by default is a rank by newly added items.
Full-text search looks for a term in all available properties. To filter your data on specific properties, use Filter Conditions.
Filtering is useful to:
- Find items that meet certain conditions
- Have a clean listing by excluding items
- Filter a CSV file to extract specific rows
Filtering works by creating filter conditions on one or several properties.
Add a filter condition
Add a filter condition by clicking the "Change filters" button in the collection header.
A filter condition is made of 3 elements:
- A Property - Any property in your collection.
- An Operator - The filter operator specifies how to compare the data with your filter value. Depending on the property data type, operators can be: contains, is, is empty, is not empty, numerical operators, date comparators, etc.
- A Value - The value to compare your item's property data against.
Operators "is empty" and "is not empty" do not require a value.
Click the "Apply" button to run your filter condition against your collection items.
Combining several filter conditions
Filter conditions work in AND mode. Only items matching all filter conditions are displayed in your data table.
Use the "Add another filter" to add another filter condition.
Do you need more complex filtering? Please share your use case with us.
Remove filter conditions
The filtering button is renamed "Filtered" and the icon is full when the collection is filtered.
To remove a filter condition, open the filter modal, click the "trash can" button, and submit with the Apply button.
With Saved Filters, you can save your current filters for quick access. This is useful to preserve complex filters that you frequently use. Or to create Segments of your data.
This simple feature will boost your productivity and help you manage your collections.
Saved Filters are accessible in the down arrow next to the filters button. And they are shared with your team members.
When you have at least one filter condition, a "Save filters" action is available to save them.
A save filter takes a name, and will automatically attach your current filter conditions to it.
Once created, or after you select previously created "Saved Filter", the menu will change to display 3 actions:
- Stop filtering on "X" - This action clears the current filtering conditions. The Saved Filter is not edited. All the filtering conditions from the Saved Filter will be used once again when you select it.
- Rename "X" - To change the name on your Saved Filter. The name is only used to list them in the menu.
- Delete "X" - Delete the Saved Filter. This action cannot be undone.
To edit the filtering conditions of a Saved Filter, open the filtering modal and add, edit, or remove conditions. Any change will display a "Edit saved filter" checkbox next to the "Apply" button.
Filtering on built-in properties
Datablist comes with built-in properties (createdAt, updatedAt) which can be filtered as any other property. To be able to create filter conditions on your built-in properties, you must add them to your collection properties. See our documentation on built-in properties.
Filtering and data export
The export button in the collection header exports the full collection items. To export only your filtered items, use the Select all checkbox and click the "Export items to CSV/Excel" button.