Tagged Questions

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
2answers
138 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
130 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
0answers
34 views

Access External List Items in Sharepoint Online

I have created an external content type for SharePoint Online using share point designer. Now I need to create a web part that will fetch the data from the External List and filter it and show them ...
0
votes
0answers
111 views

Use Custom rendering Template with External List

Does anyone Know if its poossible to use a custom RenderingTemplate with an External List? In my Schema.XML I have <Forms> <Form Type="DisplayForm" Url="DispForm.aspx" ...
0
votes
1answer
111 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
262 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
81 views

External List - Search (filter) on some of the columns

I have an external List. (using Sharepoint 2013 Foundation) I want to be able to search on some of the columns. (say, when you click on a column header, have a textbox to search/filter on that ...
0
votes
0answers
563 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
80 views

BCS: external data from SQL Server - Image column not showing

I created an external content type based on a view in the external SQL Server database with SharePoint Designer. So far it worked fine, but when I create a list of this ECT there are two columns ...
0
votes
0answers
43 views

Association between external lists. Get selected item

I have two external list ("Projects" and "Development process"). I connected this lists by associated key "project". When i create item in "Development process" i choose project in external list ...
0
votes
0answers
86 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
437 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
246 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
120 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
174 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
205 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
146 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
149 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
438 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
102 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
882 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
122 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
162 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
205 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
86 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
246 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
705 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
250 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
223 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
119 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
73 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
59 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
598 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
381 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
149 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
127 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
263 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
148 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
419 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
774 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
107 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
42 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 ...
0
votes
2answers
443 views

How i can get “item ID” column through “BDC Identity” column

I create external list for display external items from my wcf service and add custom action on that list EditForm through ClientObjectModel with this url: ...
1
vote
0answers
92 views

Run custom javascript when external list table loaded

Is there any way to run custom javascript after table with external custom list is loaded on page? The external list table is loaded on page with some delay and I would like to modify its content ...
0
votes
2answers
214 views

update external list data using infopath codebehind

I know that I can update my ECT record (using InfoPath forms I created for the external lists), by passing the BdcIdentity (ID) to the form and it will find that record and enable me to edit. How do ...