REST API to filter null values for SharePoint list items

I am working for SharePoint online and I came crossed to get sharepoint list items based on null values via OTB web-part. Using IE browser I came to knew that I finding no luck to crack it.

Solution:

1. Use @v1 parameter for your rest api
2. And append the caml query @v1using $select

http://mysharepointsite/_api/web/Lists/GetByTitle('Documents1')/GetItems(query=@v1)?@v1={"ViewXml":"<View><Query><Where><And><IsNull><FieldRef Name='Selection'/></IsNull><Eq><FieldRef Name='EmpNumber'><Value Type='Text'>51457270</Value></Eq></And></Where></Query></View>"}&$select=Title

Unable to edit web part in a page

One of my business user added the page in site pages and included web part in it

And tried to edit the web-part , But I found no luck in getting the options

  

Solution:

1. Open Internet Explorer, select the Tools button , and then select Compatibility View settings.
2. Under Add this website, enter the URL of the site you want to add to the list, and then select Add  

                                                           or

Else it should be Microsoft Product issue

Set the co-authoring Limit for Web-application

Add-PSSnapin Microsoft.SharePoint.PowerShell
$site = Get-SPSite -Identity https://yourwebapplicationURL        
$site.Url
$site.WebApplication.WebService.CoauthoringMaxAuthors=19
$site.WebApplication.WebService.Update()
$site.Dispose()
Write-Host $site.WebApplication.WebService.CoauthoringMaxAuthors

The main purpose of the co-authoring is to limit the users for editing the particular document in document library .If the document is editing by too many users then users looses the UI experiance instantly ,So we limit the users interaction with co-authoring

Find SharePoint Correlation-ID with Powershell

Today when I entered into my machine , I was getting correlation ID . I don't know where my team members changed the location of Log files from Hive 15 folder .

Then I used below by opening SharePoint Powershell command as administrator to fetech the log files 

Step 1: Merge-SPLogFile -Path ".\error.log" -Correlation "Correlation-ID"

Step 2: dir *.log

Powershell to find total documents in Farm

Get-SPSite -Limit All | Get-SPWeb -Limit All | % { $_.Lists} | ? { $_ -is [Microsoft.SharePoint.SPDocumentLibrary] } | % { $total+= $_.ItemCount} ; $total

Count total documents from all document libraries of Site Collection using PowerShell

$site = New-Object Microsoft.Sharepoint.SPSite("https://site collection name or any site");  # Get spsite object
$body = "Site Collection Document Audit for $site`r`n"
foreach ($web in $site.AllWebs)
{
    $url = $web.Url;
    $body = $body + "Web: $url`r`n";
    $lists = $web.GetListsOfType(1);   #Get all document libraries;
    foreach($list in $lists)
    {
       
        $count = $list.Items.Count;
        $title = $list.Title
        $body = $body + "        -  $title :$count items.`r`n"
    }
    $body = $body + "`r`n";
    write-host $body
$web.Dispose();
}
$site.Dispose();

Unexpected Exception in SPDistributedCachePointerWrapper::InitializeDataCacheFactory for usage 'DistributedLogonTokenCache

SharePoint 2013 / 2016  uses app-fabric to host couple of cache cluster in this process the services of App fabric might get stooped due to it's time line . Also need to rights

Solution 1 :  Start the App Fabric cahcing services in Services.msc and reset IIS

Solution 2: Extend the cache Settings with powershell

$set = Get-SPDistributedCacheClientSetting -ContainerType DistributedViewStateCache

$set.requestTimeout = “100” # normally it’s 20ms

$set.channelOpenTimeOut = “100” # normally it’s 20ms

# maybe change the other values too

Set-SPDistributedCacheClientSetting -ContainerType DistributedViewStateCache $set

Solutions 3: The server farm account, which is also referred to as the database access account, is used as the application pool identity for Central Administration

• Membership in the WSS_ADMIN_WPG Windows security group for the SharePoint Foundation 2013 Timer service.
• Membership in WSS_RESTRICTED_WPG for the Central Administration and Timer service application pools.
• Membership in WSS_WPG for the Central Administration application pool.

Solution 4 : Use the commands to stop ,remove and start the distributed service

Stop-SPServiceInstance

Remove-SPDistributedCacheServiceInstance

Add-SPDistributedCacheServiceInstance