Skip to main content
Search Again

We think these articles could help you:

    See More

    ALERT: This site will be decommissioned at the end of December 2018. All existing and new Nintex knowledge content will be available within the new Knowledge Base area of the Nintex Community site. 

    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?