• Our Office
  • 12 Alpine Close Lakefield Benoni 1501

Clickatech

Nintex DelegateAllTasks

Our environment runs a lot of Nintex 2016 Workflows, to ease support we separate each workflow solution’s history and tasks lists. For normal maintenance and finding issues works quite well. But as always there always pros and cons. One of our senior executive recently resigned with immediate effect leaving quite [...]

Read More
Clickatech Nintex

Nintex – Useful SQL Queries

This script will show you how many Workflow progress records each workflow in your environment has generated. SELECT i.WorkflowName, COUNT(p.InstanceID) [Number of WF Progress Records], i.siteid, i.webid, i.listid FROM dbo.workflowinstance i inner join dbo.workflowprogress p on i.InstanceID = p.InstanceID GROUP BY i.WorkflowName, i.siteid, i.webid, i.listid ORDER BY COUNT(p.InstanceId) DESC This [...]

Read More

Nintex Workflow Status Codes

To use the Nintex status column to filter SharePoint views and/or do operations on list items in Nintex you need to use the following status codes (instead of the actual status text): NotStarted = 0 FailedOnStart = 1 InProgress = 2 ErrorOccurred = 3 StoppedByUser = 4 Completed = 5 [...]

Read More