11,856
edits
Changes
Updating to match new version of source page
==Filtering==
[[File:mainmenu5.png]]
'''See a [[Object and Column Filters|video tutorial]] about how to use filters'''.
It is possible to filter data by one or more ''Date'' or ''Text'' columns of the ''Data Source'' using the available operators'''Conditions'''. Filters can be set by [[Permission filters|users]], [[Object Filters|objects]] or , [[Column filters|columns]] or [[Dashboard|dashboards]].
[[File:FilterFilter_main_en.PNGpng|link=]]
'''Operators'''
* '''Equal to''': Data must be equal to the selection. Multiple values can be selected by holding ''CRTL'' key or using advanced selection mode;
* '''Not equal to''': Data must be different from the selection. Multiple values can be selected;
* '''Do not contains''': Data must not ''contain'', ''starts with'' or ''end with'' the input text. For Text columns only;
* '''Between''': Data Date must be between the chronological selection. ''For Date columns only''; * '''Not between''': Date must be not between the chronological selection. ''For Date columns only''; * '''Is Null''': Data must be null (empty);
* '''Not betweenNull''': Data must be not between the chronological selection. For Date columns onlybe null (not empty);
===Filtering text type columns===Text type columns can be filtered by selecting the desired valueswhen using ''Equal to, Not equal to, Less than, Greater than, Less or equal to or Greater or equal to''.
===Filtering date type columns===
Date type columns can be filtered by date parts (expand the date column by the plus icon), by preset Shortcuts (like ''Current Year'' and ''Next 2 months'') or by selecting a specific date.
[[File:Filter_dates_short_en.png|link=]]
[[File:Filter_dates_calen_en.png|link=]]