An external list is a list published outside of the scope of SharePoint usually with the tool Business Connectivity Services (BCS).

learn more… | top users | synonyms

0
votes
1answer
338 views

lookup external list

I have two tables: Documents Project task What I am looking for is the following: I have a page with project tasks in a hierarchy list (done) Clicking on a task will open an edit screen (done) ...
0
votes
1answer
575 views

Logical AND ,OR CAML Query not working in External List

I am using ClientContext Class and CAML query to retrieve items from External List in sharepoint 2010.I have built the query with Logical AND Condition in CAML Query like this string sDataFilter ...
0
votes
2answers
2k views

How to edit InfoPath form from SharePoint Designer when it only returns an error message

I'm trying to edit an InfoPath form for an external list from SharePoint Designer. After clicking on the "Design Forms in InfoPath" button I get the following error: "Object 'blablabla.rem' has been ...
0
votes
1answer
106 views

Connect web part to list on separate Sharepoint Instance

As part of a migration process, I'd like to have a list view on the new environment(SP2010 standard) that's connected to a list in the previous environment(WSS 3). So different servers, site ...
1
vote
0answers
576 views

PageNumber-Fillter for Finder in .Net Assembly Connector

I'm currently trying to use an PageNumber-Filter for an Finder-Method in an .NET Assembly Connector. The relevant Part of the Method-Definition of the ReadList-Method looks the following. <Method ...
2
votes
2answers
1k views

Filter an External List on a datetime Field

So I have an external list in SharePoint 2010 that connects to a SQL database and pulls the data successfully. I also have 2 filters defined along with a limiting (TOP) filter. The first filter is ...
6
votes
4answers
4k views

Working with large external lists using BCS

I have a database that I want to display the content in SharePoint 2010. I am not displaying the content in a list but am using a custom WebPart. The database is not updated any more as it is ...
1
vote
1answer
250 views

Association between a custom list and an external list

I have a very basic question. I have a Custom List and I'd like to add a lookup column from an External List based on a WCF Service. Is it possible? E.g. I have employers in a custom list. I'd ...
2
votes
0answers
849 views

Sharepoint external list problem

I'm taking my first crack at creating an External list in Sharepoint 2010. I've taken 3 training classes in Sharepoint 2010, and am now trying to transfer my knowledge to my own development ...
1
vote
2answers
988 views

External list with bulk amount of data does not work properly

I have created and external content type to fetch data from a SQL table. The table currently contains 8000 records. So when I create an external list from that content type the list does not display ...
2
votes
2answers
5k views

How to read items in a BCS external list with PowerShell?

Is there a way that you get information from an external list (created from SPD for a specific ECT) differently than you do from a "normal" SharePoint list when using PowerShell? I did the following: ...
2
votes
3answers
2k views

How to authenticate BDC to the external system?

I'm using the following tutorial to define a workflow on a SharePoint list to create an element in and external List. When the workflow action tries to create the item in the external list, it fails ...
2
votes
3answers
6k views

How do I associate Workflows to SharePoint 2010 External Lists?

I've read that you can't associate workflows to SharePoint 2010 external lists but that there are workarounds for doing it. What do those workarounds involve? Can I do all of it in the Sharepoint ...
2
votes
2answers
524 views

Additional datasource in infopath

Is there any way to add additional datasources to an infopath form when using an external list? Infopath always complains about the form not being valid, because of the addinal datasource.
1
vote
1answer
1k views

Custom NewForm for external content type?

Is it possible to create a custom NewForm for an external content type without using InfoPath?
0
votes
0answers
220 views

Enterprise - External Task List - Connect to Outlook- setting Assigned To

I've got an External List coming from an External Content Type which has Office Item Type of "Task". It comes from an external system which has its own concept of a task, and I'm pulling them into ...
1
vote
1answer
632 views

Custom View Header Rendering Twice on External List

I'm starting to work with custom view stylesheets on an external list. I am finding the header is rendering twice - once upon initial page render and again after the data is returned from the server: ...
3
votes
2answers
769 views

Is it possible to programmatically invoke a workflow on external list items?

Is it possible to invoke a workflow on an external list programmatically and pass parameters into the workflow? Is there an example using SharePoint 2010?
3
votes
1answer
453 views

How can we use multiple fields from an external list in a survey?

We are trying to build a survey, that uses data from an external list. It works fine for a single field. But what we would like to do is to bring about 10 fields back from the external system and ...
0
votes
1answer
438 views

How can I update an external list connected to SQL?

I am working with Project Server 2010 and SQL Server 2008. I would like to create a multiple item form that connects to SQL Server. I tried using an external list in SharePoint that connects to SQL. ...