In the example below it is assumed that
a) the filter is defined as in Example 2:
b) the character * is used to indicate that all values should be displayed (no filter should be applied).
to reproduce the example:
– take Example 2 and add or ‘$$IP_1$$’ = ‘*’ to the filter:
This means that a record is displayed if either product matches the input parameter value or the input parameter value equals *
If you fill * into the input parameter:
SELECT TOP 1000
SUM(“productRating”) AS “productRating”,
SUM(“amount”) AS “amount”
GROUP BY “date”, “product”;
all values will be displayed:
In essence the user can enter a value for which column product should be filtered, or request that all values should be displayed by entering *
Click here to navigate back to the context in which this example is discussed. You will also find further examples there.