Appian Community and Appian Academy are being upgraded. From July 24–August 3, the Appian Community will be in read-only mode. During this time, the site will be read-only and user registration will be disabled. We apologize for any inconvenience this may cause, but a more secure, stable, and performant Community experience is coming soon!
The new Appian Community launches August 3, followed by Appian Academy on August 7. During the migration, Appian Community Edition, Appian Academy, Documentation, Certifications, Instructor-led Customer Training, Partner Sales Training & Accreditation, and Forum (for Appian Partners and Customers only) will remain available.
Hello everyone,
I have a question that table function is created in the database with set of columns and How will I use the table function in appian with some parameters?
Can anyone please help me to further proceed?
Thanks in advance.
Discussion posts and replies are publicly visible
If you want to obtain data from a Table-valued Function in your database, you can create a view that queries the function, and set a data type / data store up on the view, same way as you would for a normal table.
I do this in one scenario where a report is generated by a function that creates/returns a temporary table, ended up being better for performance this way in my scenario, where lots of data is aggregated for a weekly summary.
CREATE view [dbo].[VIEW_FROM_FUNCTION] as select [Col1], [Col2] /*etc*/ from dbo.fn_YOUR_TABLE_VALUED_FUNCTION() GO
I am getting the error while creating new Data type
Did you try to follow the advised steps in the error message?