Labii provides sophisticated search function to help you address your scientific problems.


This guide will walk you through how to use the search and filter functions. Labii ELN & LIMS provides 3 different search functions:

In-Page Search

Use this function to narrow down the number of items to display in one page. On the list view of experiments, there is a search icon on the top, where you may click and start typing. The results are only from that page and will appear in real time as you type.

In-Page Search

Global Search

If you want to search records matched any table (experiments, samples, etc) with one or two phrases, use global search. On the sidebar, click on Search to perform a global search.

Click to open Global Search
Global Search


Filter is also known as advanced search. Use Filter to build a query to return results with specific parameters. The Filter function is table specific. To filter records, first click a table in the sidebar, and then choose "Filter __" from the filter dropdown.

Filter Menu

Once selected, a filter form will be opened.

Filter add form

To build a query:

  1. Click ADD QUERY

  2. Select a Field, Lookup Expression and provide a lookup value.

  3. Click ADD QUERY again to add more queries.

  4. Click Delete button to remove the query; Use Up/Down Button to change query order.

The Name and Description fields are optional. If the Name is provided, the filter will be saved and can be accessed from the filter dropdown menu.

Uncheck Show in Menu to hide the filter from displaying in the dropdown menu.

When a filter is saved, the Users filed can be customized to define who can use the filter. The owner will be added to the users list automatically.


Fields are the column title of the table. The list of fields will updated as the table changes. Before using the filter function, you have to have clear idea which field is the data come from. If you are not quite sure, use the global search.

Lookup Expression:

  • Is equal to, find records that have exactly match to the provided value, case insensitive.

  • Not equal to, find records that do not match to the provided value.

  • Contains, find records that contains the provided value, case insensitive.

  • Not contains, find records that does not contains the string of provided value.

  • Greater than or equal to, find the records greater than or equal to the provided value, for Date and Number type of columns only.

  • Less than or equal to, find the records less than or equal to the provided value, for Date and Number type of columns only.


The value to lookup.

  • Use true or false for boolean.

  • Use YYYY-MM-DD for date.

  • Use TODAY for current date.

Advanced Filter

  • Filter by a field: name__icontains=test

  • Filter by multiple fields: name__icontains=test&is_archived=false

  • Exclude in a filter: name__not_icontains=test

  • Filter in JSON objects:

    • contains a string in value: jsonfield__vcontains=test

    • not contain a string in value: jsonfield__not_vcontains=test

    • contains a key: jsonfield__has_key=test

    • contains a object: jsonfield__jcontains={'name':'test'}

    • not contains a object: jsonfield__not_jcontains={'name':'test'}

  • Filter by a filter set: filter__sid=xxx, where in a filter set:

    • AND relationship shall be expressed in a JSON object, separate by comma: {"name__icontains":"test", "is_archived":false}

    • OR relationship shall be expressed in a array: [{"name__icontains":"test"}, {"is_archived":false}]

  • Filter by multiple filter set:

    • AND: filter__sid=xxx,xxx

    • OR: filter__sid__in=xxx,xxx

Predefined Filters

Becoming proficient at building a query can take practice, Labii provides some predefined filters to save you time. Please contact us if you need help in building custom queries.

Click Predefined Filters in the dropdown to open list of queries ready to use. Click Save to save this filter.

Predefined Queries

Here is a list of predefined queries available to use:



My Unsigned

The experiments that awaiting for me to sign.

My Signed

The experiments that have signed by me.

My Co-Authored

The experiments that listed me as Co-Author.

My Witnessed

The experiments that listed me as Witness.

My Open

The experiments that waiting for me to sign, as Author or Co-Author.

Manage Filters

The created filters can be further updated by Clicking the “Manage Filters” in the dropdown. This will bring you to the Settings of the table. Open the “My Filters” section, and you can change the name, query, etc of the filters by clicking the “edit” icon.

Manage Filters