Useful tools and scripts for post-migration script adjustment

You can use some tools and methods to help convert, update, and clean up scripts when migrating from Jira DC to Jira Cloud, including workflow conversion, filter updates, and bulk script modifications.

Script conversion assistance with WorkFlow Pro

WorkFlow Pro is an AI chat agent run on Rovo that simplifies Jira automation processes. This application is currently being trained on the complete range of Apprifre workflow and automation apps, including the Simple Issue Language (SIL) used in Power Scripts. While Workflow Pro is new and its training is still ongoing, it can provide significant help for converting scripts after Jira DC to Cloud migration.

Scripts for cleaning up saved filters

You can use scripts to audit filters and update the syntax of specific functions used in saved filters.

This analysis script helps assess the impact before making changes by identifying which filters need updating. It's a safe, read-only tool to use before running the actual update script.

for(JFilter f in admGetAllFilters()) {
    string oldFunction = "hasLinkType";
    
    if(contains(f.jql, oldFunction)) {
        runnerLog("Filter \"" + f.name + "\" [" + f.id + "] owned by " + userFullName(f.owner) + " <strong style=\"color:red;\">contains</strong> the function for removal: <strong>" + oldFunction + "</strong>", true);
    } else {
        runnerLog("Filter \"" + f.name + "\" [" + f.id + "] owned by " + userFullName(f.owner) + " <strong style=\"color:green;\">does not contain</strong> the function for removal: <strong>" + oldFunction + "</strong>", true);
    }
}

When migrating JQL queries from Jira DC to Cloud, use this template to convert function syntax from the issueFunction in format to the new equals operator format:

//Starting JQL format:
issueFunction in FUNCTION_NAME("PARAMETER") and ADDITIONAL_CONDITIONS

//Changes to:
FUNCTION_NAME = "PARAMETER" and ADDITIONAL_CONDITIONS

Where:

FUNCTION_NAME represents any JQL function name
PARAMETER represents the function's parameter
ADDITIONAL_CONDITIONS represents any additional JQL conditions

Example

This example shows how the transformation can work on a specific JQL query.

//starting JQL format
issueFunction in hasLinkType("Blockers") and resolution is empty

//would be changed to:
hasLinkType = "Blockers" and resolution is empty

This query is looking for:

Issues that have a link of type Blockers.
AND are unresolved (resolution is empty)

For each filter containing the old hasLinkType syntax, the script:

Splits the JQL at hasLinkType
Removes issueFunction in from the first part
Replaces parentheses with an equal sign (=)
Reconstructs the JQL with the new syntax
Updates the filter with the new JQL

How to make bulk changes on scripts

After migrating to Jira Cloud, scripts often require bulk changes. A common task is identifying scripts that use hard-coded custom field IDs (for example, customfield_). Here's how to search across all scripts for these references and perform the update:

In the SIL Manager, right-click the silprograms folder, then click Download.

Download all scripts in the silprograms folder
Extract the downloaded zip file and open it in a tool such as VS Code.
Use find and replace features to search and update all files in the selected folder.

Find and Replace menus in VS Code
Compress (zip) the updated files.
Go back to Power Scripts and navigate to the Self Help > Backup/Restore tab.
Next, upload the zip file you saved.

Uploading the zip file will replace ALL files in the silprograms folder.