Modifying BDCM files
-
Hello!! I created an external content type from a sql database using sharepoint designer 2013. My database has a table named UsedRooms and has Id, Place and Description columns. I just define Read Item and Read List methods. Then I created an external list using that content type and I have the information from my database. When I exported my bdcm file I found that my ReadList is just a query to sql. In this case: select [Id], [Place], [Description] from [UsedRooms] Order by [Id](more or less) I want to add another column on my external list to have the total of places used, { Count(Place)}, I though I can achieve that changing that query to: select [Id], [Place], [Description], Count(*) from [Customers] group by [Id],[Place], [Description] order by [Id], but I can't see nothing new on my list. I created one typedescriptor of type Int32 in my return descriptors named PlacesCount and changed my query to: select [Id], [Place], [Description], Count(*) as PlacesCount from [Customers] group by [Id],[Place], [Description] order by [Id], Now, the external list said error: "Unable to retriev data". I did the same thing for sharepoint 2007, Why is not working in 2013??:confused: