This guide will walk you through how to use the search and filter functions. Labii ELN & LIMS provides 3 different search functions:
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.
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.
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.
Once selected, a filter form will be opened.
To build a query:
Click ADD QUERY
Select a Field, Lookup Expression and provide a lookup value.
Click ADD QUERY again to add more queries.
Click Delete button to remove the query; Use Up/Down Button to change query order.
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.
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.
false for boolean.
YYYY-MM-DD for date.
TODAY for current date.
Filter by a field:
Filter by multiple fields:
Exclude in a filter:
Filter in JSON objects:
contains a string in value:
not contain a string in value:
contains a key:
contains a object:
not contains a object:
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:
OR relationship shall be expressed in a array:
Filter by multiple filter set:
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.
Here is a list of predefined queries available to use:
The experiments that awaiting for me to sign.
The experiments that have signed by me.
The experiments that listed me as Co-Author.
The experiments that listed me as Witness.
The experiments that waiting for me to sign, as Author or Co-Author.
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.