Difference between revisions of "Filters/en"
(Importing a new version from external source) |
(Updating to match new version of source page) |
||
| (7 intermediate revisions by the same user not shown) | |||
| Line 2: | Line 2: | ||
| + | |||
| + | ==Filtering== | ||
| + | |||
| + | |||
| + | [[File:mainmenu5.png]] | ||
'''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 | + | It is possible to filter data by one or more ''Date'' or ''Text'' columns of the ''Data Source'' using the available '''Conditions'''. Filters can be set by [[Permission filters|users]], [[Object Filters|objects]], [[Column filters|columns]] or [[Dashboard|dashboards]]. |
| − | [[File: | + | [[File:Filter_main_en.png|link=]] |
| Line 14: | Line 19: | ||
'''Operators''' | '''Operators''' | ||
| − | * '''Equal to''': Data must be equal to the selection; | + | * '''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; | * '''Not equal to''': Data must be different from the selection. Multiple values can be selected; | ||
| Line 30: | Line 35: | ||
* '''Do not contains''': Data must not ''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''': | + | * '''Between''': Date must be between the chronological selection. ''For Date columns only''; |
| + | |||
| + | * '''Not between''': Date must be not between the chronological selection. ''For Date columns only''; | ||
| + | |||
| + | * '''Is Null''': Data must be null (empty); | ||
| − | * '''Not | + | * '''Not Null''': Data must be not be null (not empty); |
| − | Text type columns can be filtered by selecting the desired values. | + | ===Filtering text type columns=== |
| + | Text type columns can be filtered by selecting the desired values when using ''Equal to, Not equal to, Less than, Greater than, Less or equal to or Greater or equal to''. | ||
| Line 49: | Line 59: | ||
| + | |||
| + | ===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. | 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. | ||
| Line 54: | Line 66: | ||
[[File:Filter_dates_short_en.png|link=]] | [[File:Filter_dates_short_en.png|link=]] | ||
[[File:Filter_dates_calen_en.png|link=]] | [[File:Filter_dates_calen_en.png|link=]] | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
Latest revision as of 12:50, 17 July 2025
Filtering
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 Conditions. Filters can be set by users, objects, columns or dashboards.
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;
- 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);
- 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 between the chronological selection. For Date columns only;
- Not between: Date must be not between the chronological selection. For Date columns only;
- Is Null: Data must be null (empty);
- Not Null: Data must be not be null (not empty);
Filtering text type columns
Text type columns can be filtered by selecting the desired values when using Equal to, Not equal to, Less than, Greater than, Less or equal to or Greater or equal to.
Basic selection screen.
Advanced selection screen.
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.
