Skip to main content
Search Again

We think these articles could help you:

    See More
    Nintex Knowledge Base

    UDA Being Used in Another Site Collection?

    Status: Pending Clean Up

    TOPIC
    A user defined action that shows it is being used by workflows on another site. I don't believe it is actually being used by these workflows but would like to confirm and clean up where the UDA is displaying incorrect information.
    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
     
    ADDITIONAL INFORMATION
    RELATED LINKS
    • Was this article helpful?