User input parameter for External Content Type list

Question

I call a stored procedure with input parameter (say @name) from my custom SQL external content type list. The stored procedure needs end user key in the name and return values. Is that a way to create user input box and then load the SharePoint list?

I tried to add a filter to my input parameter from SharePoint Designer, but still can not have user input box generated.

Thank You!

Answer 1

Hi,

Please take a look at this article A step by step guide in designing BCS entities by using a SQL stored procedure

In this article you may find how to design a SharePoint BCS entity from a SQL stored procedure that takes some inputs and returns a list of records.

---

Dmitry

Lightning Tools Check out our SharePoint tools and web parts | Lightning Tools Blog

Answer 2

Hi,

Please take a look at this article A step by step guide in designing BCS entities by using a SQL stored procedure

In this article you may find how to design a SharePoint BCS entity from a SQL stored procedure that takes some inputs and returns a list of records.

---

Dmitry

Lightning Tools Check out our SharePoint tools and web parts | Lightning Tools Blog

Thanks for the reply. The article was great, however, it required a web part. My question was, can we created a SharePoint External List directly and let user input in parameter from there? Since SharePoint list provide view, edit, create, and delete option associated with nice infopath.

Thanks again!

 

Answer 3

Hi Leicd,

Please see Dmitry's reply on this thread.

http://social.msdn.microsoft.com/Forums/en-US/sharepoint2010general/thread/02aa3e69-12c6-4e8a-b434-76e8f8f2fcd7/

Usually one stored procedure should be associated with one operation when create an external content type.

Thanks & Regards,
Emir

---

Emir Liu

TechNet Community Support

Answer 4

Hi,

External List only allows to set a value by the view modification. If you want to change filter value in the External List you should go to "List" tab on the ribbon->"Modify View"->Scroll down to the "Data Source Filters" section->Enter the values for your filters->Click "OK". You may create as many views as you want with different values of the filters for your External List in SharePoint Foundation.

Take a look at my example with one wildcard filter for the "CompanyName" column in the ECT.

---

Dmitry

Lightning Tools Check out our SharePoint tools and web parts | Lightning Tools Blog