Open main menu

TaticView β

Changes

Filters/en

145 bytes removed, 17:32, 21 September 2017
Updating to match new version of source page
<languages/>
 
 
'''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. Filters can be set by [[Permission filters|users]], [[Object Filters|objects]] or [[Column filters|columns]].
 
[[File:Filter.PNG|link=]]
 
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 [[Custom date shortcuts|created shortcuts]].
[[File:Filter_multiple.PNG|link=]]
 
* '''Between''': Data must be between the selection (chronological for ''Date'' columns and alphabetical for ''Text'' columns);
[[File:Filter_range.PNG|link=]]
 
* '''Like''': Data must ''Starts with'', ''Contain'' or ''Ends with'' the entered text. Available for ''Text'' columns only.
 
 
[[File:Filter_basic_en.png|link=]]
 
Basic selection screen.
 
 
[[File:Filter_adv_en.png|link=]]
 
Advanced selection screen.
 
 
[[File:Filter_like.PNG|link=]]
 
[[File:Filter_dates_short_en.png|link=]]
[[File:Filter_dates_calen_en.png|link=]]
* '''Clear all''': Remove all previous selections and set filters;
 
* '''Edit Expression''': Allows to manually create and edit filter rules by using programming language. See [[Expressions]].
 
[[File:Filter_edit_exp.PNG|link=]]
11,677
edits