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.

search and filter bar

If you enter the term term you want to search for without specifying attribute (column) name, Lumeer searches in all columns in all records.

On the homepage (Search perspective), Lumeer will search for tasks, tables, and views.

search and filter for tasks

If you want to search for other types of records than tasks, you might use the Detail perspective. This perspective will also search and filter tasks. It is up to you to decide which way suites you better.

search for all types of records

If you enter multiple terms, they are considered as if there was an And operator between them – all records in the result must contain all fulltext terms.

Search and Filter by Attributes

You can further narrow down the search by specifying table or view name and additional filters. 

search for records

Lumeer always helps you with forming your search and you can immediately see the search results.

attribute suggestions

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

search and filter by attributes

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