Difference between revisions of "Filters/en"
(Importing a new version from external source) |
(Updating to match new version of source page) |
||
| Line 1: | Line 1: | ||
| + | <languages/> | ||
| + | |||
| + | |||
'''See a [[Object and Column Filters|video tutorial]] about how to use filters'''. | '''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]]. | 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=]] | [[File:Filter.PNG|link=]] | ||
| − | |||
| − | |||
| Line 27: | Line 29: | ||
[[File:Filter_multiple.PNG|link=]] | [[File:Filter_multiple.PNG|link=]] | ||
| − | |||
* '''Between''': Data must be between the selection (chronological for ''Date'' columns and alphabetical for ''Text'' columns); | * '''Between''': Data must be between the selection (chronological for ''Date'' columns and alphabetical for ''Text'' columns); | ||
[[File:Filter_range.PNG|link=]] | [[File:Filter_range.PNG|link=]] | ||
| + | |||
* '''Like''': Data must ''Starts with'', ''Contain'' or ''Ends with'' the entered text. Available for ''Text'' columns only. | * '''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_like.PNG|link=]] | ||
| + | |||
| + | [[File:Filter_dates_short_en.png|link=]] | ||
| + | [[File:Filter_dates_calen_en.png|link=]] | ||
| Line 43: | Line 60: | ||
* '''Clear all''': Remove all previous selections and set filters; | * '''Clear all''': Remove all previous selections and set filters; | ||
| − | |||
| − | |||
| − | |||
| − | |||
Revision as of 17:32, 21 September 2017
See a 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 users, objects or columns.
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;
- Between: Data must be between the selection (chronological for Date columns and alphabetical for Text columns);
- Like: Data must Starts with, Contain or Ends with the entered text. Available for Text columns only.
Basic selection screen.
Advanced selection screen.
Options
- Clear all: Remove all previous selections and set filters;
