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:

  • Dashboard - Display dashboard data. Only available when common_check_count=true.

  • [Table] records - Display a list of records for the table.

  • Properties - Table settings. Changes can only be made by administrators. Available to Administrator only.

  • Filters - Display a list of filters for the table. Available to Administrator only.

  • Columns - Display a list of columns for the table. Available to Administrator only.

  • Default sections - Display a list of default sections for the table. Available to Administrator only.

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

Learn more about Search at list view.

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. All records.

  2. Active records (default).

  3. Archived records.

  4. My records.

  5. My unsigned records. All records requiring your signature, whether you are the author or witness.

  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.

Save as default

If you would like a different view to be loaded when clicking on the table, you can use the Save as default feature.

  • Save as my default

  • Save as table default

  • Save as organization default

In the event that multiple default data are saved for a person, the personnel default data will be used first. Click Clear all default to clear all defaults.

Sort records

Click the title to sort the records.

Edit mode

Labii allows you to edit records in bulk. In order to do that, click "Edit mode".

All fields are displayed once you are in edit mode. By clicking the edit icon, you can edit a field.

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.

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

Last updated