JamieA Expert

There is sample code in the UI for priority changed - you need to modify it for issuetype. Think the string you want is "issuetype", but could be wrong.

You'd need to run through the changehistory of the issue. Do you mean to check whether the issue type changed in this transition, or at any time previously?

You need to give the users the assignable_user permission in the permission scheme, rather than giving the global browse users permission. That is for being able to see all users using the user picker, for instance.

You could write a report using ScriptRunner for Confluence.

I would also remove the validation query.

That's a good point... I found using a validation query made things massively slower (on oracle at any rate). The validation query is run before every single normal query. As Radu says 300 connections seems way too much... I manage a jira site with 10k users and the connection pool is 30.

With java melody you should see two thread dumps for every connection, one is from when the connection was created, and one is what it is currently doing. The one that created it is the interesting one.

I don't think you're going to get a correct answer based on the information in your question. But, if you install the java melody plugin, it will show you all the database connections, along with stacktraces from what created the connection. Using this, you can find out which plugin (it probably is a plugin) is creating…

I presume you've looked at https://studio.plugins.atlassian.com/wiki/display/WBDV/WebDAV+Client+Setup#WebDAVClientSetup-WebDAVClientSetupMicrosoftNetworkDrive ?

There is no call to indexManager.reIndex(issue); where indexManager is from: ComponentAccessor.getIssueIndexManager()

Should not be a problem if your database setting is utf-8. Can you get back to use with what database you're using and how it was created?

That's not available in AOD :-(

You can't do it in ondemand. For hosted there are various plugins available, eg https://studio.plugins.atlassian.com/wiki/display/GRV/Scripted+JQL+Functions#ScriptedJQLFunctions-linkedIssuesOf%28Subquery%2Clinkname%29

I doubt you can put HTML anywhere, the reason being that they're trying to prevent again you using javascript for a XSRF attack or similar. Not quite sure why that applies to administrators, but I believe that's the reason.

You don't want this line: def fieldConfig = cf.getRelevantConfig(issue) You want something like: def labEq = issue.getCustomFieldValue(cf) Then labEq should contain the value of the field (actually it will contain an Option object, but if you use it in a String context it will be toString'd). If not: use labEq?.value to…

BTW Answers doesn't really work well when it's used in a back and forth way... I think the original question is answered... would be good if you could create a new question for anything else. Also helps people when searching. cheers, jamie

> Jamie, I found your link on hacking the built in scripts. I don't have that path in my directory at all. How else would built in scripts be called It won't be on your directory, it will be in the jar. If you put the script on your filesystem you need to make the directories corresponding to the package under…

Well, only admins can access the script runner admin panel... and I wouldn't let my managers be admins for all the tea in China. The best option is a jira report plugin, but writing that is more complex than the script you've got. At some point I hope to extend the script runner to reports....

> are you getting the points Yes, that's lovely, thanks. Your code doesn't look valid... def cf = customFieldManager.getCustomFieldObjectByName("TextFieldA")if (issue.getCustomFieldValue(cf) != issue.parentObject.getCustomFieldValue(cf)) {...} should work.

priority is issue.priorityObject.name Points... if you think an answer is helpful click the up arrow, if correct click the tick. If a comment is helpful click the thumbs up icon! Thanks, I am expecting the motherlode of points!

> how do I make this script a built in script Well you need to implement the CannedScript interface - easiest thing is to copy the simplest of the existing ones and just chuck your code in the doScript method or whatever it's called. All the built-in script sources are in both the binary and source distro.

> Thanks so much. I really appreciate this That's fine, but can you give me some points ;-) My original script worked, but it printed the results to the screen. Your "new File" can't be in the "collect", otherwise the same file will keep getting created and written to. The collect collects the last thing returned, which is…

You mean you ran my script below? And it gave you like: [null, null] or something?

This is reasonably hard in SQL, but easy enough with the API. If you have the script runner plugin you can do it with the following script: package examplesimport com.atlassian.jira.ComponentManagerimport com.atlassian.jira.jql.builder.JqlQueryBuilderimport com.atlassian.jira.issue.search.SearchRequestimport…

Exact duplicate of https://answers.atlassian.com/questions/28368/automatically-create-a-page-under-project-on-confluence-when-a-jira-issue-is-created - I closed this.

https://answers.atlassian.com/questions/22652286/it-appears-to-me-that-cloned-issues-do-not-receive-the-source-issues-security-level.

Seems to be the same as this issue below: https://jamieechlin.atlassian.net/browse/GRV-409- looking at that now.

Can you create a ticket including the stack trace?

It inherits everything - you can unset what you don't need in the "additional code" section.

issue is a reference to the new issue, in this case the subtask.