Can Scriptrunner be used to add a list of URLs to a project's shortcuts?

Jeremy Jedlicka_zdht3c

We have a set list of links that gets added to each project's shortcuts. Instead of adding these one by one each time a new project space is created, I'd like to automate this.

Is this possible via scriptrunner?  I haven't found anything in the Jira backend to set default shortcuts.  If it is possible, can someone point me in the right direction to the groovy documentation explaining this?

Thanks.

Ram Kumar Aravindakshan _Adaptavist_

Hi @Jeremy Jedlicka

After going through your description, if you intend to auto-insert the shortcuts in the Project Shortcuts section, as shown in the image below, this is not directly doable using ScriptRunner because it is controlled by the "AO_550953_SHORTCUT" table.

The only way the shortcuts can be added is by inserting the values into that table, which is not recommended.

On the other hand, if you are okay with adding the shortcuts outside this section, as shown in the image below:-

this can be done using ScriptRunner's fragments.

If you would like to try the 1st approach, you could try the sample code below on the ScriptRunner console:-

import groovy.sql.Sql
import java.sql.Driver

final def projectKey = 10000

def props = new Properties()
props.setProperty('user', 'adaptavist')
props.setProperty('password', 'qwerty')

def driver = Class.forName('org.postgresql.Driver').newInstance() as Driver
def conn = driver.connect('jdbc:postgresql://localhost:5432/Jira8', props)
def sql = new Sql(conn)

def insertions = [
        "insert into \"AO_550953_SHORTCUT\" (\"NAME\", \"PROJECT_ID\", \"SHORTCUT_URL\", \"ICON\") values ('Adaptavist', ${projectKey}, 'https://www.adaptavist.com', '');",
"insert into \"AO_550953_SHORTCUT\" (\"NAME\", \"PROJECT_ID\", \"SHORTCUT_URL\", \"ICON\") values ('Adaptavist Library', ${projectKey}, 'https://library.adaptavist.com', '');",
"insert into \"AO_550953_SHORTCUT\" (\"NAME\", \"PROJECT_ID\", \"SHORTCUT_URL\", \"ICON\") values ('ScriptRunner Docs', ${projectKey}, 'https://docs.adaptavist.com/sr4js/latest', '');",
"insert into \"AO_550953_SHORTCUT\" (\"NAME\", \"PROJECT_ID\", \"SHORTCUT_URL\", \"ICON\") values ('Groovy Lang', ${projectKey}, 'https://groovy-lang.org', '');",
"insert into \"AO_550953_SHORTCUT\" (\"NAME\", \"PROJECT_ID\", \"SHORTCUT_URL\", \"ICON\") values ('Groovy Tutorial', ${projectKey}, 'https://www.guru99.com/groovy-tutorial.html', '');",
"insert into \"AO_550953_SHORTCUT\" (\"NAME\", \"PROJECT_ID\", \"SHORTCUT_URL\", \"ICON\") values ('Jira Api Docs', ${projectKey}, 'https://docs.atlassian.com/software/jira/docs/api/8.22.2/', '');",
"insert into \"AO_550953_SHORTCUT\" (\"NAME\", \"PROJECT_ID\", \"SHORTCUT_URL\", \"ICON\") values ('Atlassian Community', ${projectKey}, 'https://community.atlassian.com', '');"
] as ArrayList<String>

try {
    insertions.each {
        sql.execute(it)
    }
} finally {
    sql.close()
    conn.close()
}

Please note that the sample code provided above is not 100% exact to your environment. Hence, you will need to make the required modifications.

Before running this code, please ensure that you back up your Jira database so you can revert to it if anything goes wrong.

Also, before triggering this code in the ScriptConsole, please manually add one link in the Project Shortcuts section.

Once you have added the link, you can trigger the code in ScriptConsole.

If you intend to remove the links, you must manually do it using the Jira UI. 

I hope this helps to answer your question.

Thank you and Kind regards,

Ram