There are a lot of cases when you need to get the items by the author. For me the only correct way to get the SharePoint list items by user with CAML is like this:

<Where><Eq><FieldRef Name='Author' LookupId='TRUE' /><Value Type='Integer'>123</Value></Eq></Where>

You can delete timer job only with PowerShell. Why? I guess you know why 🙂 The most popular reason is the duplicating of timer jobs. To delete a timer job, you need to know the ID. And you can get it also with PowerShell or with GUI.

To Run PostgreSQL in Docker I use an official image ‘postgres’ from https://hub.docker.com/_/postgres. You can start it as it’s described in the documentation, but I prefer to use docker-compose. For me it’s more flexible and allows to avoid of errors when start form command line.

In my PowerShell script, which updated the content at my Personal site, became errors. I really don’t know why it stopped working at one moment, but started to debug.

Below you can find a PowerShell script to copy items from one SharePoint list at one site to another SharePoint list in another site. I use it with several modifications to work with the data in test environments.

I had a SharePoint online list and I added a new column into it. And then I wanted to work with a data, which is close to be real. So I needed to generate the data and insert it into the list. For the tasks like this I like to use division by module to create semi-random data.

When you make a SharePoint 2019 on-premises solution, you can make not only SPFX solutions, but also old-school WSP-solutions. It allows you not only to use SharePoint API, but also to use your own API services. With SharePoint 2019 you can use WCF service. For example, it’s a good way when you develop an application which uses the external database. This works also for SharePoint 2013 and SharePoint 2016.

You can add the service with PowerShell. New-Service and Get-service are available in PowerShell 5, for 'Remove-Service' PowerShell >= 6 required. Otherwise you can use 'sc.exe DELETE MyMegaServiceApplication'. You should execute it with as an administrator. Not any application you can start a service. As a .Net developer, I usually create .Net solutions, in this case you should create application based on 'worker service' template in VS 2022 or any other IDE.

As it turned out, I can execeute linux scripts at my Windows PC with WSL installed with Powershell!

Just write 'wsl -e ' and after that a command to execute.

The error is:

Configuration loaded builds=0
listen_address not defined, metrics & debug endpoints disabled builds=0
[session_server].listen_address not defined, session endpoints disabled builds=0
In gitlab runners allor “Run untagged jobs: Indicates whether this runner can pick jobs without tags”, set the checkbox correspondingly.

(read more...)