Skip to Main Content
Spotfire Ideas Portal
Status Future Consideration
Product Spotfire
Created by Guest
Created on Feb 6, 2016

Use SQL Server User table functions in Spotfire Professional Client through Information Designer .

Currently in Spotfire Professional Client through Information Designer , SQL Server User table functions doesn't work.
User wants Spotfire the ability to use SQL Server User table functions from information deisgner.

User created below function , but when user is trying to use this in Procedure in information designer , user is getting below error:

Failed to execute query: [tibcosoftwareinc][SQLServer JDBC Driver][SQLServer]The request for procedure 'fn_HelloWorld' failed because 'fn_HelloWorld' is a table valued function object

CREATE FUNCTION fn_HelloWorld ()
RETURNS TABLE
AS
RETURN
( SELECT 'Hello World' as HelloWorld)

User stated that there is lot of benefits of using functions. Specially for performance reasons.

  • Attach files