Searching and filtering the data

When you need to quickly find a particular piece of information, Lumeer offers you advanced search and filter capabilities.
At the top of the screen, there is always a search bar (see the input box with Type anything you search for…). This is like Google for your data. When it’s empty, Lumeer displays all your data.
Full-text search
If you enter the term term you want to search for without specifying attribute (column) name, Lumeer searches in all columns in all records.
If you enter multiple terms, they are considered as if there was an Or operator between them – all records which contain at least one of the terms will be included in the result.
Search and filter by attributes
You can further narrow down the search by specifying table or view name and additional filters.
Lumeer always helps you with forming your search and you can immediately see the search results.
If you enter multiple terms, they are considered as if there was an And operator between them – the records in the result fulfill all the conditions.
Possible operators in a search term depend on the type of the attribute.
See the lists of available operators and functions below:
Operator | Available in |
Is | text, date, checkbox, address, color, coordinates |
Is Not | text, date, checkbox, address, color, coordinates |
Contains | text, address |
Does Not Contain | text, address |
Starts With | text, address |
Ends With | text, address |
Is Empty | all attribute types |
Is Not Empty | all attribute types |
Has Some (at least one value overlaps) | selection, user |
Has None Of | selection, user |
In (must have subset of the values) | selection, user |
Has All (must have superset of the values) | selection, user |
Is After | date |
Is Before | date |
Is On Or After | date |
Is On Or Before | date |
Is Between | date |
Is Not Between | date |
= | number, percentage, duration |
≠ | number, percentage, duration |
> | number, percentage, duration |
< | number, percentage, duration |
≥ | number, percentage, duration |
≤ | number, percentage, duration |
Range | number, percentage, duration |
Not From Range | number, percentage, duration |
Function | Available in |
Current User | user |
Today | date |
Yesterday | date |
Tomorrow | date |
This Month | date |
This Week | date |
Last Month | date |
Last Week | date |
Next Month | date |
Next Week | date |