Search

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

Overview

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 navigation bar which will always remain on top of the Labii interface, click on Search Icon to perform a global search.

From the sidebar, you have another easy way to get to search, by clicking the menu on the top right, then simply click Search.

Type in one or two phrases, and the search results will return immediately. On default, only the top 10 results returns, Click “Load More” to load more search results.

Global Search Function at Labii ELN & LIMS

By default, the search results will only cover the unique ID and the name fields. To obtain 100% of the results, you need Deep Search, which will scan all searchable fields.

Advanced Search

Labii also provides advanced search to limit the search results based on one or more particular fields. To use the advanced search, click the Advanced Search button This will prompt you to select a table for the advanced search.

Once you have selected a table (experiment shown below), you will see the customizable fields to build a query:

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

  2. Click ADD QUERY again to add more queries.

  3. Once all fields are filled out, simply click Submit

Advanced Search in Labii ELN & LIMS

Filter

A filter is a function similar to advanced search in regards to building a query when creating a new filter. However, Filters takes it to another step as you can save search queries for later use.

To create a filter:

  1. Click tables on the nav bar

  2. Select a table

  3. On the sidebar, select “Create experiment filter

  4. Type the name and description of the filter

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

  6. Select Digest Frequency - how often you want to receive the digest email for the filter

  7. Select users that you’d also like to use this filter and your name will be added automatically!

  8. Create a query, similar to advanced search

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

    2. If you’d like, you can add multiple queries by simply clicking add query

  9. Click Submit to finalize!

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.

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:

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.

Value:

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 from side bar 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:

Name

Description

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.