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

2
votes
0answers
359 views

Alerts on SharePoint 2013 External List

I have created an external list using an external content type reading from a database server on our network that is not on the same machine as our SharePoint database server. I am also sysadmin on ...
0
votes
1answer
444 views

Create external content type with impersonated custom identity

I'm developing a SharePoint Application. I have SharePoint Foudation 2010. I have created a External Content Type with Impersonated Custom Identity(Connection to SQL Server 2012). After I created a ...
2
votes
1answer
217 views

Create External List on SharePoint online

Does anyone knows if it's possible to create an external list from another external list? Is it possible to create an external list on SharePoint Online from an existing external list on SharePoint ...
0
votes
1answer
101 views

XSLT not displaying data from Arabic column external list

I have an external list named "users". It is coming from SQL Server and has following two columns: English_Name varchar(300) Arabic_Name nvarchar(300) Notice the Arabic_Name field has data ...
0
votes
1answer
377 views

Return value of the dropdown list rather than text when creating an item

I'm following this example: http://www.martinhatch.com/2013/08/jslink-and-display-templates-part-3-creating-a-custom-editing-interface.html I have a dropdown on the create new item page (external ...
0
votes
1answer
233 views

How SP generates ID for each list item

When you click open an item in an external list, you have a url like this: ...
0
votes
1answer
429 views

Secondary lookup columns for external content types not displaying data in list after refreshing from primary

I have created a SharePoint list that has a lookup column to an external list. I also have instructed SharePoint to display several secondary columns that are related to that primary external lookup ...
1
vote
2answers
2k views

How to get the current custom view name of my SharePoint List

I am using the following JQuery to get the current name of the View for External SharePoint list. var ctx = GetCurrentCtx(); var listName =ctx.ListTitle; var currentView = ...
0
votes
2answers
142 views

JSLink doesn't work when it got redirected from list item page

I have a JSLink file to customise an external list and list items. context.Templates.Fields["VM_NAME"] = { "View": VmNameRenderCallback }; ...
2
votes
1answer
138 views

[Today]-15 filter not working on external list

I have an external list which is getting data from SQL Server. The table structure is as follows: Name InsertDate Where InsertDate is the date when record was inserted. I am trying to show only ...
0
votes
1answer
121 views

Open item from a different External List (BDC connector)

I have a "Quote List" and "Task List". Both are external lists, using BDCM custom connector (from WCF services) I'm using Sharepoint 2013. A new task will be create when a quote is approved. So on ...
1
vote
1answer
275 views

Read items from External list in Sandbox Solution

Can we read an external content type using a sandbox solution for share point online? If anyone has faced this issue then please share how is it possible. Thanks
0
votes
0answers
616 views

Get Items from External List using BdcIdentity on server

I added a ribbon Action on an external list. When the users clicks the Button in the ribbon I use SP.ListOperation.Selection.getSelectedItems() to get the ids and of thr items the user selected. ...
0
votes
0answers
90 views

Cant get items from external list

I have an External list based on an External Content Type that is connected to Dynamics CRM. In an event receiver (C#), I successfully get an SPList instance that is able to print the 'Title' and ...
0
votes
1answer
479 views

External List - changing a column to dropdown in Sharepoint 2013

I'm on Sharepoint foundation 2013. I have a external list (based on a WCF) For the new and edit form, I'd like to have some columns to be a dropdown (list to be populated from another WCF) Is ...
1
vote
1answer
276 views

External List - change a column to dropdown (Sharepoint 2013)

I'm on Sharepoint foundation 2013. I have a external list (based on a WCF) For the new and edit form, I'd like to have some columns to be a dropdown (list of selections to be populated from another ...
1
vote
1answer
31 views

Do I need Kerbros when I want to configure external list?

I am assigned a task to configure external list, and I am reading that if I want to delegate authentication to external sources, I need to set up Kerbros, do I need to configure Kerbros on the ...
3
votes
0answers
124 views

Ribbon is disabled when I Filter an external list in SharePoint 2010

I created an external list in sharepoint 2010 (SP1) using SPD. The backend is sql server. The I added a wildcard filter on a column called Source_System (and a limit filter). The out of the box ...
1
vote
0answers
184 views

Sharepoint 2013 - External List view/edit item in modal dialog

I have an External List, reading from a WCF. When I open an item (view item), I want it to open in a modal dialog. The External Data Source has 'read item' and 'read list' set up from WCF services. ...
3
votes
0answers
222 views

How to filter a paged and sorted external list

I have succesfully implented an external content type with a read list method, which can sort and page through the external data. The external content type has 4 filters (two limit and two wildcard) ...
2
votes
1answer
158 views

How do I manipulate an external list view's columns with javascript?

I want to manipulate the columns of an external list view (XsltListViewWebPart), however, as the data loads asynchronously I must wait for the data to load and the table to be generated before my code ...
0
votes
0answers
18 views

2 External Lists Can't be together in the same Site Collection

This 2 external lists are different projects, which developed by VS 2012. So when I deploy one of them, they have to not effect eachother. But these effects eachothers. Here is the situation: ...
0
votes
1answer
162 views

Configure “Check if item exists” in external item picker

I work on the edit form of an external list. I can pick items from an associated content type with a picker. There is the option to "Check if item exists", but currently it only accepts IDs. Can I ...
0
votes
2answers
500 views

save fails with controlmode=“display” on form field based upon an association

I have a sharepoint external list with an edit form containing a form field based upon an association. The field is not nullable. I want to prevent edits on the field, so I set controlmode="display". ...
1
vote
0answers
105 views

Send email after creating New Item in External List

I am using SP 2013 and I have an external list. But when I created a new item, I want to send e-mail to the specific people. Workflow is disabled for external lists. So can we create a new method in ...
0
votes
1answer
961 views

Add Column to External List from Updated External Content Type

We are currently trying to understand the relationship between External Content Types and External Lists within SharePoint 2013. We have a read-only ECT which we defined based on a SQL Server View. ...
0
votes
1answer
57 views

Problem showing External List in a page

I have a external content type that is showed in section of lists (Insert in Ribbon). I want to add it to a page but when is added, It shows list of BDC Identity, and when I click on them, main data ...
1
vote
0answers
146 views

Custom List Form works fine in Infopath but gets stuck when deployed

I have a custom list form for whenever I add a new item to a custom list. This form connects to an external sharepoint list that has 3000 records. When you type a client ID it will connect to the ...
0
votes
2answers
174 views

Get Items from View of an Extrenal List(BCS List) programmatically

I have created a external content type (BCS list) in SharePoint. I am using the below code in order to get items from bcs list. SPQuery query = new SPQuery(); query.Query = ...
1
vote
1answer
217 views

Copy data from external List Item to New Form

I have an external list that I want to add action to copy list item to NewForm. or any othwer way to take data from external list item to a new form. From display form, edit form any way will be ...
1
vote
0answers
88 views

External lists: Field GUIDs always empty?

I want to turn an external list into a DataTable using the ID/GUID values of external list's Fields as the DataTable column names; however, I've noticed for the external list I'm using, all of the ...
1
vote
2answers
255 views

SharePoint 2010 - To use content database or not to use

SP newbie here. I need to build a SharePoint 2010 application to track customer support cases. This will be the first time we've used SP, and I can set it up how I please. The built-in template for ...
0
votes
1answer
768 views

External Content Type not found in Business Data List picker

I have just created several ECTs along with lists to go with them and they work fine. Just my luck im on the final one and im stuck. Here's what I've done... 1. Created ECT and List 2. Given the ...
0
votes
3answers
262 views

Caching expensive query to use in a Web Part

I have a Web Part that connects to a SQL server and pulls summary data for the current user. (Think "dashboard".) Unfortunately this query is expensive to run so I'd like to cache the results to ...
2
votes
0answers
228 views

How to set selected value of external item picker

I have developed a custom edit form with an external item picker as application page in visual studio. The picker is populated with data using the following method. private ItemPickerExtendedData ...
0
votes
2answers
127 views

Filters get removed from external list when document is deleted from XsltListViewWebPart on same webpage

I have a webpage on Sharepoint 2010 that has: 1) An external list 2) A webpart that has XsltListViewWebPart referring to a document library When a filter is applied to External list, it filters out ...
1
vote
0answers
74 views

Bulk-Edit in external lists (Sharepoint 2010)

I try to provide bulk editing for external lists. I heard that the datasheet view is a convenient tool, but it is not enabled for external lists. Is there any way to get an easy, user-friendly bulk ...
1
vote
0answers
61 views

How do I change SQL connection from one server to another on an an External list

I have an external list that points to SQL Server A. Server A is being de-commission and the database is moving to SQL Server B. I need to change my connection for my lists. I created a new ...
1
vote
1answer
634 views

Querying an External Content Type without creating an External List

The typical scenario, on which every tutorial and walkthrough seems to advise, is to create an External Content Type with ReadList, ReadItem, Create, Update methods and then create an External List to ...
1
vote
1answer
406 views

Hide some fields from EditForm

I have some troubles with EditForm in Sharepoint. In SPD 2010 i have created External Type and defined CRUD method for him. I want to show in Disp form all item fields, but in Create and Edit form ...
1
vote
0answers
154 views

user lookup field for external lists

Guys please don't beat me too much, I want to add user lookup field into my external content type to use sharepoint people picker in my external list, the price doesn't stand up. So is it ever ...
1
vote
1answer
1k views

Event fire and Workflow Attach to External List?

What is the best way approach to attach workflow and Event Receiver on External List? How to store Directly External Data to SharePoint Custom List?List
1
vote
1answer
135 views

Associated ECT only displays ID (not title) in external list

I have created two ECTs, let's call them country and city for clarity. I have also created an association with city as the child and country as the parent. When I create an external list for city, ...
1
vote
1answer
272 views

Customizing external list form

I need to create external list and i need customize display and edit forms. I want add something like tabs, i.e. i want to input some fields in one tabs, and some in another. I must use ClientObject ...
1
vote
0answers
150 views

SPFieldUrl does not work

I have an external list, items in that list have a field that contains an url. I want to show this url as a link in sharepoint form. I found this example and defined in my Creator and Updater methods ...
1
vote
1answer
460 views

Custom form template with external list does not work

I have following .ascx file <%@ Assembly Name="Microsoft.Web.CommandUI, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %> <%@ Register TagPrefix="SharePoint" ...
0
votes
1answer
49 views

need support/materials for developing external lists with visual studio 2010

Up to now, I have mostly used Sharepoint designer to develop external content types and lists. Due to the lack of source control and for other reasons, we would like to move the development process ...
2
votes
2answers
870 views

Custom forms for external lists guidance

I need guidance/suggestions developing an app which will be hosted in SharePoint using external content types. So far I have a BDC model which works fine for reading the data und displaying it in an ...
0
votes
2answers
112 views

How do I retrieve associations items for list field using JavaScript

I have any ExternalContentTypes(ECT) with associations between them. One ECT is shown in an external list. I want to add a custom button on that external list ribbon. And it must change value ...
1
vote
0answers
43 views

How add personal list for all users

I want to integrate Sharepoint with my external system. Sharepoint should load tasks from my system and show them in the list on user personal page. Integration should be done using Sharepoint ...