Open main menu

TaticView β

Changes

Filters/en

673 bytes added, 17 July
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'';
[[File* '''Not between''':Filter_multipleDate must be not between the chronological selection.PNG|link=]]''For Date columns only'';
* '''BetweenIs Null''': Data must be between the chronological selection. For Date columns onlynull (empty);
[[File* '''Not Null''':Filter_range.PNG|link=]]Data must be not be 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''.
[[File:Filter_like===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.PNG|link=]]
[[File:Filter_dates_short_en.png|link=]]
[[File:Filter_dates_calen_en.png|link=]]
 
 
 
'''Options'''
 
* '''Clear all''': Remove all previous selections and set filters;
11,856
edits