nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Need help with Script listener

Aisha M

Hi,

I have a listener in place for a particular functionality. This listener is meant to work on a select list of projects.

I now want the listener to get the list of projects from the database, instead for manually adding each time into the listener.

Can I please get some help on what needs to the appended to the existing listener in order for it to get the select list of projects from the SQL database.

Accepted answers

Tuncay Senturk _Snapbytes_

Hello @Aisha M

Do you need to get the list of projects from the database?

Wouldn't the script below help?

import com.atlassian.jira.component.ComponentAccessor

def projects = ComponentAccessor.getProjectManager().getProjectObjects()

All comments

Tuncay Senturk _Snapbytes_

Hello @Aisha M

Do you need to get the list of projects from the database?

Wouldn't the script below help?

import com.atlassian.jira.component.ComponentAccessor

def projects = ComponentAccessor.getProjectManager().getProjectObjects()

Aisha M

Up until now, the projects for which the listener must work is separately mentioned on the listener page under 'projects".

But now, we want the listener to get a specific set of projects from the database table . .

So I want to know how to specify in the listener for getting a particular set of projects from the db . .

Tuncay Senturk _Snapbytes_

So, as far as I understand you need to connect the Jira database and get the result of the SELECT statement within your script linstener. Is that the case?

Tuncay Senturk _Snapbytes_

In either case (whether it is a Jira database or an external database) I'd recommend checking Script Runner's Connecting to databases link.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

scriptrunner

jira

script-listener

jira-server

database