Skip to main content

Hello,

 

 I am having trouble with populating the multi-select with the fields coming from the stored procedure.

 

The scenario is: I need to create a drop-down menu with names of SQL database tables and on the selection of a particular table, the column names of the table should be populated in the multi-select control. The delimeter I am using is a comma (,).

I wrote the stored procedure where the input is the tableName and output is the list of columnName.

In K2 form, the rule I'm using is:

        When the drop-down is changed, execute the smart object method

(the drop-down list is the input data for the Stored procedure Smart Object and output is the multi-select control)

I am a newbie to K2 and I don't know why is it not populating? 

Any help will be really appreciated.

 

Thanks.

The actual rule to execute when the dropdown list is changed is "Populate List". Just executing the SmartObject that populates the list doesn't have the link to the multi-select list control. That sounds kind of vague when I re-read it, but let me know if that helps or not. I can get more specifics if needed.


Reply