new to k2 : I have 2 sprocs that inserts and selects and when added as smartobjects - the insert sproc has only the 'Execute' method listed and the select sproc has only the 'List' method listed. I cannot create a smartobject with only the 'Execute' method, but i can create a smartobject with only the 'List' method or both methods.
Creating a view off the smartobject shows 2 method - item view and list view and these methods are mapped only to the 'List' method of the smartobject, but on selecting the item view - the fields shown are for the 'List' method that are mapped to the select sproc and the button control has only the 'Execute' method listed.
After creating the view, i click the button that is mapped to 'Execute' method and a validation pop up shows up asking that the 'Execute' method params are required - meaning the fields on the form are mapped to the 'List' method and the button is mapped to the 'Execute' method and no connection between them.
My question: how do i use the execute method to create the view so the right fields are mapped on button click? I've tried to manually map the fields from the list method to the fields on the execute method but the option is not listed. Do i need to modify the sproc or merge them?