This article was created in response to a support issue logged with K2. The content may include typographical errors and may be revised at any time without notice This article is not considered official documentation for K2 software and is provided “as is” with no warranties.
A SmartObject created using an SQL Stored Procedure is not visible in the K2 Workflow Designer.
SmartObjects generated from Stored Procedures will not be available in workflows if those SmartObjects contain only 'List' method.
A workaround for this issue is to change the SmartObject's 'List' method to 'Read' method.
Please follow this KB which describes how to change the 'List' method to the 'Read' method: