HP Intelligent Management Center Standard Software Platform - Manual (Page 476)

The Filter Editor appears.
2. Change the definition of the filter in the Filter Editor.
For information on how to define filters, see Creating query filters .
3. Click OK to confirm your changes.
The modified query appears in the Query Filters pane.
To remove a query filter
• Drag the filter you want to remove and drop it onto the left-hand pane.
The filter is removed from the query definition and no longer appears on
the Query Filters pane.
Filtering data using subqueries and
database ranking
This section explains how to work with more advanced types of query filters.
It covers the following advanced query filters:
• Subqueries
• Database rankings
Subqueries and database rankings allow you to create filters that are much
more powerful than standard query filters.
What is a subquery?
A subquery is a more flexible kind of query filter that allows you to restrict
values in more sophisticated ways than with an ordinary query filter.
Subqueries are more powerful than ordinary query filters for the following
reasons:
• They allow you to compare the values of the object whose values are
used to restrict the query with values from other objects.
476 Crystal Reports 2008 SP3 User's Guide
Building Queries 18
Filtering data using subqueries and database ranking