For example, consider the sample query /Public Queries/Reports/State Query. This query includes a dynamic filter that lets you specify one or more state values. Each ClearQuest client provides an interface to prompt for the operator and filter values. In the data-pull reporting model, the ClearQuest Reporting Driver also needs a mechanism for retrieving this information.
Because dynamic filters prompt for two pieces of information, the ClearQuest Reporting Driver treats each filter as two separate parameters. At runtime, you specify the filter operator and values. The samples included on the distribution include a BIRT library that contains a sample operator parameter that you can use for displaying operators. You can use the sample parameter directly, or copy the controls for your own reports.
The IS_BETWEEN and IS_NOT_BETWEEN operators present a challenge when using the data-pull reporting model because a total of three arguments (operator, low-operand, and high-operand) are required. The ClearQuest Reporting Driver does not directly support the IS_BETWEEN and IS_NOT_BETWEEN operators. However, you can achieve the behavior of these operators by creating a ClearQuest query that uses two filters grouped with an AND in the query builder. At runtime, the ClearQuest Reporting Driver creates four parameters for the two filters, simulating the IS_BETWEEN and IS_NOT_BETWEEN operators.
In the following examples, the text strings in bold are the values that you supply at runtime.
Consider the following filter expression:
DateField
IS_BETWEEN
12-12-2005
AND
12-12-2007
The same results can be achieved by using two filters, as shown in the next example:
DateField
IS_GREATER_THAN_OR_EQUAL
12-12-2005
AND
IS_LESS_THAN_OR_EQUAL
12-12-2007