Link to home
Create AccountLog in
Avatar of sharepoint2013
sharepoint2013

asked on

SharePoint 2007 Query textbox

Hi,

I would like to to put a textbox in my Allitems.aspx of a SP2007 list, which has 10000 over items.

to filter for specific IDs.

How can this be done?

Thanks.
Avatar of vaderj
vaderj
Flag of United States of America image

It sounds like in this case you are wanting to use a screwdriver as a hammer - unfortunatly SharePoint has a limit on all lists to about 5,000 - any more than that and you start seeing unusual behavior and degraded performance.
A list that has 10,000+ items would probably be considered a database - have you considered putting this into its own database?
If you put the contents of this list in a SQL database, even on the same SQL server, you could then setup a BDC connection to the database and use SharePoint to query the database, or even use SSRS for reporting.  
If you upgraded to SharePoint 2010 Enterprise, you then have PerformancePoint and other Business Inelegance tools available including dashboard builder to push your capabilities even further.
As such a huge SharePoint list however, as you can probably guess by the lack of responce to your question, your options are extremely limited
Avatar of sharepoint2013
sharepoint2013

ASKER

Ok, say it has 1000 record items only.

How do I filter for specific IDs?
ASKER CERTIFIED SOLUTION
Avatar of Rainer Jeschor
Rainer Jeschor
Flag of Germany image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account