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:
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
SUM(“productRating”) AS “productRating”,
SUM(“amount”) AS “amount”
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.