Populate the Multi-select control with values of SQL stored procedure

  • 22 January 2019
  • 1 reply
  • 39 views
M

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.

1 reply

T
Userlevel 5
Badge +13

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


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings