Advanced Query Parameters

The Parameters folder allows you to define input parameters for your advanced query. The input parameters can be used in one of two different ways:

To send values to the query: This is the most common use of input parameters and allows you to use variables in your condition. In this case the parameter must have the Expand Inline property set to No.

For example, your condition depends on the country value provided by the end-user, so you must type something like this:

To form part of the query: This is useful when you want to specify the query or parts of it at runtime. In this situation the parameter must have the Expand Inline property set to Yes.

When using expand inline parameters, you should use the EncodeSql function to prevent SQL injection in the database.

For example, you want to execute a query with an "order by" clause that depends on the input provided by the end-user: You can order by name, by address, or not at all. It is possible to have the same advanced query with the order by criteria specified through an input parameter.

Adding a Parameter

How to add a Parameter to an advanced query:

Launch the Advanced query editor, right-click on the Parameters folder, and select Add Parameter.

Specify the properties of the Parameter. How?

Using a Parameter

How to use a Parameter in an advanced query:

Launch the Advanced query editor.

Double-click on the Parameter in the Parameters folder to expand it into the Logic canvas or directly type in @Parameter_name.

Instantiating a Parameter

How to instantiate a Parameter:

In the Action flow, select the Advanced Query element and, in the Properties window, specify its arguments. How?