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; } } }

How to auto-assign issue using mapping

BartłomiejS

Hi there,

Perhaps I miss something but haven't found solution so far...

we need to automatically auto-assign issue right after its creation to a dynamically chosen user on the base of reporter.

To choose the assignee some mapping is needed. Every reporter has some default assignee independently in which project/component issue is created.

For example

User1 -> Assignee1

User2 -> Assignee1

User3 -> Assignee2

User4 -> Assignee2

User5 -> Assignee3

and so on...

Perhaps it could be done on the base of user properties but I have no clear idea or solution to this problem. Could you please help me?

thanks!

Accepted answers

All comments

RambanamP

using post function you can do this

BartłomiejS

but i need to script it somehow right?

RambanamP

no, just you need to configure postfunction at create transition step

BartłomiejS

ok this step is simple... but how can i freele choose assignee on the base of different reporters there? it'c completely customized behavior. i don't want to choose assignee from the list, because it depends on reporter - as i wrote in teh first post.

Henning Tietgens

You can use the Script Runner plugin to script a postfunction, where you map the reporter to the assignee.

BartłomiejS

we came back to the subject after a while and one more condition appeared... we need to get some hints for determining default assignee using external oracle datasource... i haven't found a solution on how to access external DB using script runner so far... any help would be appreciated

Henning Tietgens

Using something like this you can access an external database:

Sql sql = null

try {
	// Get Context to connect to DATABASE as a datasource
	Context ctx = new InitialContext()
	if (ctx == null) throw new Exception("No Context found!")
	DataSource ds = (DataSource) ctx.lookup("java:comp/env/jdbc/DATABASE")
	if (ds != null) {
		sql = new Sql(ds)
		sql.eachRow(sqlStatement) { row -&gt;
			// ...
		}
	}
} catch (Exception e) {
	e.printStackTrace();
}
sql?.close()

The datasource DATABASE has to be defined within <Context> section of context.xml in jira/conf similar to something like this:

&lt;Resource name="jdbc/DATABASE" auth="Container" type="javax.sql.DataSource"
username="user"
password="password"
driverClassName="net.sourceforge.jtds.jdbc.Driver"
url="jdbc:jtds:sqlserver://10.192.168.1:1433/test"
/&gt;

After changing context.xml you have to restart JIRA. And you have to use driver matching the database system used.

Henning

JamieA

good info on using a datasource, alternative method is here: https://answers.atlassian.com/questions/154110/script-runner-external-oracle-database-support