Table list view
Display a list of records for a table.

Overview

The Table List view of Labii electronic lab notebook (ELN) and laboratory information management system (LIMS) displays a list of records for a table.
You might not be able to see all records depending on your permission settings. All records are visible to administrators regardless of the permission settings at the project level.
The list view is independent for each table and has the following tabs:
  • [Table] records. Display a list of records for the table.
  • Properties. Table settings. Changes can only be made by administrators.
  • Filters. Display a list of filters for the table.
  • Columns. Display a list of columns for the table.
  • Default sections. Display a list of default sections for the table.

Open table list view

Table list view can be opened by clicking the Application from the side menu and then click the table name. For example, to open a list of experiments, click the ELN from the side menu and then click the experiments.
Click + [table name] from nav bar to add a new record. Depending on your needs, you can:

Search records

Labii enables you to search for records that match specific keywords quickly through the table list view. Labii supports three types of searches:
Search for the provided term in the name and description. It is fast, but it doesn't return all results that match.
Type in search term and press enter to search. You can also perform the search by clicking the Search button.
Search for the provided term in all the fields. While it is a bit slow, it returns all results that match the term.
Type in search term and click Deep search button.
With advanced search, you can perform searches based on one or many specific fields.
The advanced search allows you to perform searches based on any number of fields.
  • To add a new query, click + Query; to remove a query, click delete.
  • Click Perform advanced search to see the search results. The search results can be saved as a new filter by clicking Save as new filter.
  • To hide the advanced search, click Cancel
Click Clear button to cancel search.

Filter records

Filters can be applied to the table list view to specify a subset of the results. When a filter is selected, the button name changes to the filter name and the text color changes to teal.

Predefined filters

6 predefined filters are provided for quick access:
  1. 1.
    All records.
  2. 2.
    Active records (default).
  3. 3.
    Archived records.
  4. 4.
    My records.
  5. 5.
    My unsigned records. All records requiring your signature, whether you are the author or witness.
  6. 6.
    Record templates. A list of records that have been set as templates.

Custom filters

In addition to the predefined filters, you can also create custom filters for later use.
  • Apply a custom filter. To apply the filter, click the filter dropdown and select one of the custom filters.
  • Create new filter. Create a new filter by selecting Create new filter from the filter dropdown. Learn more from Settings -> Table -> Filters.
  • Save current query as new filter. Select Save as new filter from the filter dropdown to create a new filter with the current query. This function will not be available when all records are displayed.
  • Delete current filter. To delete the current filter, select Delete filter [filter name] from the filter dropdown. This option is only available when a custom filter is applied.
  • Manage filters. Click Manage filters from filter dropdown to update the existing filters.

Default filter

If you want to save a query and have it open automatically when the list view loads, use Save as my default filter function. A default filter is specific to each table and each user, so each user can save their own filters without interrupting the view of others.
  • Save as my default filter to save the current filter as your default filter.
  • Clear my default filter to delete any saved default filter.

Filter by project

The records can be filtered by projects. Click All my projects and select a project from the dropdown. Depending on your permissions, only the projects you have at least read permission will be displayed.
A batch operation is a function or a method that processes multiple experiments in a single operation. Labii supports the batch operations for Editing, Printing, and Downloading. Select one or more experiments to get started.

Upload

You can use this method to upload files and create a record at the same time. The uploaded files will be inserted directly into the record's sections/notes.

Import

Using the import function, you can create multiple experiments at once. The import function can also be used to update multiple existing records.

Export

Labii allows exporting data in the list view to a *.tsv file. Two exporting options are supported:
  • Export current page. Export data that is same as the current list view.
  • Export with customization. Customize the number of records, the columns to be exported