We are considering upgrading JIRA and script runner.
JIRA Version(6.3.15 to 7.4.5)
script runner(3.1.4 to 5.4.49)
There are places where the script does not work.
Could you please help me?
*******
import com.atlassian.jira.component.ComponentAccessor
import com.atlassian.jira.issue.Issue
import com.atlassian.jira.issue.MutableIssue
import com.atlassian.jira.ofbiz.DefaultOfBizConnectionFactory
import com.atlassian.mail.Email
import com.atlassian.mail.queue.SingleMailQueueItem
import groovy.sql.Sql
import org.apache.log4j.Level
import org.apache.log4j.Logger
String sqlStmt = "select issuenum,project from jiraissue where project in ($projectsIds) AND issuetype NOT in ('15','16') AND issuestatus != '6' AND updated < '" + sevenDaysBeforeString + "' ORDER BY project,issuenum ASC"
DefaultOfBizConnectionFactory factory = new DefaultOfBizConnectionFactory();
Sql sql = new Sql(factory.getConnection())
ArrayList<Issue> list = new ArrayList()
sql.eachRow(sqlStmt) {
MutableIssue issue = issueManager.getIssueObject("${projectIdList[it.project.toString()]}-${it.issuenum.toString()}")
def days = now - issue.updated
if(days % 7 == 0) list.add(issue)
}
if(list.size() == 0){
writeOut("No issue hit.")
runFile.write(now.format("yyyy/MM/dd HH:mm:ss"))
return
}
********
"it.project.toString()" and "it.issuenum.toString()" is not work.
"No such property:project for class:groovy.sql.GroovyResultSet" error massage
It work in script runner version 3.1.4
Best Regards,
