Tag: columns

Document Library Not Filtering Columns

There is a document library which has over 5000 items, it has passed its item view threshold. The view was reduced to show items that met certain requirements. This view now shows less than 1000 records.

When some users use the the column name to filter they receive a message “Cannot show the value of the filter. The field may not be filterable, or the number of items returned exceeds the list view threshold enforced by the administrator.”

The threshold item view limit is in the Central Administration but this is not something that we want to change because of performance reasons, so this would be a last option for this. Some of the columns the view is filtered by are indexed, as this was a suggestion.

The way I see it is that it should be working properly. The view is within the threshold limit so it should not have an issue. All users were able to use it properly before it reached 5000 items. This error shows for some users but not all.

Is there something else that should be done to allow all users to have access to filter the view by using the column name?

UPDATE: The list view currently has 3 filters on one column. The column is a choice and is indexed.

The filters are as follows:

column1(Indexed) is equal to value1

Or

column1(Indexed) is equal to value2

Or

column1(Indexed) is equal to value3

When I remove one of the filters it works fine, it does not matter which of the filters I remove. Filter_1 return 2880 items, Filter_2 return 17 items, and Filter_3 returns 97 items. For a total of 2994 items returned.

Would there be a restriction on having multiple “Or” filter statements on the column?

Spservices autocomplete with many columns

Could somebody advise how can I make autocomplete for multiple columns, currently I’m using it for one column:

$  ().SPServices.SPAutocomplete({     sourceList: "My list",     sourceColumn: "Email",     columnName: "user1",     ignoreCase: true,     numChars: 3,     slideDownSpeed: 1000,     debug: true });

Can I do something like this:

... columnName: "user1", "user2", "user3"... etc. ...

UPDATE:

My form and JavaScript looks like this:

<div class="tr">   <div class="td">     <input title="user1" data-bind="textInput: user1Email, valueUpdate:'blur'" />   </div> </div> <div class="tr">   <div class="td">     <input title="user2" data-bind="textInput: user2Email, valueUpdate:'blur'" />   </div> </div>  <script type="text/javascript"> $  (document).ready(function () {     $  (["user1", "user2", "user3"]).each(function () {         $  ().SPServices.SPAutocomplete({             sourceList: "User List",             sourceColumn: "Email",             columnName: this,             ignoreCase: true,             numChars: 3,             slideDownSpeed: 1000,             debug: true         });     }) }); </script>

validate Unique users in 2 columns sharepoint List

I have a list which stores information about new sharepoint site requests. Where i have 2 fields (people and Groups)

  • Primary Site Collection Admin
  • Secondary Site Collection admin

Both of this fields are pointing to SpSite owners Groups in the site. Now when users are filling up the NewForm.aspx i need to validate that they are unique users.

How do we do that? Code I am using is:

<script language="javascript" src="/sites/services/SiteAssets/scripts/jquery-1.11.1.min.js" type="text/javascript"></script><script type="text/javascript">  function PreSaveAction() { var PickerPerson1 = getPickerInputElement("Primary_x0020_Site_x0020_Adminis_41bc75f7-fb89-4d45-897a-372aee8074b6_$  ClientPeoplePicker");  alert(PickerPerson1);  }   function getPickerInputElement(identifier)     {          var tags = document.getElementsByTagName('DIV');          for (var i=0; i < tags.length; i++)        {               var tempString = tags[i].id;                   if ((tempString.indexOf('UserField_upLevelDiv') > 0))     {            if(identifier == tempString)        {         var innerSpans = tags[i].getElementsByTagName("SPAN");               for(var j=0; j < innerSpans.length; j++)            {               if(innerSpans[j].id == 'content')               {                  return innerSpans[j].innerHTML;                }            }           }             }          }          return null;       }  </script>

Look-up Columns redirecting to folders changed their behaviour

I am using SharePoint Online site.

Some months ago I created a lookup column in document library [A] that referred to another document library [B]. This was the best option I found to be able to refer attachments to each documents in [A], using in [B] a field that is filled only for folders and not for documents.

It was working fine, when clicking on the look-up field, it used to give the possibility of checking the documents directly in a pop-up window or to open the folder in another view.

Since a couple of months this doesn’t work anymore, now when clicking on the look-up field, it opens the “Properties of the folder” (that means just the name of it) and doesn’t show the content of the folder itself.

What’s changed? How can I solve this?

SharePoint threshold limit Not working for indexed Columns

I am Facing A issue with SharePoint Rest Query Requestype Column is indexed , single Line of text , Has Three types of only (Values and Count)

  • Credit- 3787
  • One Off – 13019
  • Reccuring – 6202

I am Trying to retrieve only Credit type but it is failing and giving threshold error. I need to retrieve all credit requests Query : https://yy.xx.com/sites/xxxxy/_api/web/lists/GetByTitle(‘XYZ’)/Items?$ select=ID&$ filter= ( RequestType eq ‘Credit’ )

Thanks For helping me solve the issue.

Need to find a way with SQL to query for a combined columns without having to use CONCAT

How can I run a query to lookup two columns that result with one of the two column having a duplicate.

Table A: Column 1 has values (a, b, c, d, e) Column 2 has values (xyz, 123, abc, 789)

Example of a data: Column 1 = a and column 2 = xyz column 1 = b and column 2 = xyz column 1 = c and column 2 = 123 column 1 = d and column 2 = 789 column 1 = e and column 2 = xyz

Result: show me query that has column 1 with ‘a’ or ‘b’ and column 2 as ‘xyz’ without having to concatenate the two column.

show me below only (another word show me result of column 2 that is not duplicate based on the lookup of column 1 and 2): Column 1 = a and column 2 = xyz column 1 = b and column 2 = xyz

Too many lookup columns error – stable list with no new lookups being created or used

Users & ‘Full Control’ site collection admin are unable to EDIT items.

Error message reads:

The query cannot be completed because the number of lookup columns it contains exceeds the lookup column threshold enforced by the administrator

I understand how this issue is normally triggered – if more than 8 lookup columns (I’ve also read of a max of 12) are used, it creates an error. I’m using SP2013.

However, in my scenario, the list in question is long-established and is stable (in terms of development – no new lookup columns are in use). Hence, I’m somewhat puzzled as to what has triggered this error.

I’m using content types, one of these only has 6 lookups in it, I tried to edit one of these but I get the same error.

I did have some Windows Updates install yesterday, I’ve no idea if that would be the cause. Windows Updates are regular, so normally I’d exclude it as being the cause of anything, but given the otherwise stable nature of the list, I’ve been trying to think up other possible causes.

Product content type pic:

8 lookups/’person or group’ columns

enter image description here

Other EXP content type pic:

Only 6 lookups/’person or group’ columns

enter image description here

23/09/2019 – additional info

  • a different farm administrator to me could still edit items, while I could not (despite us having identical permissions). Suggesting he does not have the latest Windows Updates installed yet(?)

  • Following Peter’s recent comment regarding workarounds. In my ‘OTHER EXP’ content type, which has 6 ‘Lookup’ or ‘Person or Group’ fields, I went in CT settings and hid a lookup field, so only 5 of these field types remain in the edit form; the edit form worked correctly. However, for the 8 field Product content type, this workaround did not help

  • On the server, in Sharepoint Central Administration, I observed that the default number of lookup fields is set to 8. Therefore this setting is somehow being overriden, since the List will not display the edit item form.

  • Not all lists are affected; in a different site collection a list with 7 lookups is still functioning normally.

24/09/2019 – in response to Slaven’s comment about database version:

Database version is 15.0.5023.1000:

Sharepoint Farm - 2013, database version 15.0.5023.1000

Further testing

Saved the list as a template with contents, with the intention of trying to recreate it. When I tried to create a new list (including contents) based on this template, I got this (Windows?) error.

Error message - Windows

This website lists lots of error codes for Microsoft tech, wow what a find, specifically it included my error message too. I’m using Windows 7, my colleagues are using newer versions of Windows.

Newer version of Windows required?