fetching data from a Table-Valued Function

Table-Valued Functions without parameters

To get data from a Table-Valued Function, browse to the desired Table-Valued Function in the schema and drag it to the top main area :

If the Table-Valued Function takes no input parameters, then that’s all.

If the Table-Valued Function does take input parameters, then please proceed below :

Table-Valued Function with parameters

If the Table-Valued Function takes input parameters, a dialog appears to let you set the parameters. It lists the input parameters and their data type :

Table-Valued Function with static parameters

To fill in static values for the Table-Valued Function parameters, simply fill the text boxes and click “OK” :

With a static value, the Table-Valued Function will always be called with the value you entered.

Table-Valued Function with dynamic parameters

Instead, you can bind a Table-Valued Function parameter to an Alpana Dashboard Parameter (see the dedicated Course Chapter on Parameters).

This will allow you for example to change the Table-Valued Function call depending on Master Widget clicks on the dashboard.

To do so, in the “Table-Valued Function Parameters Editor” dialog, check “Use Parameter” and select an existing Alpana Dashboard Parameter :

You can also create a Parameter directly form this dialog by clicking the parameter list button :

*Note :
Be careful that some Table-Valued Function require non empty parameters. In order to complete this step, you may have to set a default value to the Alpana Parameter :

Editing existing Table-Valued Function parameter binding

Once the Table-Valued Function parameters are bound, you can change them at any time by clicking the “Edit Parameters” cog icon on the corresponding table :

Code192 2020 All rights reserved