Configure Query Parameters

On this wizard page, you can manage parameters that are used in queries and/or stored procedures selected on the previous wizard page, as well as specify parameter values.

  • Parameters can be assigned static values (according to the specified parameter type), which is illustrated in the following image.

    data-source-wizard-database-parameters

  • Another option is to calculate a parameter value based on an expression. To do this, enable the Expression check box and run the Expression Editor.

    data-source-wizard-database-parameters-expression

To delete a specific parameter, select it on this wizard page and click Remove.

To create a new query parameter, click Add.

To execute a query or stored procedure with the specified parameter values, click Preview.

When previewing a query or stored procedure result, only 1000 first data rows are displayed. If a query contains a custom SQL, the entire result set is obtained.