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 :

DataSource add table function

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 :

stored procedure parameters

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” :

stored procedure parameters static

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 :

stored procedure parameters dynamic

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

use parameter
param default value

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 :

stored procedure edit
Last modified: Mar 13, 2019

Feedback

Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.

Post your comment on this topic.

Post Comment