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;
* '''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 equal to any of between the selected content (right column)chronological selection. ''For Text Date columns only'';
* '''BetweenIs Null''': Data must be between the chronological selection. For Date columns onlynull (empty);
[[File:Filter_dates_short_en.png|link=]]
[[File:Filter_dates_calen_en.png|link=]]