Difference between revisions of "Filters"
| Line 1: | Line 1: | ||
| − | It is possible to filter | + | It is possible to filter data by one or more ''Date'' or ''Text'' columns of the ''Data Source'' using the available operators. |
[[File:Filter.PNG|link=]] | [[File:Filter.PNG|link=]] | ||
| Line 41: | Line 41: | ||
[[File:Filter_edit_exp.PNG|link=]] | [[File:Filter_edit_exp.PNG|link=]] | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
Revision as of 14:21, 22 May 2013
It is possible to filter data by one or more Date or Text columns of the Data Source using the available operators.
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);
- 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.
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.
