Pages

Showing posts with label Nintex Workflow. Show all posts
Showing posts with label Nintex Workflow. Show all posts

Tuesday, April 13, 2021

Unlock SharePoint NIntex Workflow Tasks With PowerShell

 

We had struggled with this task locking problem for a few months, once approver's completed task.  It seemed that the problem started after making updates from Microsoft and Nintex.  

It will display in the following message to edit workflow tasks

"This task is currently locked by a running workflow and cannot be edited."

After few hours research, I found out ways to unlock SharePoint Nintex workflow tasks using PowerShell script.


Solution:





[system.reflection.assembly]::LoadWithPartialName("Microsoft.SharePoint")

$siteUrl="http://TestSIte/"

$site=new-object Microsoft.SharePoint.SPSite($siteUrl)

$web=$site.OpenWeb()

$web.url

$i=0

write-host $web.lists

foreach($list in $web.lists){

    foreach($item in $list.items | where {$_[[Microsoft.SharePoint.SPBuiltInFieldId]::WorkFlowVersion] -ne 1}){

 

            if($item["Status"] -eq "Not Started")

            {

                  Try

                  {

                        Write-Host Unlocking workflow on $item.name

                        $item[[Microsoft.SharePoint.SPBuiltInFieldId]::WorkFlowVersion]=1;

                        $item.SystemUpdate()

                        $i++

                  }

                  Catch [System.Exception]

                  {

                        Write-Host Caught error trying to unlock workflow -ForegroundColor Red

                  }

            }

      }

}

Write-Host Unlocked $i workflows within $web.url

$web.dispose()

$site.dispose()

Wednesday, August 17, 2016

Dynamic hyperlink open in the new window in the Nintex workflow form

Opening a dynamic link in a new window can also be done by adding a button

 (action: JavaScript, type: Link) in the advanced section you enter window.open("the dynamic link") by on-click.




Now you can click on the Resume Link, it will open the Resume Document.

Wednesday, April 6, 2016

How to get Nintex Tasks Approval ID from Sql Server



SQL Query:

Execute the below query in your Nintex SQL server.

/****** Script for SelectTopNRows command from SSMS  ******/
SELECT TOP 1000 [Id]
      ,[Name]
  FROM [NW2013DB].[dbo].[ConfiguredOutcomes]



Friday, November 27, 2015

Nintex Workflow 2013 Error in Sharepoint 2013 Central Admin Site


When you installing Nintex Workflow 2013 in your sharepoint 2013 server, After installed the installer and Deployed the Nintex Workflow WSP then open the Nintex Workflow Management, It will throw in the below error 
The located assembly’s manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)
If you come across the aboveerror while clicking the “Nintex Workflow Management” in Central Admin, Reset IIS