Writing SQL query in BCS
-
jueves, 19 de abril de 2012 11:59
Hi Everyone,
Till now i used BDC for MOSS 2007. In that i can able to change the query what ever i want to display in the sharepoint site in the XML file or in application definition designer tool. Now i am moving to SharePoint 2010 BCS . In this can i write my own query and is it possible to display the data in the sharepoint site. I followed the following the below article and created external content type with filters . Upto this i m fine.
http://arsalkhatri.wordpress.com/2012/01/07/external-list-with-bcs-search-filters-finders/
http://lightningtools.com/blog/archive/2010/01/14/creating-comparison-and-wildcard-filters-for-bcs-in-sharepoint-designer.aspxBut my requirement is where can i write my sql query. So did any one work on this. Please help me how to write our own sql query and display the data in the sharepoint list. Please donot use Visual Studio. Without using visual studio is it possible for getting my requirement.
If any article is there on this please share the linkThanks in advance,
Kishore
Kishore
- Editado Kishorekv jueves, 19 de abril de 2012 12:01
Todas las respuestas
-
jueves, 19 de abril de 2012 13:21
Kishore,
I've used a 3rd party shareware add on to simply enter my query to connect a SharePoint 2007 list to external data:
http://www.layer2.de/en/products/Pages/SharePoint-Business-Data-List-Connector.aspx
See the video on page. Hope that helps.
Thanks, Frank
- Marcado como respuesta Kishorekv jueves, 19 de abril de 2012 14:03
-
jueves, 19 de abril de 2012 14:05
Hi Frank,
Thanks for sharing nice video. Can you please guide me how to add the filters to filter the data. Can you also tell me is there anyother way without using the 3rd party tool?
Thanks and regards,
Kishore
Kishore
- Editado Kishorekv jueves, 19 de abril de 2012 14:10
-
jueves, 19 de abril de 2012 14:24
Kishore,
You can filter on different levels with BDLC. First you can filter directly in the SQL query, e.g. using a "where" expression. Finally you can filter using views in SharePoint for your list data, web parts for dynamic filters. So you have all native list features available...
Thanks, Frank
-
viernes, 20 de abril de 2012 9:12
Hi Kishore,
In SharePoint 2010 you may also correct BDC Model file (XML file) manually and modify SQL query in it. You may export deployed BDC Model either via SharePoint designer or through Central Administration. After that you will be able to modify XML BDC Model file and import it again as you did in SharePoint 2007.
Dmitry
Lightning
Tools Check out our SharePoint tools and web parts |
Lightning Tools Blog
- Editado Dmitry KaloshinMicrosoft Community Contributor viernes, 20 de abril de 2012 9:15
- Marcado como respuesta Kishorekv viernes, 20 de abril de 2012 13:16
-
viernes, 20 de abril de 2012 13:18
Hi Dmitry,
Thanks for your answer. Is there any way other than this. We want personalization also. So can you please guide me.
Thanks
Kishore
Kishore
-
viernes, 20 de abril de 2012 16:08
Hi Kishore,
The way to do an import and export? An export you my do via SharePoint designer. You should right click on the external content type and export the BDC Model.
Dmitry
Lightning
Tools Check out our SharePoint tools and web parts |
Lightning Tools Blog
.png)
