End users of your applications are often likely to have some tool for extra data handling. They want some simple and easy-to-use user filter and they'd like to control data sorting. Building CleverFilter in your applications you will enable them to control the data.
features:
- Supports different database and SQL-server formats using adapters. The build includes adapters for FIBPlus, ADO, BDE, IBX, dbExpress and ODAC.
- CleverFilter may change the WHERE query clause, thus helping to handle the data on the server and save the client machine resources.
- Supports parameter queries. Due to this, on changing parameter values on the filter, server doesn't need to prepare the query anew for execution.
- Supports lookup-fields..
- Supports main field types: string, integer, Date and Time fields, and has emulation of logical fields using value lists.
- Uses special visual filter elements for users' convenience: enables to set value ranges (between), lists of possible values (radio button, check list, list box), and a pop-up calendar for Data fields.
- Has simple and user-friendly visualization of complex queries with OR and AND.
- Enables to insert filter conditions into any place in the main query.
- Provides programmers with an ability to choose fields available in the user filter.
- Provides users with an ability to use the filter without studying the internal database structure.
