Example 3: Filter with input parameter for a certain substring

This example is referenced in my other post about input parameters. Please have a look at the other post to get a better understanding of the context for this example

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.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Example 3: Filter with input parameter for a certain substring

Assigned Tags