Solved

Large list limit on connected web parts

Posted on 2013-01-29
6
882 Views
Last Modified: 2013-06-26
I have a page on SharePoint 2010 with connected web parts. Web part A filters content in a web part B based on column X. Today somebody added an item number 5001 in the list displayed in web part B and the following (obvious) message is now displayed:

This view cannot be displayed because it exceeds the list view threshold (5000 items) enforced by the administrator.

To view items, try selecting another view or creating a new view. If you do not have sufficient permissions to create views for this list, ask your administrator to modify the view so that it conforms to the list view threshold.

Learn about creating views for large lists.

Column X is indexed and I was hoping that after selecting an item in web part A filtered items in web part B will be displayed. Unfortunately I still have that error.

What are my options here to make this work? My requirement is to display all related items in a web part B once an item in A is selected (it is usually less than 100).
0
Comment
Question by:MisUszatek
  • 3
  • 2
6 Comments
 
LVL 9

Assisted Solution

by:Mohit Nair
Mohit Nair earned 188 total points
ID: 38832572
I think you have reached the threshold limit. By default it is 5000.
You can increase it this way

The setting for the list throttle
•Open the SharePoint Central Administration,
•go to Application Management --> Manage Web Applications
 •Click to select the web application that hosts your list (eg. SharePoint - 80)
 •At the Ribbon, select the General Settings and select Resource Throttling
 •Then, you can see the 5000 List View Threshold limit and you can edit the value you want.
 •Click OK to save it.
0
 

Author Comment

by:MisUszatek
ID: 38832580
Forgot to mention that I don't want to increase the threshold limit... I am more looking for some kind of indexing/filtering solution.
0
 
LVL 9

Expert Comment

by:Mohit Nair
ID: 38832618
Check this link
http://office.microsoft.com/en-us/sharepoint-foundation-help/manage-lists-and-libraries-with-many-items-HA010377496.aspx
and go to the section How to index and filter views
You would find the steps on how you want to filter the content.
0
Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

 

Author Comment

by:MisUszatek
ID: 38832626
Are you pointing me to something specific to my scenario?
0
 
LVL 44

Accepted Solution

by:
Rainer Jeschor earned 187 total points
ID: 38832674
Hi,
perhaps you can set a default value in the filter, so that the initial load of the list web part does not reach the limit.
HTH
Rainer
0
 

Author Comment

by:MisUszatek
ID: 38832743
Yes - but how? I need all items displayed once the parent item is selected...
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

The Scenario: Let’s say you have a quote worksheet in Excel that you use to work up sales figures and such for your clients. You utilize SharePoint to manage and keep track of these documents. You would like values from your worksheet to populate Sh…
For SharePoint sites, particularly public-facing ones, there are times when adding JavaScript, Meta Tags, CSS Styles or other content to the page <head> section is more practical than modifying master pages.  For instance, you could add the jQuery l…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now