Using database schema name before table name in ScriptRunner Query

[Abdul]

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.