none
SharePoint view not showing documents RRS feed

  • Question

  • Hi all, 

    We have a SharePoint 2013 page which has a custom view with names sorted in alphabetical order. 

    Since last week we added more documents to the library and now the view is empty with an error message of over 5000 item limitation. The custom view is not typical of other lists/libraries where you would modify the view quickly and add a filter. I am sure i need to "Edit Page" and make changes to the webpart but does anyone have any further steps that i could use to have the A-Z listing populated? 

    Friday, July 19, 2019 4:53 PM

All replies

  • You could increase the List view Threshold from Central Admin, but that's not the preferred to increase LVT to more than 5000 because it cause performance issues down the road.

    Thanks & Regards,


    sharath aluri

    Friday, July 19, 2019 4:59 PM
  • Thanks Sharath. We are dealing with a lot more than 5000 items. It might get close to 20k items eventually. So will have to find another way to have this issue resolved. 
    Friday, July 19, 2019 7:47 PM
  • Thanks Lakshman. I dont have admin privileges to change the LVT to more than 5000 but our SP admin can. 

    Like the resource point out - it can cause performance issues if we leave it to more than 5000 but i will get back to you all after making the LVT changes and adding index columns to see if that solves the issue. 

    Friday, July 19, 2019 7:52 PM
  • Adding Indexed columns is the Microsoft preferred way if you have items more than 5000. The index columns won't cause performance issue as well because they stored in complete different table from back-end SQL.

    Thanks & Regards,


    sharath aluri

    Friday, July 19, 2019 8:10 PM
  • Hi,

    You have to increase threshold limit more than 5000 form  central admin

    hrottling setting on the web application in SharePoint Central Administration:

     

    resource-throttlingsettings-listitems-new

    The setting above is for non-admins

    resource-throttlingsettings-admins

    The setting above is for admins

    Please remember to click Mark as Answer on the answer if it helps you



    Nour

    Saturday, July 20, 2019 12:09 AM
  • Hi Sumanth,

    I’m checking how the things are going on about this issue. Whether the post helps you?

    Best regards,

    Grace Wang


    Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    SharePoint Server 2019 has been released, you can click here to download it.
    Click here to learn new features. Visit the dedicated forum to share, explore and talk to experts about SharePoint Server 2019.

    Monday, July 22, 2019 10:21 AM
  • Hi Grace - Since I dont have admin privileges to our SharePoint site, I am unable to change the LVT from central admin. I am waiting on the person to be able to do that with them. I will update the thread as soon as I am able to. 

    Thanks, 

    Sumanth

    Monday, July 22, 2019 1:51 PM
  • Thanks Nour. See my reply to Grace. I will be updating this thread once i am able to access central admin. 

    Monday, July 22, 2019 1:52 PM
  • Hi Sumanth,

    Looking forward your feedback.

    Best regards,

    Grace Wang


    Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    SharePoint Server 2019 has been released, you can click here to download it.
    Click here to learn new features. Visit the dedicated forum to share, explore and talk to experts about SharePoint Server 2019.

    Tuesday, July 23, 2019 9:30 AM
  • Hi Grace, 

    We decided to not implement the LVT throttling to increase the number to 20000 like others have mentioned in this thread as it might cause a SharePoint performance issue. We need a long term strategy. If things change and i need more help I will seek out for help here. 

    Thanks, 

    Sumanth

    Wednesday, July 24, 2019 9:42 PM
  • Hi Sumanth,

    Thanks for your feedback.

    Have a nice day!

    Best regards,

    Grace Wang


    Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    SharePoint Server 2019 has been released, you can click here to download it.
    Click here to learn new features. Visit the dedicated forum to share, explore and talk to experts about SharePoint Server 2019.

    Thursday, July 25, 2019 8:10 AM
  • All, 

    I am afraid i am going to have to drag this issue a bit longer.

    1) The issue is that we don't have a SP Developer and I was under the impression that you could access Central Administration through O365. It seems you need to install SP Admin tools to be able to access Central Administration, is that correct? I might not have access still but would like to know where to download from or the keywords to download? 

    2) The view in A-Z listing shown above is coming from a Site Page referenced to the Document Library. I am able to use Indexed columns created while setting up the Document Library and view the Items which are not associated with the Site Page View. Looks like its using HTML and I want to know how to possibly modify the code attached to use an indexed column which would work exactly like modifying a document library or a regular list view? 

    Again thanks for all your help!

    Sumanth

    <%@ Register TagPrefix="WpNs1" Namespace="Microsoft.SharePoint.Portal.WebControls" Assembly="Microsoft.Office.Server.FilterControls, Version=16.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c"%>
    <%@ Register TagPrefix="WpNs0" Namespace="Microsoft.Office.Server.Search.WebControls" Assembly="Microsoft.Office.Server.Search, Version=16.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c"%>
    <%@ Assembly Name="Microsoft.SharePoint, Version=16.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c"%> <%@ Page Language="C#" Inherits="Microsoft.SharePoint.WebPartPages.WikiEditPage" MasterPageFile="~masterurl/default.master"      MainContentID="PlaceHolderMain" meta:webpartpageexpansion="full" meta:progid="SharePoint.WebPartPage.Document" %>
    <%@ Import Namespace="Microsoft.SharePoint.WebPartPages" %> <%@ Register Tagprefix="SharePoint" Namespace="Microsoft.SharePoint.WebControls" Assembly="Microsoft.SharePoint, Version=16.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %> <%@ Register Tagprefix="Utilities" Namespace="Microsoft.SharePoint.Utilities" Assembly="Microsoft.SharePoint, Version=16.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %> <%@ Import Namespace="Microsoft.SharePoint" %> <%@ Assembly Name="Microsoft.Web.CommandUI, Version=16.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %>
    <%@ Register Tagprefix="WebPartPages" Namespace="Microsoft.SharePoint.WebPartPages" Assembly="Microsoft.SharePoint, Version=16.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %>
    <asp:Content ContentPlaceHolderId="PlaceHolderPageTitle" runat="server">
    	<SharePoint:ProjectProperty Property="Title" runat="server"/> - <SharePoint:ListItemProperty runat="server"/>
    </asp:Content>
    <asp:Content ContentPlaceHolderId="PlaceHolderPageImage" runat="server"><SharePoint:AlphaImage ID=onetidtpweb1 Src="/_layouts/15/images/wiki.png?rev=44" Width=145 Height=54 Alt="" Runat="server"/></asp:Content>
    <asp:Content ContentPlaceHolderId="PlaceHolderAdditionalPageHead" runat="server">
    	<meta name="CollaborationServer" content="SharePoint Team Web Site" />
    	<SharePoint:ScriptBlock runat="server">
    	var navBarHelpOverrideKey = "WSSEndUser";
    	</SharePoint:ScriptBlock>
    	<SharePoint:RssLink runat="server"/>
    	</asp:Content>
    <asp:Content ContentPlaceHolderId="PlaceHolderMiniConsole" runat="server">
    	<SharePoint:FormComponent TemplateName="WikiMiniConsole" ControlMode="Display" runat="server" id="WikiMiniConsole"/>
    </asp:Content>
    <asp:Content ContentPlaceHolderId="PlaceHolderLeftActions" runat="server">
    	<SharePoint:RecentChangesMenu runat="server" id="RecentChanges"/>
    </asp:Content>
    <asp:Content ContentPlaceHolderId="PlaceHolderMain" runat="server">
    	<span id="wikiPageNameDisplay" style="display: none;" runat="server">
    		<SharePoint:ListItemProperty runat="server"/>
    	</span>
    	<span style="display:none;" id="wikiPageNameEdit" runat="server">
    		<asp:TextBox id="wikiPageNameEditTextBox" runat="server"/>
    	</span>
    	<SharePoint:VersionedPlaceHolder UIVersion="4" runat="server">
    		<SharePoint:SPRibbonButton
    			id="btnWikiEdit"
    			RibbonCommand="Ribbon.WikiPageTab.EditAndCheckout.SaveEdit.Menu.SaveEdit.Edit"
    			runat="server"
    			Text="edit"/>
    		<SharePoint:SPRibbonButton
    			id="btnWikiSave"
    			RibbonCommand="Ribbon.WikiPageTab.EditAndCheckout.SaveEdit.Menu.SaveEdit.SaveAndStop"
    			runat="server"
    			Text="edit"/>
    		<SharePoint:SPRibbonButton
    			id="btnWikiRevert"
    			RibbonCommand="Ribbon.WikiPageTab.EditAndCheckout.SaveEdit.Menu.SaveEdit.Revert"
    			runat="server"
    			Text="Revert"/>
    	</SharePoint:VersionedPlaceHolder>
    	<SharePoint:EmbeddedFormField id="WikiField" FieldName="WikiField" ControlMode="Display" runat="server"><div class="ExternalClass12090DF9807A4E6BA07CE6648E3C0E53"><table id="layoutsTable" style="width&#58;100%;"><tbody><tr style="vertical-align&#58;top;"><td style="width&#58;100%;"><div class="ms-rte-layoutszone-outer" style="width&#58;100%;"><div class="ms-rte-layoutszone-inner"><spsswc:SearchBoxScriptWebPart runat="server" QueryGroupNamesJson="[&quot;Default&quot;]" ShowQuerySuggestions="False" PersonalResultCount="0" SetFocusOnPageLoad="True" UpdatePageTitle="False" FurtherSharedSearchBoxSettingsCheckNeeded="False" RenderTemplateId="~sitecollection/_catalogs/masterpage/Display Templates/Search/Control_SearchBox_Compact.js" StatesJson="{}" ServerIncludeScriptsJson="null" Title="Search Box" FrameType="None" SuppressWebPartChrome="False" Description="Displays a search box that allows users to search for information." IsIncluded="True" ZoneID="wpz" PartOrder="4" FrameState="Normal" AllowRemove="True" AllowZoneChange="True" AllowMinimize="True" AllowConnect="True" AllowEdit="True" AllowHide="True" IsVisible="True" DetailLink="" HelpLink="" HelpMode="Modeless" Dir="Default" PartImageSmall="" MissingAssembly="Cannot import this Web Part." PartImageLarge="" IsIncludedFilter="" ExportControlledProperties="True" ConnectionID="00000000-0000-0000-0000-000000000000" ID="g_a9b01a9d_ab26_4ede_821f_9203dadd383b" ChromeType="None" ExportMode="All" __MarkupType="vsattributemarkup" __WebPartId="{78EE87D4-0942-4011-8262-89FD98410E5F}" WebPart="true" Height="" Width=""></spsswc:SearchBoxScriptWebPart>
    
     
    <spsswc:ContentBySearchWebPart runat="server" AlwaysRenderOnServer="False" ResultType="" NumberOfItems="6" PropertyMappings="Link URL{Link URL}:Path,Line 1{Line 1}:Filename,Line 2{Line 2}:Title,FileExtension,SecondaryFileExtension" DataProviderJSON="{&quot;QueryGroupName&quot;:&quot;Default&quot;,&quot;QueryPropertiesTemplateUrl&quot;:&quot;querygroup://webroot/SitePages/Active.aspx?groupname=Default&quot;,&quot;IgnoreQueryPropertiesTemplateUrl&quot;:false,&quot;SourceID&quot;:&quot;8413cd39-2156-4e00-b54d-11efd9abdb89&quot;,&quot;SourceName&quot;:&quot;Local SharePoint Results&quot;,&quot;SourceLevel&quot;:&quot;Ssa&quot;,&quot;CollapseSpecification&quot;:&quot;&quot;,&quot;QueryTemplate&quot;:&quot;//{SearchBoxQuery}\npath:\&quot;https://pinnacleagriculture.sharepoint.com/sites/collab/corp/hr/employeefiles\&quot;  \n(IsDocument:\&quot;True\&quot; OR contentclass:\&quot;STS_ListItem\&quot;) &quot;,&quot;FallbackSort&quot;:[],&quot;FallbackSortJson&quot;:&quot;[]&quot;,&quot;RankRules&quot;:[],&quot;RankRulesJson&quot;:&quot;[]&quot;,&quot;AsynchronousResultRetrieval&quot;:false,&quot;SendContentBeforeQuery&quot;:true,&quot;BatchClientQuery&quot;:true,&quot;FallbackLanguage&quot;:-1,&quot;FallbackRankingModelID&quot;:&quot;&quot;,&quot;EnableStemming&quot;:true,&quot;EnablePhonetic&quot;:false,&quot;EnableNicknames&quot;:false,&quot;EnableInterleaving&quot;:false,&quot;EnableQueryRules&quot;:false,&quot;EnableOrderingHitHighlightedProperty&quot;:false,&quot;HitHighlightedMultivaluePropertyLimit&quot;:-1,&quot;IgnoreContextualScope&quot;:true,&quot;ScopeResultsToCurrentSite&quot;:false,&quot;TrimDuplicates&quot;:false,&quot;Properties&quot;:{&quot;TryCache&quot;:true,&quot;Scope&quot;:&quot;{Site.URL}&quot;,&quot;UpdateLinksForCatalogItems&quot;:true,&quot;EnableStacking&quot;:true,&quot;ListId&quot;:&quot;3b541750-eab6-4bc1-a816-c0075c181d28&quot;,&quot;ListItemId&quot;:12},&quot;PropertiesJson&quot;:&quot;{\&quot;TryCache\&quot;:true,\&quot;Scope\&quot;:\&quot;{Site.URL}\&quot;,\&quot;UpdateLinksForCatalogItems\&quot;:true,\&quot;EnableStacking\&quot;:true,\&quot;ListId\&quot;:\&quot;3b541750-eab6-4bc1-a816-c0075c181d28\&quot;,\&quot;ListItemId\&quot;:12}&quot;,&quot;ClientType&quot;:&quot;ContentSearchRegular&quot;,&quot;ClientFunction&quot;:&quot;&quot;,&quot;ClientFunctionDetails&quot;:&quot;&quot;,&quot;UpdateAjaxNavigate&quot;:true,&quot;SummaryLength&quot;:180,&quot;DesiredSnippetLength&quot;:90,&quot;PersonalizedQuery&quot;:false,&quot;FallbackRefinementFilters&quot;:null,&quot;IgnoreStaleServerQuery&quot;:false,&quot;RenderTemplateId&quot;:&quot;DefaultDataProvider&quot;,&quot;AlternateErrorMessage&quot;:null,&quot;Title&quot;:&quot;&quot;}" BypassResultTypes="True" ItemTemplateId="~sitecollection/_catalogs/masterpage/Display Templates/Content Web Parts/Item_TwoLines.js" GroupTemplateId="~sitecollection/_catalogs/masterpage/Display Templates/Content Web Parts/Group_Content.js" ResultsPerPage="6" SelectedPropertiesJson="[&quot;Path&quot;,&quot;Filename&quot;,&quot;Title&quot;,&quot;FileExtension&quot;,&quot;SecondaryFileExtension&quot;]" HitHighlightedPropertiesJson="[&quot;Title&quot;,&quot;Path&quot;,&quot;Author&quot;,&quot;SectionNames&quot;,&quot;SiteDescription&quot;]" AvailableSortsJson="null" SearchCenterXGeoLocations="" XGeoTenantsInfo="" IsContentSettingSelectionFlighted="True" ContentSetting="0" IsXGeo3SForwardingFlighted="True" ShowBestBets="False" ShowPersonalFavorites="False" ShowDefinitions="False" ShowDidYouMean="False" PreloadedItemTemplateIdsJson="null" QueryGroupName="Default" RenderTemplateId="~sitecollection/_catalogs/masterpage/Display Templates/Content Web Parts/Control_ListWithPaging.js" StatesJson="{}" ServerIncludeScriptsJson="null" Title="Content Search" FrameType="None" SuppressWebPartChrome="False" Description="Content Search Web Part will allow you to show items that are results of a search query you specify. When you add it to the page, this Web Part will show recently modified items from the current site. You can change this setting to show items from another site or list by editing the Web Part and changing its search criteria.As new content is discovered by search, this Web Part will display an updated list of items each time the page is viewed." IsIncluded="True" ZoneID="wpz" PartOrder="0" FrameState="Normal" AllowRemove="True" AllowZoneChange="True" AllowMinimize="True" AllowConnect="True" AllowEdit="True" AllowHide="True" IsVisible="True" DetailLink="" HelpLink="" HelpMode="Modeless" Dir="Default" PartImageSmall="" MissingAssembly="Cannot import this Web Part." PartImageLarge="" IsIncludedFilter="" ExportControlledProperties="True" ConnectionID="00000000-0000-0000-0000-000000000000" ID="g_bec00f66_e3ba_4dc4_bbd9_554c8ea9f2ff" ChromeType="None" ExportMode="All" __MarkupType="vsattributemarkup" __WebPartId="{E7E84C60-E8D3-430F-968F-BEB56633D85C}" WebPart="true" Height="" Width=""></spsswc:ContentBySearchWebPart>
    
    <h4>(Active files sorted by last name below,&#160;begin by selecting&#160;first letter of last name.)</h4><p>&#160;</p><h2>
       <a title="Terminated A" href="/sites/collab/corp/hr/employeefiles/SitePages/Active.aspx?lnindex=a">A</a>&#160;&#160;&#160; 
       <a title="Terminated B" href="/sites/collab/corp/hr/employeefiles/SitePages/Active.aspx?lnindex=b">B</a>&#160;&#160;&#160; 
       <a title="Terminated C" href="/sites/collab/corp/hr/employeefiles/SitePages/Active.aspx?lnindex=c">C</a>&#160;&#160;&#160; 
       <a title="Terminated D" href="/sites/collab/corp/hr/employeefiles/SitePages/Active.aspx?lnindex=d">D</a>&#160;&#160;&#160; 
       <a title="Terminated E" href="/sites/collab/corp/hr/employeefiles/SitePages/Active.aspx?lnindex=e">E</a>&#160;&#160;&#160; 
       <a title="Terminated F" href="/sites/collab/corp/hr/employeefiles/SitePages/Active.aspx?lnindex=f">F</a>&#160;&#160;&#160; 
       <a title="Terminated G" href="/sites/collab/corp/hr/employeefiles/SitePages/Active.aspx?lnindex=g">G</a>&#160;&#160;&#160; 
       <a title="Terminated H" href="/sites/collab/corp/hr/employeefiles/SitePages/Active.aspx?lnindex=h">H</a>&#160;&#160;&#160; 
       <a title="Terminated I" href="/sites/collab/corp/hr/employeefiles/SitePages/Active.aspx?lnindex=i">I</a>&#160;&#160;&#160; 
       <a title="Terminated J" href="/sites/collab/corp/hr/employeefiles/SitePages/Active.aspx?lnindex=j">J</a>&#160;&#160;&#160; 
       <a title="Terminated K" href="/sites/collab/corp/hr/employeefiles/SitePages/Active.aspx?lnindex=k">K</a>&#160;&#160;&#160; 
       <a title="Terminated L" href="/sites/collab/corp/hr/employeefiles/SitePages/Active.aspx?lnindex=l">L</a>&#160;&#160;&#160; 
       <a title="Terminated M" href="/sites/collab/corp/hr/employeefiles/SitePages/Active.aspx?lnindex=m">M</a>&#160;&#160;&#160; 
       <a title="Terminated N" href="/sites/collab/corp/hr/employeefiles/SitePages/Active.aspx?lnindex=n">N</a>&#160;&#160;&#160; 
       <a title="Terminated O" href="/sites/collab/corp/hr/employeefiles/SitePages/Active.aspx?lnindex=o">O</a>&#160;&#160;&#160; 
       <a title="Terminated P" href="/sites/collab/corp/hr/employeefiles/SitePages/Active.aspx?lnindex=p">P</a>&#160;&#160;&#160; 
       <a title="Terminated Q" href="/sites/collab/corp/hr/employeefiles/SitePages/Active.aspx?lnindex=q">Q</a>&#160;&#160;&#160; 
       <a title="Terminated R" href="/sites/collab/corp/hr/employeefiles/SitePages/Active.aspx?lnindex=r">R</a>&#160;&#160;&#160; 
       <a title="Terminated S" href="/sites/collab/corp/hr/employeefiles/SitePages/Active.aspx?lnindex=s">S</a>&#160;&#160;&#160; 
       <a title="Terminated T" href="/sites/collab/corp/hr/employeefiles/SitePages/Active.aspx?lnindex=t">T</a>&#160;&#160;&#160; 
       <a title="Terminated U" href="/sites/collab/corp/hr/employeefiles/SitePages/Active.aspx?lnindex=u">U</a>&#160;&#160;&#160; 
       <a title="Terminated V" href="/sites/collab/corp/hr/employeefiles/SitePages/Active.aspx?lnindex=v">V</a>&#160;&#160;&#160; 
       <a title="Terminated W" href="/sites/collab/corp/hr/employeefiles/SitePages/Active.aspx?lnindex=w">W</a>&#160;&#160;&#160; 
       <a title="Terminated X" href="/sites/collab/corp/hr/employeefiles/SitePages/Active.aspx?lnindex=x">X</a>&#160;&#160;&#160; 
       <a title="Terminated Y" href="/sites/collab/corp/hr/employeefiles/SitePages/Active.aspx?lnindex=y">Y</a>&#160;&#160;&#160; 
       <a title="Terminated Z" href="/sites/collab/corp/hr/employeefiles/SitePages/Active.aspx?lnindex=z">Z</a> </h2><p>&#160;</p><WpNs1:QueryStringFilterWebPart runat="server" QueryStringParameterName="lnindex" DefaultValue="00" FilterName="QueryString" Title="Last Name Index" FrameType="None" SuppressWebPartChrome="False" Description="Filters the contents of Web Parts using values passed via the query string." IsIncluded="True" ZoneID="wpz" PartOrder="6" FrameState="Normal" AllowRemove="True" AllowZoneChange="True" AllowMinimize="True" AllowConnect="True" AllowEdit="True" AllowHide="True" IsVisible="True" CatalogIconImageUrl="/_layouts/images/wp_Filter.gif" TitleIconImageUrl="/_layouts/images/wp_Filter.gif" DetailLink="" HelpLink="" HelpMode="Modeless" Dir="Default" PartImageSmall="/_layouts/images/wp_Filter.gif" MissingAssembly="Cannot import this web part." ImportErrorMessage="Cannot import this web part." PartImageLarge="/_layouts/images/wp_Filter.gif" IsIncludedFilter="" ExportControlledProperties="True" ConnectionID="00000000-0000-0000-0000-000000000000" ID="g_a4bb56ea_2d0b_4f03_856d_0d44c27def80" ChromeType="None" ExportMode="All" __MarkupType="vsattributemarkup" __WebPartId="{214F7892-3A6C-4B33-B0CF-BBF27B9E406D}" WebPart="true" Height="" Width=""></WpNs1:QueryStringFilterWebPart>
    
    <WebPartPages:XsltListViewWebPart runat="server" ViewFlag="" ViewSelectorFetchAsync="False" InplaceSearchEnabled="True" ServerRender="False" ClientRender="False" InitialAsyncDataFetch="False" WebId="00000000-0000-0000-0000-000000000000" IsClientRender="False" GhostedXslLink="main.xsl" NoDefaultStyle="" ViewGuid="{2C19BFF8-E5F8-4BA5-B284-B5E41652C7A6}" EnableOriginalValue="False" ViewContentTypeId="0x" ListUrl="" ListDisplayName="" ListName="{95D33F32-346C-4EC1-9DDD-471066691789}" ListId="95d33f32-346c-4ec1-9ddd-471066691789" PageSize="-1" UseSQLDataSourcePaging="True" DataSourceID="" ShowWithSampleData="False" AsyncRefresh="False" ManualRefresh="False" AutoRefresh="False" AutoRefreshInterval="60" Title="Active Employee Files" FrameType="None" SuppressWebPartChrome="False" Description="" IsIncluded="True" PartOrder="8" FrameState="Normal" AllowRemove="True" AllowZoneChange="True" AllowMinimize="True" AllowConnect="True" AllowEdit="True" AllowHide="True" IsVisible="True" CatalogIconImageUrl="/_layouts/15/images/itdl.png?rev=44" TitleUrl="/sites/collab/corp/hr/employeefiles/Employee Files/SitedPages/Active.aspx" DetailLink="/sites/collab/corp/hr/employeefiles/Employee Files/SitedPages/Active.aspx" HelpLink="" HelpMode="Modeless" Dir="Default" PartImageSmall="" MissingAssembly="Cannot import this Web Part." PartImageLarge="/_layouts/15/images/itdl.png?rev=44" IsIncludedFilter="" ExportControlledProperties="False" ConnectionID="00000000-0000-0000-0000-000000000000" ID="g_8402687a_faa9_4185_9382_8bff927d84ef" ChromeType="None" __MarkupType="vsattributemarkup" __WebPartId="{2C19BFF8-E5F8-4BA5-B284-B5E41652C7A6}" __AllowXSLTEditing="true" __designer:CustomXsl="Fldtypes_mswhTitle.xsl;fldtypes_Ratings.xsl" WebPart="true" Height="" Width=""><ParameterBindings>
    														<ParameterBinding Name="dvt_sortdir" Location="Postback;Connection" />
    														<ParameterBinding Name="dvt_sortfield" Location="Postback;Connection" />
    														<ParameterBinding Name="dvt_startposition" Location="Postback" DefaultValue="" />
    														<ParameterBinding Name="dvt_firstrow" Location="Postback;Connection" />
    														<ParameterBinding Name="OpenMenuKeyAccessible" Location="Resource(wss,OpenMenuKeyAccessible)" />
    														<ParameterBinding Name="open_menu" Location="Resource(wss,open_menu)" />
    														<ParameterBinding Name="select_deselect_all" Location="Resource(wss,select_deselect_all)" />
    														<ParameterBinding Name="idPresEnabled" Location="Resource(wss,idPresEnabled)" />
    														<ParameterBinding Name="NoAnnouncements" Location="Resource(wss,noitemsinview_doclibrary)" />
    														<ParameterBinding Name="NoAnnouncementsHowTo" Location="Resource(wss,noitemsinview_doclibrary_howto2)" />
    													</ParameterBindings>
    <DataFields>
    </DataFields>
    <XmlDefinition>
    														<View Name="{2C19BFF8-E5F8-4BA5-B284-B5E41652C7A6}" MobileView="TRUE" Type="HTML" Hidden="TRUE" Scope="Recursive" DisplayName="" Url="/sites/collab/corp/hr/employeefiles/SitePages/Active.aspx" Level="1" BaseViewID="1" ContentTypeID="0x" ImageUrl="/_layouts/15/images/dlicon.png?rev=47" >
    															<Query>
    																<GroupBy Collapse="TRUE" GroupLimit="30">
    																	<FieldRef Name="Title"/>
    																	<FieldRef Name="HR_x0020_Employee_x0020_File_x0020_Category"/>
    																</GroupBy>
    																<OrderBy>
    																	<FieldRef Name="LinkFilenameNoMenu"/>
    																</OrderBy>
    																<Where>
    																	<Eq>
    																		<FieldRef Name="Status"/>
    																		<Value Type="Text">Active</Value>
    																	</Eq>
    																</Where>
    															</Query>
    															<ViewFields>
    																<FieldRef Name="DocIcon"/>
    																<FieldRef Name="LinkFilename"/>
    																<FieldRef Name="Employee_x0020_Name"/>
    																<FieldRef Name="HR_x0020_Employee_x0020_File_x0020_Subcategory"/>
    																<FieldRef Name="Year"/>
    																<FieldRef Name="Modified"/>
    																<FieldRef Name="Created"/>
    															</ViewFields>
    															<RowLimit Paged="TRUE">30</RowLimit>
    															<Aggregations Value="Off"/>
    															<ViewStyle ID="16"/>
    															<JSLink>clienttemplates.js</JSLink>
    															<XslLink Default="TRUE">main.xsl</XslLink>
    															<Toolbar Type="None"/>
    														</View>
    													</XmlDefinition>
    </WebPartPages:XsltListViewWebPart>
    
    </div></div></td></tr></tbody></table><span id="layoutsData" style="display&#58;none;">false,false,1</span></div></SharePoint:EmbeddedFormField>
    	<WebPartPages:SPProxyWebPartManager runat="server" ID="__ProxyWebPartManagerForConnections__"><SPWebPartConnections><WebPartPages:SPWebPartConnection ConsumerConnectionPointID="DFWP Filter Consumer ID" ConsumerID="g_8402687a_faa9_4185_9382_8bff927d84ef" ID="c385445604" ProviderConnectionPointID="ITransformableFilterValues" ProviderID="g_a4bb56ea_2d0b_4f03_856d_0d44c27def80"><WebPartPages:TransformableFilterValuesToParametersTransformer ConsumerFieldNames="Last_x0020_Name_x0020_Index0" ProviderFieldNames="QueryString"></WebPartPages:TransformableFilterValuesToParametersTransformer>
    </WebPartPages:SPWebPartConnection>
    </SPWebPartConnections></WebPartPages:SPProxyWebPartManager><WebPartPages:WebPartZone runat="server" ID="Bottom" CssClass="ms-hide" Title="loc:Bottom"><ZoneTemplate></ZoneTemplate></WebPartPages:WebPartZone>
    </asp:Content>
    

    

    Friday, July 26, 2019 9:20 PM
  • Hi Sumanth,

    Whether you use SharePoint On-premises or SharePoint Online?

    If you use SharePoint On-premise, you can just search SharePoint 2013 Central Administration form Start in SharePoint server:

    From the code you provided, whether you use “Last Name Index” as a filter column in Query String Filter web part to filter list view?

    If so, check if the “Last Name Index” column is indexed in the document library.

    As a workaround, you can use PowerShell command to disable list view threshold for a list via SharePoint 2013 management shell:

    $web = Get-SPWeb http://url/sites/web
    
    $list = $web.Lists["List Name"]
    
    $list.EnableThrottling = $false
    
    $list.Update()

    Besides, here is a similar post for your reference:

    https://social.msdn.microsoft.com/Forums/en-US/0874fbc5-f70d-4282-b810-5c37e5d96d29/listviewwebpart-showing-listview-threshold-error?forum=sharepointdevelopment

    Best regards,

    Grace Wang


    Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    SharePoint Server 2019 has been released, you can click here to download it.
    Click here to learn new features. Visit the dedicated forum to share, explore and talk to experts about SharePoint Server 2019.

    Monday, July 29, 2019 3:43 AM
  • Hi Grace,

    1. We are using SP Online. So my start menu doesn't have the 'Central Admin' pop up. 

    2. I found this piece of code for the view from the entire code from above. So I just need to check  a filter column in Query String Filter web part to filter list view?

    Z</a> </h2><p>&nbsp;</p><WpNs1:QueryStringFilterWebPart runat="server" QueryStringParameterName="lnindex" DefaultValue="00" FilterName="QueryString" Title="Last Name Index" FrameType="None" SuppressWebPartChrome="False" Description="Filters the contents of Web Parts using values passed via the query string." IsIncluded="True" ZoneID="wpz" PartOrder="6" FrameState="Normal" 

    3. Tied running the shell script and this is the first error i get. 

    Get-SPWeb : The term 'Get-SPWeb' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path 
    was included, verify that the path is correct and try again.

    Thanks, 

    Sumanth

    Monday, July 29, 2019 7:31 PM
  • Hi Sumanth,

    1) You won't have Central Admin in SharePoint Online. that option is for only SharePoint On-premises. So, whatever you have that's the default design in SharePoint Online and there is no way to increase LVT in SharePoint online.

    2) I don't think the query works for your scenario.

    3) that's because there is no Get-SPWeb command in SharePoint Online. that command is for only SharePoint On-Premises.

    Thanks & Regards,


    sharath aluri

    Monday, July 29, 2019 7:41 PM