You can predefine filters in business views for end users to choose when they design or modify web reports and library components. The following example shows the basic usage.
Notes:
String Value
Rules: Quote the values with single quotes.
Example1: Customers_Country='USA'.
Example2: Customers_Country in 'Australia','Germany','Mexico'
Date Value
Filters are done in the RDBMS side and some RDBMS have special requirements for the date format, so you need to make sure the date formats specified in the Data Format tab of the Get JDBC Connection Information dialog are supported by your database.