Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [indexed-column]

An index on a column enables Windows SharePoint to quickly analyze the data in that column, even when working with thousands or millions of items.

0
votes
0answers
33 views

Column Indexes not working as expected - SharePoint 2013

I've got a list with ~10k items in it; I've indexed this on a number of columns and have recently started to see 500 errors when querying the list via REST ($.ajax) despite the queries previously ...
0
votes
0answers
42 views

get the list of indexed columns via power-shell , and “indexed” is blank

I have followed as per this link : Powershell - How to get index columns for a given list $web = Get-SPWeb -Identity http://aissp2013/sites/team $list = $web.Lists["Employees"] foreach ($field in $...
0
votes
0answers
34 views

Adding an Index column on my list for the “Modified” column, did not allow me to show more than 5,000 items on the list view

I am working on a SharePoint 2013 on-premises farm, and i have a document library which have 5651 documents, and i got this message that the library exceeds the threshold:- and when non-admin users ...
1
vote
1answer
59 views

Indexing SharePoint 2013 List Columns

I have sharepoint list which has more than 40,000 item. Now the performance was very slow, So I planned to try Indexing to improve performances. When I try to add the Indexing it's returning the ...
0
votes
0answers
34 views

Logical grouping and indenting of columns in a SP list view

I have about 100 columns in my list each containing certain info about applications. Although I have arranged them logically the way I want them, is there a way I could group them based on certain ...
2
votes
3answers
655 views

Calendar View Always shows List threshold exceeded error

I am using Sharepoint 356 (office 365). I recently migrated my site from sharepoint 2007 to 365. I used to have a calendar on my homepage that had 5800 items. Office 365 view limit is 5000. So the ...
1
vote
0answers
161 views

Avoid threshold limit with view using “Or condition” on person columns

Here is my issue: I have a sharepoint 2013 list with more than 5 000 items inside. In order to avoid threshold limit I indexed several columns and created views using these columns. Most of the views ...
0
votes
1answer
121 views

Indexing “Task Outcome” Column - possible?

We've just had a Workflow History list hit 5000 items - yay people are using sharepoint! A naive "Open Items" view filters on "Task Status" <> "Completed" and can be made to work with an index, ...
0
votes
1answer
53 views

Does index column help as refiners in sharepoint 2013

I have a document library in SharePoint 2013 on premise. I have added a 'Document Type' site column of Choice type in the document library. Now I will add 'Document Type' as refiners in the search ...
1
vote
0answers
107 views

CrossListQueryCache - get 10 items on indexed column

I have a question, basically I build a query and use the CrossListQueryCache to retrieve all the required items. Now all was good and well but there is a problem: lists are big some of them more than ...
6
votes
1answer
219 views

List View Threshold: What limitations can we expect even after the “correct” columns are indexed (manually or automatically)?

The infamous 5000 Threshold view limit [1, 2, 3] is a well-known struggle. One often suggested solution is to "plan ahead", and let's imagine we have done this and indexed our most important ...
1
vote
1answer
73 views

Do Views affect performance?

Whenever it comes to Views in SharePoint (2013 or above), the documentation offers it as a way to get around limitations (usually 5000 elements). I currently use CSOM to retrieve data from ...
0
votes
1answer
144 views

Performance impacts while Indexing a SharePoint list in production environment

Indexing a column in a SharePoint list that's approaching the 5000 items threshold limit. Are there any expected impacts for users/apps consuming/writing to that list during index creation? Should I ...
0
votes
2answers
95 views

Add Content to Search Index Based on Calculation of Properties in Record Center

I have a requirement to be able to search a record(document) in the record center based on a calculation. I can not store the calculated value as part of the item properties because an update of the ...
1
vote
1answer
449 views

Iterating SPList.GetItems(SPQuery) very slow and times out

I have a SharePoint 2013 Custom List. It has 3 MMS columns, 3 User Columns and 3 or 4 DateTime columns and a Choice Column and 1 or 2 columns of type Text. This list currently has around 2000 items. I ...
5
votes
1answer
11k views

Difference between Index column and simple column in SharePoint?

Difference between Index column and simple column in SharePoint? What is the need of creating index column ?
2
votes
2answers
5k views

REST query not working on list after 5k threshold

The following query works on one site: mysite/_api/lists/getbytitle('Listname')/items?$top=5001&$filter=IndexedCol1 le 'M' and Author/Title eq 'John Doe'&$expand=Author/Title&$select=...
1
vote
1answer
563 views

Indexing a column in all content types that use it

I'm wondering if it's possible to add an Index to a column in every Item of a specific Content Type. I'm still having issues with the List View Threshold in an Intranet Site Collection so that CQWP's ...
3
votes
1answer
2k views

Powershell - How to get index columns for a given list

For some strange reasons I can't get to the Index page. It gives me following error. Is there a way to get the index columns via powershell? http://local.intranet.net/sales/_layouts/IndexedColumns....
5
votes
1answer
7k views

Find an item, search multiline text

I have a SharePoint list that contains multiple fields. One of which is a multiline "Notes" field that is not included with the default view. When I perform a search on the list, I can search on any ...
0
votes
1answer
505 views

Search ignoring all numeric search

We are running SharePoint 2013 and are trying to use the people search to find employees by their employee ID number. The column has been indexed in SharePoint and if we search using the syntax ...
0
votes
1answer
287 views

Ordering Indexed Column on SharePoint lists

I have a SharePoint lists with 10 000 items, and someone else has increased the limit to 250 000 (Crazy right?). What I have done is I've indexed the Changed By Date, and made views that is sorting ...
1
vote
1answer
2k views

How create an index based on an internal list field?

I have a huge library and its documents don't have any metadata. They have only the name (FileLeafRef) filled (and FileRef -> file's path automatically filled). I'm trying to update their metadata (...
0
votes
2answers
2k views

How to filter a people/user column that has been indexed

I have a long list (more than 5,000 items) and due to view threshold I indexed some columns. One of them is a people/user column. When I want to create a view that filters on the User column, then it ...
5
votes
2answers
9k views

Should i index all columns in a list?

I have a screen where the user will be querying using all columns in the list. Should i index every column. What are the rules around this? Would there be any performance problems?
1
vote
1answer
4k views

Column being indexed - cannot create site from custom template

I created several content types in the content type hub. Next, I have created a site out of the default team site with several document libraries and lists on my site which utilize these content types ...
2
votes
1answer
4k views

Indexing sharepoint lists with ps

I would like to index a column in a list with powershell. I have a problem, when i retrieve the list how can i set what field should be put to index? Is there a special command, can anyone provide me ...
1
vote
2answers
232 views

Is it possible to update the searchindex for only one item?

Is it possible to update the searchindex for only on specific item. I'm search some tasklists through keywordsearch and showing them in a webpart. Then I have a custom action which changes the status ...
12
votes
6answers
22k views

SharePoint 2010 Column Index on Large List

I have a custom list with more than 5000 items. This article: http://msdn.microsoft.com/en-us/library/ff798465.aspx (the last section, "How Does Indexing Affect Throttling?") states: "For ...
10
votes
4answers
6k views

SharePoint 2010 CAML Query fails when indexed columns used

I have an SPQuery that has been working fine until my list hit 500 items: q.Query = "<Where><Eq><FieldRef Name='DefectID' /><Value Type='Counter'>" + DefectID + "</Value>...
2
votes
1answer
1k views

When will an index be created for a column?

I have a SharePoint 2007 List and it has almost 10 columns and 1000+ items, I want to enable the Index for a specific column is in the list. If I enable the index now then when it will create an index ...