Issuing SQL using groovy runner

[Takashi Hattori]

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,