Hi All,
In all environment I have set the ScriptRunner resource as "local".
I am using following query in ScriptRunner script as follows:
DatabaseUtil.withSql('local') { sql ->
def row = sql.firstRow('select top 1 mc.SUBJECT, EML_PATH from jiraissue ji, project p, AO_89A25E_MAIL_COMM mc where p.id=ji.project and mc.issue_id=ji.id and CONCAT(P.PKEY, \'-\', ji.ISSUENUM)=? order by mc.DATE_SENT desc', issue.key)
if (row) {
subject = row. 'SUBJECT'}
}
The above SQL query works fine in DEV environment. However, this query throws an error in production environment.
To make this work in production, I had to add "JIRAISSUE." a schema name in front of the table name as below, however this will not work in DEV environment.
select top 1 mc.SUBJECT, EML_PATH from JIRAISSUE.jiraissue ji, JIRAISSUE.project p, JIRAISSUE.AO_89A25E_MAIL_COMM mc where p.id=ji.project and mc.issue_id=ji.id and CONCAT(P.PKEY, \'-\', ji.ISSUENUM)=? order by mc.DATE_SENT desc'
My Question is:
Is there a way where I can configure the database schema so that I need not put the schema name in query.
May I request the experts to advise how do I remove this schema name inconsistencies between environments.
Thanking in advance.