Examples of Filters in Time
Example 1:
Entry in the Expression pane:
- [Office].[Office] is equal to ‘TOR’
- [Employees.Address].[City] is equal to ‘Toronto’
Displayed in the Filter pane:
- [Office].[Office] is equal to ‘TOR’ AND [Employees.Address].[City] is equal to ‘Toronto’
Example 2:
If you want to build a filter that means the following:
- Receivables source field not equal to 'WP'
SQL requires 2 expressions
- ( LTRIM([Receivables].[Source]) is not equal to 'WP' ) OR
- ( LTRIM([Receivables].[Source]) is blank )
The second expression must be included to get any transactions that have a blank source field to appear.