Wednesday, June 28, 2017

SharePoint Large list issue, View does not work even after do data archival to meet the threshold limit for query criteria

SharePoint has resource throttles and limits that govern the amount of data and throughput that can be managed. The List View Threshold is by default, approximately 5000 items, and is set to allow users to work with large lists, but keep good performance.

Index and Filter views , Using folders to organize using document center site are the some of the workaround you can do to keep your queries within the limit.

As a last choice, with Server versions of SharePoint, is to change the limit. But this is not recommended , since a larger limit increases the possibility of affecting the performance for some or all users. 

Archiving the list is the widely using mechanism to over come this issue. However it is noticed that once the issue occur, even after you archive the list and make count of document less than the threshold limit for the query items, it does not work. This is because the old count is still using by the SharePoint process and it does not refresh. As a workaround on this issue, create a new list and move entire data to the list. You can find in the new list, views are started working.






Nintex Support Interaction - move item from a Document library folder to its root folder.


In Nintex workflow , Please let me know how can I move item from a Document library folder to its root folder.

Moving to sub folder , I have used update item and update name as foldername/filename. It works.
But how to move from subfolder to root ? update name with /filename does not work.


Do you have any other way to achieve it?

(JUN 2017)

In it's current state, Nintex Workflow does not have an action that will move or copy an item from a subfolder to the root.  The copy item action copies files to the root of a list/library, but cannot access subfolders.  I'm going to do some additional research tomorrow to see if there are any web services you can call to achieve the desired outcome.  If I can't find anything, I'll check with our senior engineers to see if they have any other thoughts regarding this.  In the meantime, let me know if you have any questions.
----------------------------------------------------------------------------------------------------------------
I want change what I sent yesterday, since we do have an action that can perform this task, although it's probably not the most ideal solution.  You can create a simple workflow that has the "Copy to SharePoint" action and select the location of the root folder.  Publish the workflow like this, then you can navigate to the file you want to move to root, click on the ellipsis (...) then click on the next ellipsis, click on Workflows, and run the workflow you created.  This will move the document from it's current location to the root (or wherever you specify).  Let me know if you have any questions.

By using copy to SharePoint, we can copy the file to root and can delete the original one. But by this approach, we lose all version history details. Is there any way to move file too root by keeping the version history?

Nintex Workflow does not have an action that will automatically do this for you.  However, what you are requesting is possible when using the "Call Web Service" action and utilizing 'author.dll'.  As this type of request will fall under a professional services offering, we can't offer much additional support, however please take a look at this blog post from one of our Technical Evangelists:


Let me know if you have any questions.

Saturday, May 20, 2017

Trigger SharePoint apply filter web part Action by Enter Key

    Trigger SharePoint apply filter web part Action by Enter Key


Apply Filters button that you can use to apply all the filters on the SharePoint page by a text filter or by a choice filter. One after the entry in the text filter, user need to press apply button to apply the changes. Usually customer demand for enter key action once after data input in the text filter.   You may need to include below Javascript/jquery code to achieve this. This can be included in the content editor or script editor web part.

In below example ctl00_ctl42_g_33a1df20_58a6_46b7_9656_ef6f32e42d5b_SPTextSlicerValueTextControl' is the Web part id of the Text filter web part and ctl00_ctl42_g_ec3e3fa8_03e7_4e09_b1f1_9951d415b638 is the ID of the filter web part, which you can fetch from the HTML source using developer tool for IE


<script src="/_layouts/15/STYLES/PNG.SharePoint.Core/js/jquery-1.9.1.min.js" type="text/javascript"></script>

<script language="javascript" type="text/javascript">
$(document).ready(function() {
$('#ctl00_ctl42_g_33a1df20_58a6_46b7_9656_ef6f32e42d5b_SPTextSlicerValueTextControl').keypress(function(event){
        var keycode = (event.keyCode ? event.keyCode : event.which);
        if(keycode == '13'){
           //Your Code that you want to execute or simply call the function RedirectUrl()
        event.preventDefault();
        ctl00_ctl42_g_ec3e3fa8_03e7_4e09_b1f1_9951d415b638_PostBack(event);
        }
    });

})

  
</script>

Screen Shot