Labii Documentation
HomeFree SignupFree DemoContact Us
  • Getting Started
    • Introduction
    • Quick Start
  • User Guide
    • Interface
      • Side Menu
      • Views
    • Add Record
      • Add a project
      • Add a blank record
      • Add records in bulk
      • Add a record from a template
      • Add record(s) from file(s)
      • Add a template
    • Record List View
      • Table List View
      • Project List View
      • Row List View
      • ❗Import Records
      • Export Records
      • Bulk Operations
        • Bulk Edit Columns
        • Bulk Edit Sections
        • Bulk Print Detail
        • Bulk Print Labels
        • Bulk Print Barcodes
        • Bulk Print QR Codes
        • Bulk Download
        • Use Selected to Add Blank Record
        • Use Selected to Bulk Add Records
    • Record Detail View
      • Columns
      • Sections
      • Notes
      • Signers
      • Versions
      • Activities
      • Visitors
      • Permissions
      • Section
      • Actions
        • Sign
        • Print
        • Share
    • Navbar
      • Search
        • Global search
        • Search at list view
        • Search query
      • Scan
    • Side Menu
      • Dashboard
      • Calendar
      • Notifications
      • Reload Organization
      • Switch Organization
      • Change Data Center
    • Accounts
      • Authentication
      • Setup an account
      • Create an account
      • My Profile
    • AI Integration
      • Prompt box
      • Prompt template
      • ProtocolGPT
      • AI in Widgets
      • Use cases
  • Admin Guide
    • Organization
    • Backups
    • Personnel
    • Certifications
    • Teams
    • Projects
      • Members
    • Applications
    • Tables
      • Columns
      • Sections
      • Filters
    • Workflows
    • Widgets
    • Subscriptions
    • Credits
    • Invoices
    • Single Sign On
      • Google G Suite
      • Okta
      • OneLogin
      • Microsoft Azure
    • API Keys
  • Widgets
    • Overview
    • Column Widgets
      • Form
        • Text inputs
          • Text
          • MultilineText
          • RichText
          • Number
          • RangeUnit
          • Email
          • Phone
          • Secret
          • Link
          • Address
        • Boolean
          • Checkbox
          • Switch
        • DateTime
          • Date
          • Time
          • DateTime
          • Appointment
          • TimeStamp
          • Timezone
        • Dropdown
          • Select
          • MultiSelect
          • ForeignKey
          • ForeignKeys
          • Member
          • Members
        • File
          • Files
          • Image
          • File Path
          • File Size
          • File Antivirus Status
      • Barcode
        • Barcode
        • QR Code
      • Calculation
        • Formula
        • Numbering
        • RowCount
        • Consumption
      • Integration
        • API
          • API
        • Dropdown
          • API ForeignKey
          • API ForeignKeys
      • Column
        • Record Citation
        • Column Citation
        • Column Data
        • Column Addition
      • Regulation
        • Signature
          • Signature
          • Open Signature
          • Signature Status
      • ❗Chemistry
      • ❗PubMed
      • ❗Device
      • ❗Integration
      • Advanced
        • Subtitle
        • Rating
        • Nested Fields
        • Storage
        • Storage Coordinates
    • Section Widgets
      • Office
        • Text
          • Plain Text
          • CKEditor Classic
          • CKEditor Balloon
          • CKEditor Document
          • CKEditor Restricted
          • CKEditor Classic Controlled
          • Code Editor
        • ❗Table
        • File
          • Files
          • File Preview
        • Google Drive
        • Drawing
        • G Suite
        • Microsoft Office
      • Data Display
        • Columns
          • Columns
          • Metadata
        • Sections
          • Section Display By Record
          • Section Display By ForeignKey
        • Record List
          • Record List
          • Record List by Column
          • Record List by ForeignKey
          • Record List by Query
      • ✅Regulation
        • Signers
        • ✅Audit Trail
          • ✅Activities
          • Versions
          • Visitors
      • Process Management
        • Flowchart
        • Steps
      • Diagram
        • Mermaid
        • Gantt Chart
        • Stage Flowchart
        • Relation Flowchart
      • Reference Manager
      • Biology
        • Molecular Biology Suite
          • Plasmid Editor
          • Open Vector Editor
        • Microplate
          • 6-Well Plate
          • 12-Well Plate
          • 24-Well Plate
          • 48-Well Plate
          • 96-Well Plate
          • 384-Well Plate
          • Flexible Well Plate
        • Sample Aliquoting
        • Assay
          • ELISA Standard Curve
          • ELISA Qualitative
          • Dose Response Curve
        • Protein
          • MolStar
          • RCSB Saguaro
        • Bioinformatics
          • QUiCKR Analysis
          • CRISPResso2
      • Chemistry
        • Chemical Formats
        • Chemical Drawing
        • Chemical Analysis
        • Chemical Reaction
      • Combination
        • Clinical Genomicist Workstation
      • Productivity
        • ✅Calendars
          • Calendar
          • Scheduling
        • Automation
          • Workflows
        • Ungrouped
          • Storage Map
        • Table of Contents
        • Communication
          • Email Template
          • Notifications
          • Comments
        • Barcode
        • ToDo
        • Timer
      • Report
        • Record Summary
          • Record Summary
        • Data Driven Charts
          • Chart By Category X
          • Chart By Numeric X
        • Custom Input Charts
          • Data Visualizer
    • Dashboard Widgets
      • Labii
      • Shortcut
        • Applications
        • Links
        • Filters
      • Productivity
        • Office
        • Flowchart
        • Section
        • Project Management
          • ✅Tasks
        • Summary
      • ✅Reports
        • Record Summary
          • Record Summary By Date
          • Record Summary By Tables
          • Record Summary By Projects
          • Record Summary By Users
        • Data Driven Charts
          • Chart By Category X
          • Chart By Numeric X
        • Matrix
          • Record Count By Filter
        • Audit
          • Storage Audit
      • Integration
        • Quickbooks
          • Quickbooks Customers
          • Quickbooks Accounts
          • Quickbooks Items
          • Quickbooks Invoices
  • API
    • Concepts
      • How to get token from Labii ELN & LIMS
      • How can I load Labii data from API into DataFrame
    • Methods
      • Authentication
      • Notification
      • Organization
      • Personnel
      • Team
      • Organization Widget
      • Statement
      • Backup
      • Project
      • Member
      • Table
      • Column
      • Filter
      • Row
      • Cell
      • Section
      • Activity
      • Version
      • Visitor
      • Workflow
      • Step
      • Widget
    • Variables
    • SDK
      • API Client (python)
      • API Client (javascript)
      • SDK (python)
      • SDK (javascript)
      • Examples
  • Applications
    • Electronic Lab Notebook
      • ELN for Research and Development
      • ELN for Production
      • ELN for ELISA Data Analysis
      • ELN for Dose Response Curve
    • Process Management
      • ❗Report creating process in diagnosis testing
      • ❗Email follow up process in CRM
      • ❗Management of the purchasing, approval, and ordering processes.
    • Sample Management
      • Sample Receiving
      • Track sample consumption
      • Aliquots Management
    • Equipment Management
      • ❗Equipment Scheduling
      • ❗Equipment Maintenance
    • Inventory Management
      • Barcode System
      • Stock Checkin and Checkout
      • Storage Management
      • ❗Purchase Management
    • Laboratory Information Management System
      • LIMS for Sample Testing
      • LIMS for NGS
    • Customer Relationship Management (CRM)
      • Quickbooks Integration
    • Document Management
    • Chemical Registration
    • Mouse Colony Management
    • Diagnostic Testing
    • Diabetes Tracker
    • Project Management
      • Task Management
      • How to manage research goals
    • Reference Management
    • Training Management
  • Support
    • Overview
    • Documentation
    • YouTube
    • Videos
    • Tickets
    • Chat with us
    • Schedule a meeting
    • Take a survey
    • Resources
    • Download
    • Blogs
    • FAQ
    • Other
      • Guidelines for Preparing Documents on Research Needs for Labii Configuration
Powered by GitBook
On this page
  • Overview
  • List of filters
  • Search filters
  • Filter filters
  • Filter detail
  • Filter fields:
  • Add filters
  • Import filters
  • Export filters
  • Delete filter
  • Sent notifications
  • Examples
  1. Admin Guide
  2. Tables

Filters

Labii ELN & LIMS allows users to create filters for any table within the platform.

PreviousSectionsNextWorkflows

Last updated 4 months ago

Overview

A filter is a set of limitations to the table fields for allowing users to restrict display results by building one or more queries. allows users to create filters for any table within the platform.

List of filters

Each table has its own filters. Open a table and click the Filters tab to view the list of filters.

There are 3 ways to access filters for a particular table:

From record list view:

  • Click “filters” from sidebar to the left or the navbar to the top

  • Select “My xxx Filters” or “All xxx Filters”

From settings:

  • Select Settings

  • Select Tables

  • Click Filters tab

Search filters

You can search filters by typing a keyword into the search bar in the filters list view, and then clicking Search. The search results can always be cleared by clicking the Clear button.

Filter filters

With the Filter function, you can limit the number of sections displayed. You can do that by clicking Active filters and then selecting a filter from the dropdown. Here are a list of filters:

  • All filters. Filter to display all filters of the table.

  • Active filters. Filter to display the active filters.

  • Archived filters. Filter to display the archived filters.

  • My filters. Filter to display a list filters assigned to you.

Filter detail

Click a filter name to see full detail of a filter.

Filter fields:

  • Name - The name of the filter

  • Description - Provide a description of the filter and all other necessary information to help others in the same organization understand what this filter is for

  • Show in Menu - Default is set to true and it will be shown on the menu. Mark false to hide a particular filter from the menu.

  • Is Archived - Ability to archive this particular filter and will not be available to use if marked true

  • Date Updated/Created - Automatically captured in the background of Labii ELN & LIMS in real-time when changes are made by members within an organization

  • Query

    • Query - Query is in JSON format and use an array for OR operator

    • Query Exclude - Query in JSON format to be excluded.

  • Permissions

    • Owners - Owners eligible to modify and utilize this filter. The author's name will be automatically appended.

    • Teams - The teams permitted to utilize this filter. Team members are unable to modify the filter.

  • Notifications

    • Digest Frequency - How often do users want to receive the digest email for the filter; The default is set to weekly but can change it to none, daily, monthly, or annually.

    • ICS - The ICS link to sync with your calendar.

Add filters

There are many methods to add filters:

  1. Add filter from the search results:

    1. Open record list view

    2. Click Search Bar -> Advanced Search

    3. Fill in the search queries

    4. Click "Save as filter" button

  2. Add filter from list view

    1. Open record list view of a table

    2. Click filter dropdown

    3. Choose Add filter option

  3. Add filter from settings

    1. Click Settings -> Tables

    2. Click Filters tab

    3. Click "Add Filter"

Enhancing Results by Merging Multiple Filters

Labii allows you to combine results from multiple filters. To do this, create a filter and update the query with the following keys and values:

  • To use "OR" logic for filters, use the key filter__sid__in. Example: {"filter__sid__in": "xxx,xxx,xxx"}

  • To use "AND" logic for filters, use the key filter__sid. Example: {"filter__sid": "xxx,xxx,xxx"}

Import filters

Multiple filters can be created simultaneously using Import. You can do this by clicking Import in the section list view.

Export filters

You can export a list of filters by clicking Export button and select one option from the dropdown.

Delete filter

In the filters list view, a filter can be deleted by clicking the Delete icon next to it.

Sent notifications

When you define the "Digest Frequency" on a filter, you will be able to receive notifications for the results of the filter.

Examples

  1. Identify and retrieve rows that are missing a specific column's data.

    1. query: null

    2. query_exclude: {"cell__column__sid": "xxx"}

Labii ELN & LIMS