Example 3: Filter with input parameter for a certain substring
We will filter for the substring ng (e.g., oranges) in column product using SQL function LOCATE.
To create the example:
a) Change in Example 2 the filter expression to:
LOCATE(“product”, ‘$$IP_1$$’)
b) Save, build, and preview the Calculation View. When asked for a value enter ng
In result you will see all records for which the value in column product contains ng:
Based on the past experiences the generated SQL statement should not be surprising:
SELECT TOP 1000
“date”,
“product”,
SUM(“productRating”) AS “productRating”,
SUM(“amount”) AS “amount”
FROM “INPUTPARAMETERS_HDI_DB_1”.”inputParameters.db::example3″
(placeholder.”$$IP_1$$”=>’ng’)
GROUP BY “date”, “product”;
Click here to navigate back to the context in which this example is discussed. You will also find further examples there.