Searching and filtering the data

Avatar
Alica Kačengová

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:

OperatorAvailable in
Istext, date, checkbox, address, color, coordinates
Is Nottext, date, checkbox, address, color, coordinates
Containstext, address
Does Not Containtext, address
Starts Withtext, address
Ends Withtext, address
Is Emptyall attribute types
Is Not Emptyall attribute types
Has Some (at least one value overlaps)selection, user
Has None Ofselection, user
In (must have subset of the values)selection, user
Has All (must have superset of the values)selection, user
Is Afterdate
Is Beforedate
Is On Or Afterdate
Is On Or Beforedate
Is Betweendate
Is Not Betweendate
=number, percentage, duration
number, percentage, duration
>number, percentage, duration
<number, percentage, duration
number, percentage, duration
number, percentage, duration
Rangenumber, percentage, duration
Not From Rangenumber, percentage, duration
FunctionAvailable in
Current Useruser
Todaydate
Yesterdaydate
Tomorrowdate
This Monthdate
This Weekdate
Last Monthdate
Last Weekdate
Next Monthdate
Next Weekdate