UDA Being Used in Another Site Collection?

  • 15 February 2022
  • 0 replies
  • 9 views

Userlevel 3
Badge +8

Topic

A user defined action (UDA) appears to be used by workflows on another site. This isn't the actual case and the below instructions will correct this.

 

Instructions

Take note of the following:
  1. UDA name
  2. Workflow Name
  3. Workflow version (in UDA Analyzer)
 
Use the following SQL script to clean this up
 
-- Get UDA Id
 SELECT *
    FROM UserDefinedActions
   WHERE 1=1
         AND [Name] = 'UDA Name'
 
-- Get Published Workflow Id
  SELECT *
    FROM PublishedWorkflows
   WHERE 1=2
         OR (WorkflowName = 'Workflow Name' AND [Version] = 3)
         OR (WorkflowName = 'Workflow 2' AND [Version] IN (18,19))                --Multiple workflows
         OR (WorkflowName = 'Workflow 3' AND [Version] = 4) –Multiple Workflows
 
-- Find reference records
  SELECT *
    FROM UdaUsage
   WHERE 1=1
         AND UdaId = <ID of your UDA>
         AND PublishedWorkflowId IN (ID of Published workflow) –Separate multiple workflows with a comma
 
-- Remove reference records
  DELETE
    FROM UdaUsage
   WHERE UdaId = <ID of your UDA>
         AND PublishedWorkflowId IN (ID of Published workflow) –Separate multiple workflows with a comma
 

 


0 replies

Be the first to reply!

Reply