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.

Full-text search
Full-text search

Sort items

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.

Sort items by property
Sort items by property

Or using the "Manage Order" button.

Sort items using the Order By menu
Sort items using the Order By menu

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.

Indexing Data
Indexing Data

An arrow is shown next to the column name when a column is sorted.

Sort results
Sort results

Change sorting direction

To the change sorting direction, click again on the "Sort by XX" menu item.

Change sorting direction
Change sorting direction

Or from the "Manage Ordering" menu.

Change direction from "Manage Ordering" menu
Change direction from "Manage Ordering" menu

Remove sorting

To remove any sorting condition and switch back to the default sorting, click on "Remove sorting" from the column menu.

Remove sorting
Remove sorting

Or click on "Default" in the "Manage Ordering" menu.

Order by default rank
Order by default rank

Notes
Order by default is a rank by newly added items.

Filter 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:

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.

Open Filters modal
Open Filters modal

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.

Note
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.

Filters modal
Filters modal

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.

Combine several filter conditions
Combine several filter conditions

Feedback Wanted!
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.

DataTable with filter conditions
DataTable with filter conditions

To remove a filter condition, open the filter modal, click the "trash can" button, and submit with the Apply button.

Remove a filter condition
Remove a filter condition

Saved Filters

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.

Notes
Saved Filters only store "filters" and not the full-text search term.

Create Saved Filter
Create Saved Filter

A save filter takes a name, and will automatically attach your current filter conditions to it.

Name Saved Filter
Name Saved Filter

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.
Saved Filter Actions
Saved Filter Actions

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.

Edit Saved Filter
Edit Saved Filter

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.

Export filtered items
Export filtered items