11,856
edits
Changes
Updating to match new version of source page
<languages/>
==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:Filter_main_en.png|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;
* '''Less than''': Data must be lesser than the selection (chronological for ''Date'' columns and alphabetical for ''Text'' columns);
* '''Greater or equal to''': Data must be greater or equal to the selection (chronological for ''Date'' columns and alphabetical for ''Text'' columns);
* '''Multiple Selection (In)Contains''': Data must ''contain'', ''starts with'' or ''end with'' the input text. For Text columns only; * '''Do not contains''': Data must not ''contain'', ''starts with'' or ''end with'' the input text. For Text columns only; * '''Between''': Date must be between the chronological selection. ''For Date columns only''; * '''Not between''': Date must be equal to any of not between the selected content (right column)chronological selection. ''For Text Date columns only''; * '''Is Null''': Data must be null (empty); * '''Not Null''': Data must be not be null (not empty);
===Filtering text type columns===
Text type columns can be filtered by selecting the desired values when using ''Equal to, Not equal to, Less than, Greater than, Less or equal to or Greater or equal to''.
[[File:Filter_rangeFilter_basic_en.PNGpng|link=]]
Basic selection screen.
[[File:Filter_likeFilter_adv_en.PNGpng|link=]]
Advanced selection screen.
[[File:Filter_edit_expFilter_dates_short_en.PNGpng|link=]][[File:Filter_dates_calen_en.png|link=]]