Building Query Filters

Building query filters can be difficult if you are not familiar with the data that you are querying. A sales database, for example, might contain customer names that are abbreviated, which can complicate the process of entering the correct customer name. BLR Rosetta solves this problem by offering a drilldown window that shows all unique values in a data column alongside a record count of occurrences.

BLR Rosetta also implements cascading query filters, which means that you will only see database values that match the current constraints of your query. For example, if you select State Equals Colorado in the query editor, and then you request a list of counties to filter, you will only see the counties that appear in Colorado. Cascading query filters insure that you only pick filters that make sense in the context of your query.

The Filter Value window, where you can select filters directly from your database, is illustrated below: