Blog

In SharepointIssue

On 15/05/2020

PSCONFIG.exe Configuration of SharePoint Products failed. Configuration must be performed before you use SharePoint Products. A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible

An exception of type System.Data.SqlClient.SqlException was thrown. Additional exception information: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

Check your connection string in HKEY_LOCAL_MACHINE > SOFTWARE > Microsoft > Shared Tools > Web Server Extensions > 16.0 > Secure > ConfigDB

In javascript

Sharepoint Query Search By UTC Date

On 09/12/2019

Sharepoint query search by date (UTC date type)

When your field is DateOnly => 12/12/2019, search service will store it like : 2019-12-11T23:00:00.0000000Z

In your regionnal settings, you can see -1

So in your query to retrieve you should substract one hour

                    
                        var aDate = new Date('2019-12-12);
                        var offset = new Date().getTimezoneOffset();
                        console.log("offset : " + offset);//in my case, offset is -60
                        console.dir(aDate);
                        aDate.setMinutes(aDate.getMinutes() + offset);
                        console.dir(aDate);
                        /_api/search/query='MnpDate:aDate.toISOString()';
                        // aDate : 2019-12-11T23:00:00.0000000Z

Sharepoint REST set ShowInEditForm

On 28/11/2019

With this script you can Show / hide your field in standard sharepoint forms

ShowInDisplayForm

ShowInEditForm

ShowInNewForm

var xhr = new XMLHttpRequest();

var url = _spPageContextInfo.webAbsoluteUrl;

if (url === "undefined {

console.log("_spPageContextInfo.webAbsoluteUrl undefined");

url = "http://siteUrl;

}

xhr.open('POST', url + "/_api/web/Lists(guid'bec2b6d5-3183-4bd7-87a5-0989610b2e25')/Fields(guid'341eeecb-e5ff-447c-9cd0-84c9f00c80c6')/setShowInEditForm(true)");

xhr.setRequestHeader("Accept", "application/json; odata=verbose");

xhr.setRequestHeader("X-RequestDigest", document.getElementById("__REQUESTDIGEST").value;

xhr.setRequestHeader("X-HTTP-Method", "MERGE");

xhr.setRequestHeader("If-Match", "*");

xhr.onload = function () {

if (xhr.status === 200) {

var kk = JSON.parse(xhr.responseText);

console.dir(kk);

}

else {

console.dir(xhr);

alert('Request failed. Returned status of ' + xhr.status);

}

};

xhr.send();

see script in mode text here

In javascript

Sharepoint Query Using REST

On 27/11/2019

Here is my page to develop my REST queries

if my query returns an object, it will display all properties of my obj, as in navigation console (console.dir(obj);)

if my query returns an array it will display all properties in input : "show properties'

complete code to add in a script editor webpart :see script

queries samples :


/_api/web/lists(guid'0E12917B-80F9-4765-8612-22A9AB467123')/items?$select=AssignedTo,Title&$orderby=DueDate desc&$filter=RelaunchDate eq null and Status eq 'In Progress'


/_api/web/getlist('/sites/csc-dev/Lists/myLMist')/fields?$select=Group,InternalName,Title,TypeAsString,Hidden


/_api/web/getlist('/sites/csc-dev/Lists/vdfdfvf')/fields?$select=Group,InternalName,Title,TypeAsString,Hidden&$filter=Hidden eq false and TypeAsString ne 'Computed' and startswith(InternalName, '_') eq false&$orderby=TypeAsString


/_api/web/getlist('/sites/csc-dev/Lists/myLMist')/fields?$select=Group,InternalName,Title,TypeAsString,Hidden


/_api/web/lists(guid'0E12917B-80F9-4765-8612-22A9AB46784E')/items?$select=AssignedTo/EMail,Created,Author/EMail,Body,DueDate,,ID,IsGroup,Modified,Editor/EMail,StartDate,Status,stepName,TaskGroup/EMail,TaskIdentifier,TaskProcessed,TaskProcessedBy/Title,TaskProcessedBy/Id,TaskProcessedBy/EMail,Title,WFFormFieldStepType,WFInstance&$orderby=DueDate desc&$filter=RelaunchDate eq null and Status eq 'In Progress'&$expand=Author,Editor,AssignedTo,TaskProcessedBy,TaskGroup


USER

{
Title: string;
EMail: string;
Id: number;
}

Sharepoint Query Search With REST

On 25/11/2019

using REST to query sharepoint

the script to put in a script editor webpart

In Powershell

CSOM powershell SSL TSL site

On 23/11/2019

Exception calling "ExecuteQuery" with "0" argument(s): "The request was aborted: Could not create SSL/TLS secure channel." SOLVED

Exception lors de l'appel de ExecuteQuery" avec 0" argument(s): La demandea été abandonnée: Impossible de créer un canal sécurisé SSL/TLS." : résolu

How to connect to a SSL/ TSL sharepoint site with CSOM in powershell

Start to call a request with your certificate

$anUrl = https://mySharepoint

$CertificateThumbprint = "53836D3C35F949959D7E4038D5D39D7B"

$response = Invoke-WebRequest -Verbose -URI $anUrl -CertificateThumbprint $CertificateThumbprint -UseDefaultCredentials -SessionVariable websession -ErrorAction:Stop

# extract cookies from your response, and isolate wich one is authentication cookie

$cookies = $websession.Cookies.GetCookies($anUrl)

$global:cookieName3= "$($cookies[$i].name)".Trim();

$global:cookieVal3 = "$($cookies[$i].value)".Trim();

# get correct certificate in your store

$global:cert = Get-ChildItem -Path cert:\CurrentUser\My | ?{$_.Thumbprint -eq $CertificateThumbprint}

$context987 = New-Object Microsoft.SharePoint.Client.ClientContext($anUrl);

# set the security protocol

[Net.ServicePointManager]::SecurityProtocol = [Net.SecurityProtocolType]::Tls12 -bor ` [Net.SecurityProtocolType]::Tls11 -bor ` [Net.SecurityProtocolType]::Tls -bor ` [Net.SecurityProtocolType]::Ssl3

# add an ExecutingWebRequest event, which will be raised on each Execute query

$context987.add_ExecutingWebRequest({ })

# in this ExecutingWebRequest you should add the certificate to yoour request and add the authentification cookie

$request = $EventArgs.WebRequestExecutor.WebRequest

$request.ClientCertificates.Add($global:cert)

$request.CookieContainer = New-Object System.Net.CookieContainer

$c3 = New-Object System.Net.Cookie($global:cookieName3, $global:cookieVal3, "/", $global:cookieDomaine);

$request.CookieContainer.Add($c3);

$context987.Load($context987.web);

$context987.ExecuteQuery();

Write-Host "Title : $($web.Title)"

get full script here

to list all your available certificate execute following script

[System.Security.Cryptography.X509Certificates.X509Store]$storeNew-Object System.Security.Cryptography.X509Certificates.X509Store([System.Security.Cryptography.X509Certificates.StoreName]::My, [System.Security.Cryptography.X509Certificates.StoreLocation]::CurrentUser) # LocalMachine

$store.Open([System.Security.Cryptography.X509Certificates.OpenFlags]::ReadOnly);

$store.Certificates | select Thumbprint, FriendlyName, Subject

Hide Sharepoint Top Nav

On 30/10/2019

Add in your query string fdiedit=1 to show the top vanigation

http://yourSite/sites/test01/Pages/home.aspx?fdiedit=1

<style>

#SearchBox{

display: none;

}

#gdocSearchBox {

display: block;

}

#s4-ribbonrow{

display: none;

}

#suiteBarTop{

display: none;

}

#SearchBox{

display: none;

}

#DeltaTopNavigation .root.ms-core-listMenu-root.static {

margin-top: 10px;

}

#s4-titlerow {

margin-top: 0px;

margin-bottom: 0px;

padding-top: 0px;

padding-bottom: 1px;

height: 20px;

}

.ms-breadcrumb-top{

display: flex;

}

</style>

function showSpStandard() {//show top nav

jq("#suiteBarTop").show();

jq("#s4-ribbonrow").show();

jq("#SearchBox").show();

jq("#DeltaPageStatusBar").show();

jq("#s4-titlerow").show();

jq("#suiteBarTop").show();

jq(".root.ms-core-listMenu-root.static").show();

}

function getUrlVars() {//get query strings

var vars = {};

var parts = window.location.href.replace(/[?&]+([^=&]+)=([^&]*)/gi, function(m,key,value) {

vars[key] = value;

});

return vars;

}

function fdiShowEdit(){//if query string

var canEdit = getUrlVars()["fdiedit"];

if(canEdit == 1)

showSpStandard();

}

_spBodyOnLoadFunctionNames.push("fdiShowEdit");

</script>

You can put this script in a script editor webpart or in master page

get script

Sharepoint Rest Query List

On 21/09/2019

Query sharepoint list with REST

use this end point to query your list http://test/sites/test/_api/Web/Lists/getbytitle('vvv')/items?$select=&$filter= Title eq 'entite du ga 1'

Example : http://test01/sites/test01/_api/Web/Lists/getbytitle('Aliste')/items?$select=Title,ID,Author/Title&$expand=Author&$filter= Title eq 'entite du toto 1'

to order by : &$orderby= Employee asc

to order by : &$orderby= Employee desc

to limit number of items returned : $top 5

to use paging : $skip 5

new paging mode add in your first query &$skiptoken=Paged=TRUE in your response, you will receive next page query in odata.nextLink as below

Nextlink

/_api/Web/Lists/getbytitle(%27Initiatives%27)/items?%24skiptoken=Paged%3dTRUE%26p_ID%3d266&%24select=Title%2cID&%24orderby=ID+desc&p_ID=268&%24Top=3

expand lookup fields : $expand=city&$select=city/Id

viewfields : $select= Title, ID

filter : $filter=Title eq 'mon noeud' and ID ne 1

Numeric comparisons