New answers tagged

0

Like Melanie Culver alluded to a CAML query can be used to pass the parameters directly to the stored procedure. My external content type has an input parameter like this and I can specify my input parameter by name in JavaScript like: var viewXml = '<View Name="{my view GUID}" >' viewXml += ' <Method Name="GetTaskListForUserSite">' ...


1

I had the exact same challenge yesterday and found a solution. I came across this blog post: https://blogs.msdn.microsoft.com/chjain/2013/03/01/getting-data-from-large-external-lists/ One problem I had though was, that if I didn't list all the fields in the view fields, I got a KeyNotFound exception. I put the CAML query in the solution suggested here: ...


1

Please find the steps to be followed in SharePoint Designer to achieve your desired result. SharePoint 2013: BDC Configuration And Creating External Content Type and External List UPDATED SharePoint List From SQL Server Table (External Content Type with SharePoint Designer) Please let me know if you need some more help. Thanks.


0

From your dev system you can export External Content Types and import it in client system. After import you can open the external system and update SQL server information.


0

Since its pulling the list data and not replicating, you can configure Hybrid federated search between the environments and create a result source specific to on-premises. Use this result source in Content search or Search result WebPart query and show the items.


0

I was facing the same problem these days and found the solution in my case ! I'm posting this hoping that it would help. Context: Sharepoint 2013 Online. External data in SQLSERVER 2012. Scenario: via SPD, I've created an external content type, choosing SQL server for the data source. I've created an external list from this ECT. Problem: In my site, ...


0

I was facing the same problem these days and found the solution in my case ! I'm posting this hoping that it would help. Context: Sharepoint 2013 Online. External data in SQLSERVER 2012. Scenario: via SPD, I've created an external content type, choosing SQL server for the data source. I've created an external list from this ECT. Problem: In my site, ...


0

You can create different external systems for each of the database server. And use the external system while creation ECT's. I am not use using IP vs Name has any impact as both should resolve as expected.



Top 50 recent answers are included