11,677
edits
Changes
Importing a new version from external source
'''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]].
'''Operators'''
* '''Equal to''': Data must be equal to the selection;
* '''Not equal to''': Data must be different from the selection;
* '''Less than''': Data must be lesser than the selection (chronological for ''Date'' columns and alphabetical for ''Text'' columns);
* '''Greater than''': Data must be greater than the selection (chronological for ''Date'' columns and alphabetical for ''Text'' columns);
* '''Less or equal to''': Data must be lesser or equal to 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)''': Data must be equal to any of the selected content (right column). For Text columns only;
[[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_like.PNG|link=]]
'''Options'''
* '''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=]]
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]].
'''Operators'''
* '''Equal to''': Data must be equal to the selection;
* '''Not equal to''': Data must be different from the selection;
* '''Less than''': Data must be lesser than the selection (chronological for ''Date'' columns and alphabetical for ''Text'' columns);
* '''Greater than''': Data must be greater than the selection (chronological for ''Date'' columns and alphabetical for ''Text'' columns);
* '''Less or equal to''': Data must be lesser or equal to 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)''': Data must be equal to any of the selected content (right column). For Text columns only;
[[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_like.PNG|link=]]
'''Options'''
* '''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=]]