Hi all.

I am (very) new to K2. As in - we still have consultants doing our K2 development for us for the time being. We want our current system to integrate with a brand new K2 solution.

I have a question about the source stored procedures used for Smart Objects. A lot of our stored procedures are very complex, using conditional statements and temporary tables. However, our consultants are telling us these stored procedures is a problem because K2 tries to automatically get the schema for the smart object from the stored procedure. This would mean that we'll need to write a lot of duplicate code, and I'm not sure that we'll be able to get away from conditional statements and temporary tables in all cases, as we have some very complex stored procedures.

I was wondering - isn't there some way arround it? I find it a bit weird that a product as powerful and versatile as K2 would have such a terribly restrictive limitation build into it?

Isn't there a way to define the schema manually - rather than to derive it from the stored procedure? Or is it perhaps possible to give it a different stored procedure that would just define the result set table, and then I can still use my original complex stored procedure to populate the data? 

We would prefer not to add an unnecesary webservice layer in between - as this would introduce a compiled code layer which would limit agility. Surely, there must be a way for K2 to interact with very complicated stored procedures directly.

Thanks.