Stored Procedure Transaction Group - RETURN_VALUE

Ignition
1

I am having some issues with the Stored Procedure Transaction Group and returning a table that my procedure is creating. I have tried writing the table to a variety of tag types but can not find any documentation on how these return values are handled in Ignition. I am using a MSSQL server for the stored procedure.

This is my procedure output when tested on the server side.
image

image
image778×170 8.55 KB

2

I know this is an “Old” topic but I have the same issue and the documentation on this is poor to say the least. Any additional help would be greatly appreciated.

3

Chirs, I ended up using a named query and calling the stored procedure directly into a query tag with that.

I think to get the transaction group to work it had to return each value to an individual tag.