Searching, filtering & sorting data tables¶
Search¶
Search terms (text) are to be inputted in the search bar, upon validating with enter , this text is searched for in all values of all properties of all records of this collection.
Using the search bar resets column filters
To restrict the search to visible columns (currently on display), open the search bar settings (Gear on the left of the search bar input), and toggle «Search only visible columns»
Search & filters are active only for the current session
Your search & filters are kept when you browse away from and back to a page. When visiting the same list page again, the search & filters will still be there. Beware: this works only for the current session and in the active window only (not on new tabs). To set filters permanently, use the save filter feature.
A site-wide search is also available
Column Filters¶
Column filters are available to control what items should appear based on the value set for any given attribute or annotation.
The image below shows an example of filtering by Status . Picking the filter value AVAILABLE will display only available items, hiding non-available ones.
Setting a filter value in the header selects all records in the database that have this value set for this filter. The type of filter depends on the attribute type.
The most common are free text filters, date, boolean filter, and value matching filters. Date filters allow selecting a time range between a start and an end date.
The visibility of column filters in the header is kept hidden by default, one has to click on the filter icon to see them in the table header.
Ownership restriction¶
The permission system
An advanced permissions system is used to fine-tune access to items, to make sure this filter is well understood, please also visit the dedicated Permissions page).
By default, the user is presented with everything they can view. It is however possible to narrow down the list to items they own
An ownership control button allows switching between different ownership filters:
- When set on
Personal, all items owned by the user are shown. - When set on
Group, all items owned by the user primary group are shown. - When set on
All, all items the user can see are shown. This includes all of the above (personal and group items), together with items from secondary groups, items shared with them, and public items.
See only the items of the user secondary group
Currently, the Group value of the list ownership control will only list items owned by the user primary group. When a user belongs to more than one group and they want to narrow down the list to items of a secondary group, they can use a column filter on the Owned By column, setting it to the secondary group.
Context filter¶
On certain listings (e.g. on the biomaterials list page), a context can be set. The context is either an existing project, study, or assay.
After picking the type of context you want in the dropdown, a list will be shown in a modal to choose the context to be set. Once set, only items that have a relationship with the context will be shown. The context is lost when leaving the page.