.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Filter External List by a range of data

Posted By:      Posted Date: September 17, 2010    Points: 0   Category :SharePoint
I have an external list web part that I am currently using a choice filter on to filter by a certain status.  The options are yes, no, or (empty).  However, I would like to be able to add an additional option to filter where the person has the previous status set to no, but has a value in a different field greater than 90. I realize that the choice filter probably wouldn't do this, and that I could do this easily with separate list views, where I have some sort of web part that can change the list views on the fly. I would think I could use one of those list filters to do this, but when I tried to do that for my original problem, I was unable to connect the filter to my external list. I could connect the list view filter to any internal list without an issue however.  Somebody commented on my old thread that I posted as cptInsane0 that I could just make an infopath view form that has buttons that do this.  I have dabbled with infopath a little bit, but I wasn't able to get infopath to connect to my external list either.  I first had to connect to an internal one, and then for some reason I could add the external list as an alternate data source. I can't be the first person who has had this issue. Could someone point me in the right direction?

View Complete Post

More Related Resource Links

How to add "date Range" filter in a list of External Content Type



  Does anybody can help to let me know how to add a filter in a list that is external content type ? I created a list has readlist & ReadItem in SPD, but I want this list get data by date range like last 2 weeks. how to set this on filter ?


James Liang

Connecting a Sharepoint Custom list with an external Data-source

Hi I am planning to connect a Sharepoint Custom list with an external Data-source. External DB will be in Access 2007 format. More Information: I need a solution that we can connect our sharepoint list (one-way) to online db in a way that new  information is directly updated in the sharepoint list, whilst other info changed in sharepoint list  is not synced back to original value. Is there a way to solve this? -saumil

Create drop-down filter for External List

I hope this is an easy question. I will have an external list of a bunch of people.  There are several ways I want to display this data: All of them, Only the ones that have a value of 1-4 in the status field, Only the ones that have any other value in the status field, and people that have a value of 1-4 in the status field, but are at a certain location. I want to be able to put a drop-down filter above the list where people can select that. Could someone please point me in the right direction? Time is of the essence.  

Cannot delete external data list column due "Parameter name: combinedEncoded" error

Hello!   I migrated a Sharepoint 2007 to a Sharepoint 2010 by dbattach method. And now I want to delete the BDC list columns, but I'm getting this exception: System.ArgumentException:   Parameter name: combinedEncoded    at Microsoft.SharePoint.BdcClientUtil.SplitStrings(String combinedEncoded) What should I do to delete properly this columns?   Many thanks!

Excel External Table Data can only create new SharePoint List when Exporting from Excel?

I have a SQL Query that I refresh everyday in Excel. I want to be able to export this list over to a SharePoint list right after my refresh in Excel but I can only Export to a SharePoint list only once. If I try to export again to the same list then it will give me the error "The specified list name is already in use on this server. You must rename the list before publishing it to the server." I have web parts that have connections to this list and I do not want to export my Query to a new SharePoint list everyday. Does anyone know a way around this issue?

BDC, external list with many-to-many Association, how to input data

Hi, I have built a BDC with VS2010 and Sharepoint Enterprise as target platform. It is basically a technical evaluation about many-to-many Associations in external content types. Its has 2 entities which are Person and Ticket and should reflect a data model where persons can work on multiple tickets and tickets can also involve multiple persons. For linking those 2 entities I have a link table which can be read via the "Navigators" and be modified via the "Associator/Disassociator". I made the model completely with the VS2010 bdcm designer and as far as I know its good. (Its a "foreign key less" association, the identifiers are UInt32.) Now my question is how do I actually use those manipulators, or at least show data and related data. With 1-to-n relations Sharepoint did render an interface for handling the relation for me, but with a keyless n-to-m relation I dont get any interface for connecting the entities at all. Then I tried to make this via Infopath, but as far as I can tell, you cant use a 2nd datasource there with external List. (And it seems to be supposed to be this way.)

Calendar View for External Data List in SharePoint 2010?


I'd like to create a calendar view from data contained in an External List.  My external content type has a Start Date, End Date, and other calendar fields.  Is this possible using the out of the box BCS?

For extra credit - I'd like to then use this calendar as an overlay on other calendars within my SharePoint 2010 application.

Thanks for your help!

Unable to Display data of External List


hi everyone, I encounter a problem when I display the data from external list. The error message is :

"Unable to display this Web Part. To troubleshoot the problem, open this Web page in a Microsoft SharePoint Foundation-compatible HTML editor such as Microsoft SharePoint Designer. If the problem persists, contact your Web server administrator.


Correlation ID:9884b26f-6a23-4638-a82b-836d5ed8fed0"


Any solution, please?

Item Event Receivers or way to validate data entered for External List in SharePoint 2010?

Hi everyone,

Are there Item Event Receivers for External List in SharePoint 2010? If not, is there a way to validate the item data entered from External List UI in SharePoint site?


Dynamic Data Foreign Key Filter - how to limit the # of dropdowns on the list view



I have a visual basic website in VS 2010 framework 4, linx to SQL, with scafolding.... and this dataclass has about 10 foreign key fields, of which all 10 are shown in the list view of the website.  I want the ability to exclude those filters from the list view (or exclude some and keep some), but without eliminating them from the edit forms.  Using <scafoldingcolumn("False")> does the trick to remove them entirely but that will also remove them from the grid/list itself, which I don't want, and remove the column from the edit record views, which I don't want either.

Any help would be great!!!!

External List Error - Access denied by Business Data Connectivity


Hello Community,

Background: In SPS 2010 I created an External Content Type that is displaying the Customers table from a Customers database in SQL Server 2008. (I also added myself as the DBO for that database.) I configured the ECT to authenticate with the User's Identity and to also use the Secondary Secure Store Application ID "contoso\administrators". I then added both these accounts to the Business Data Connectivity Service and granted them all four permission sets. I configured the ECT Operations to perform all operations, and I filtered the return by limiting it to a 100 items.  Using the Create List and Form wizard I then created an External List from the ECT. 

Problem: When I display the External List in the browser I get this error - Access denied by Business Data Connectivity.

I have read several blogs about this issue (which seems to be common) but I still can't resolve it.  Can anyone help?



Tom Molskow - SharePoint Architect -

how to add report parameters to filter list data in a ssrs report for a SharePoint List



i am using SQl Server 2005 reporting services to generate reports from MOSS 2007 Lists.

I need to define a parameter in the report to filter the data repective to that parameter dynamically.

like: in moss list there are three fileds A, B and C and i want to define field A as the report parameter, whenever i select the value of field A then on "View report" value of field B and C pertaining to field A should be display in report.

I am able to add report parameters but not able to attach to the report so that filtering can work.

Please guide me with solution

Column filter in Business Data List web part does not work for all fields


I have a BDC entity whose fields contain a variety of data – numbers, dates and strings.  When I use the business data list web part I find that some of the columns’ dynamic filtering (accessed from the list’s column header) doesn’t work.  For these problem fields, the filter values load correctly but when I select a value all records disappear.  Initially I thought this was limited to just string columns but there is one string column that does filter correctly.

Here are some things that may be useful to know:

1.       The datasource is a SQL view and all fields are varchar(255)


How to automatically resolve external business data in a MOSS 2007 document list


Here's what I have so far...

1.      I have a document list in MOSS 2007.

2.     Each document in the list may be sent to an external system for further processing.  This was done by adding a custom feature to the document libraries actions menu in SharePoint.

3.     The external system uses it's own SQL Server database.  A table in this database references the SharePoint document’s GUID.  Additional columns in the table are updated during external processing data such as status.

The problem I'm trying to solve is this:

1. I would like the see the external processing status for a document in the original SharePoint document list.  This status will change and needs to be updated for each document automatically.

I tried setting up a business data column in the document list.  I created the XML definition of the external SQL Server table using the MOSS 2007 SDK and imported the definition.  I added the business data column to the list

How to pass current user to bdc list to filter data.

Hi all,

I have a bdc list which I want to load on the basis of the currently logged in user. I've tried to use the Current User Filter Web Part provided OOB but it doesn't seem to solve the problem cu'z I can't bind the current user value of the webpart to any column of the bdc list.

The problem is, I want to load the records based on the current user by passing the user name to Stored Procedure. Does any one know how to do that ???? Please F1.



problem...i want a list item to populate all data in gridview!!!


i have a dropdownbox and a gridview

what I want is to have a list item which populates all data in a gridview.

I have tried using list item selected value=0 but to no avail.

what is the easiest way to achieve this?

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend