Rameshbabu
Apprentice

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

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.

 

 

 

0 Kudos
Reply
2 Replies
DavidL1
Apprentice

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

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-...

 

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

 

David

Reply
ThinusC
Nintex Employee
Nintex Employee

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

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