Getting values from SQL Server table using store procedure for the filtered items

R
Badge +6

new to K2 using store procedure

 

I have four drop down controls in the smartform and i have a button called search.

 

In the drop down controls i am going to select values in the each dropdowns and click search button.

 

Based on the selected value in the dropdown i have to pass the selected value as a query to SQL table and get the record from the table and show in the gridview using Store Procedure.

 

****** All the records created /stored in the SQL Table.

 

Please Kindly help on this. 

 

And let me know if any other way to achieve the above functionality.

 

Thanks in advance.

 

 

 

2 replies

D
Badge +11

You can use stored procedures with our SQL Server broker:  https://help.k2.com/onlinehelp/k2five/userguide/5.1/default.htm#servicebrokers/sqlserver/sql-server-service.htm

 

Once you create a SmartObject you can pass in the selected values from the dropdown list to a SmartObject.

 

David

T
Badge +10

Hi


 


You can create a Stored Procedure with 4 Input properties. When you create a SmartObject from this SP, the SP input properties will be created as SMO input properties. Then you can execute the SMO with the dropdown values used as the inputs.


 


HTH


 


Cheers,


T

Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings