Search
Find the data you need by searching.
The Labii Electronic Lab Notebook (ELN) and Laboratory Information Management System (LIMS) allows users to quickly search for any data or records using a simple and intuitive interface.


Click Search in Labii from navbar to open the search box. The following data is included in the search results:
- Tables. List of tables matched to the search term.
- Projects. List of projects matched to the search term.
- Records. List of records matched to the search term.

Within the project list view, you can search all records within the project use and search box. Find out more about the details here.

Within the table list view, you can search all records use and search box. Find out more about the details here.

At the settings list view, you can also search the results for one particular category by searching.
Labii natively supports the scanning of QR code. Use this scan function to find a location or sample. To do that:
- 1.Click the search icon from the navbar
- 2.Click the "Scan" button
- 3.Scan the QR code and the results will be displayed in the search results.
On IOS 11 it is only supported on Safari and not on Chrome or Firefox due to Apple making the API not available to 3rd party browsers.
Labii also supports the commercial scanner. Here is your purchase guide:
- 1.Make sure it can read both 1D, 2D barcode.
- 2.Make sure it supports multiple modes: Manual trigger, Auto-sensing, Continuous scanning. Continuous scanning will be very helpful when you need to scan multiple samples.
- 3.Make sure the connector is supported on your computer. It can be USB based or Bluetooth based. Some new Macbook does not support USB.
A filter is a function similar to advanced search in regards to building a query when creating a new filter. However, Filters take it to another step as you can save search queries for later use.
To create a filter:
- 1.Click tables on the navbar
- 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 the 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 be updated as the table changes. Before using the filter function, you have to have a clear idea of 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 contain the provided value, case insensitive.
- Not contains, find records that do not contain the string of the 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
orfalse
for boolean. - Date
- Use
YYYY-MM-DD
for the date. - Use
TODAY
for the current date. - Use
[+/-][#][DAY/WEEK/MONTH/YEAR]
for a certain date before/after the current date.- +3DAY - 3 days ahead
- 2MONTH - 2 months ahead
- -5WEEK - 5 weeks ago
- YEAR or 1YEAR - 1 year after
Last modified 1yr ago