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.
44
questions
0
votes
1
answer
14
views
Can we search large lists using calculated columns, even that we cannot add calculated columns as index inside lists?
Inside SharePoint online we cannot index calculated columns at the list level, so we cannot filter large lists based on the calculated columns inside list views. but what about Search? can we search ...
0
votes
0
answers
15
views
MS Graph (or SP) not recognizing index on a list
I have a basic list (empty atm - not sure if that's relevant). There are a couple of Lookups, Text, currency and number columns.
For the purpose of this question the Lookup column in question is named ...
- 101
0
votes
0
answers
21
views
do we need to add SharePoint indexes if we only want to filter SharePoint items through a power apps gallery?
I have a SharePoint test list named Test, and it contain 10,000 items and I did not add any index to the SharePoint list. Now when I write this formula, I were able to filter:-
Filter(Test,Num=Value(...
0
votes
0
answers
23
views
In SharePoint Online can I still index columns in a library after reaching the 5000 limit?
I know you could previously extend the threshold view in SharePoint On-Premise. In SharePoint Online can I still index columns in a library after reaching the 5000 list view limit? I'm assuming there'...
- 365
0
votes
1
answer
98
views
I am able to filter list views using none-indexed column even if the result will be more than 5000 items
We have a term set named Customer and we have a managed metadata site column named "mmcustomer" which allow multiple selection linked to the customer term set:-
and inside our document ...
0
votes
1
answer
207
views
Create an index that restarts in the beginning of each year
I have never worked with power automate or sharepoint lists in the past. We have a test request system that has a unique identifier of the following format: "PTL"-YEAR-Index. PTL is a ...
1
vote
1
answer
118
views
Access files via autogenerated ID through REST API
what I'm currently doing is accessing the files in my Document Library through the REST API like this:
[baseURL]/_api/Web/GetFileByServerRelativeUrl('[relativeURL]'). To collect these relativeURLs, I ...
- 13
0
votes
2
answers
503
views
Ability to filter and sort large SharePoint list using UN-indexed fields
I have a SharePoint online site collection, which contain a custom list, which contain around 51,000 items, as follow:-
and currently the list contain these 3 indexes :-
When i access the main list ...
1
vote
1
answer
356
views
Filtering Sharepoint Server 2013 list with multiple "OR" column view filters above the 5000 item threshold
I have a list that's butting up against the 5000 item threshold and I've added a couple of dummy items so I can experiment with the threshold before I cross over with real data. My list is structured ...
- 11
0
votes
2
answers
65
views
If I disable the list items to display in search results, will it have any impact on indexing?
I am having a SharePoint list with 30 columns. I have added few columns to the "Indexed Columns". But I don't want to display any list item in the search results. So I want to disable following option....
- 1,546
1
vote
1
answer
219
views
SharePoint 5000 item limit threshold in sharepoint 2016
I know the issue is quite old and solved too many times, but for my case the solution should be faster and sophisticate as much as I can.
The case is, my sites are migrated from SharePoint 2013 to ...
- 2,193
1
vote
0
answers
307
views
Filtered, large list exporting
I'm currently managing a large list (just over 5000 items) and have a filtered view using indexed columns that is returning 143 items. I want to export those 143 to Excel. I'm getting an error ...
- 31
2
votes
1
answer
90
views
Sharepoint large list filtering
Currently in Sharepiont 2010.
I have a list that just went over 5000 items. I have columns indexed and all views are filtered with these indexed columns. One of the columns is a "Date and Time" type ...
- 31
1
vote
1
answer
19
views
Items that SHOULD be showing in a view, aren't
So, I have a large list, with ~10,000 items.
I have created several views that filter via indexed columns that show below the threshold amount.
But I just modified one of the views, (changed the ...
- 71
0
votes
1
answer
799
views
Approaches we can have to allow indexing managed metadata columns which allow multiple values
I have the following scenario inside our sharepoint online and sharepoint on-premises 2013:-
1) We have an enterprise wiki site collection inside our sharepoint on-premises 2013. the enterprise wiki ...
0
votes
1
answer
389
views
Why we have different indexes options inside 2 document libraries on our sharepoint online
I am facing this weird issue inside our sharepoint online tenant:-
I have a classic team site collection, which contain 2 docuemnt libraries inside 2 separate sub-sites.
the document libraries are ...
0
votes
0
answers
558
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
1
answer
143
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 ...
2
votes
3
answers
3k
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 ...
- 81
1
vote
0
answers
513
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 ...
- 11
0
votes
1
answer
200
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, ...
- 167
0
votes
1
answer
60
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
0
answers
185
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 ...
- 2,105
8
votes
1
answer
407
views
List View Threshold (5000 items): What limitations for 5k-issue 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 ...
- 7,415
1
vote
1
answer
212
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 ...
- 774
0
votes
1
answer
505
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 ...
- 314
0
votes
2
answers
141
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 ...
- 58
1
vote
1
answer
848
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 ...
- 1,147
6
votes
1
answer
28k
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 ?
- 393
2
votes
2
answers
6k
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=...
- 769
1
vote
1
answer
842
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 ...
- 33
3
votes
1
answer
3k
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....
- 31
7
votes
1
answer
12k
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 ...
- 173
1
vote
1
answer
568
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 ...
- 347
0
votes
1
answer
423
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 ...
- 693
1
vote
1
answer
3k
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 (...
- 163
0
votes
2
answers
4k
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 ...
- 1,189
5
votes
3
answers
11k
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?
- 783
1
vote
1
answer
6k
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 ...
- 1,410
3
votes
1
answer
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 ...
- 2,105
1
vote
2
answers
236
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 ...
11
votes
6
answers
24k
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 ...
- 391
10
votes
4
answers
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>...
- 146
2
votes
1
answer
2k
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 ...
- 2,548