Bold BI allows you to execute the table-valued function using the
Microsoft SQL data source code view by following these steps.
Create a table-valued function in the
Microsoft SQL Server before connecting the data source in Bold BI.
CREATE FUNCTION tableValuedReleases ( @ReleaseId INT ) RETURNS TABLE AS RETURN SELECT ReleaseId, ReleaseDate, ReleaseVersion, LastModifiedDate, IsActive FROM Releases WHERE ReleaseId = @ReleaseId;
Refer to the Connecting Bold BI to SQL data source to successfully connect to it.
After connecting to the data source, switch to the code view by enabling the slider option in the tools pane in the data design view, and you can find the query editor window in which you can execute the custom queries as follows.
Here, you can enter the query to fetch the data from the
tableValuedReleases table-valued function by passing the value for the
ReleaseId parameter. After entering the query, click on the
Run button to execute the query.
You can view the data for your query at the bottom of the query editor by clicking