import groovy.sql.Sql;
import java.sql.Driver;

def driver = Class.forName('org.postgresql.Driver').newInstance() as Driver;
def props = new Properties();
    props.setProperty("user", "jira_ssc-vrn");
    props.setProperty("password", "Zp82qNLfAr45");
def conn = driver.connect("jdbc:postgresql://localhost:5432/jira_ssc-vrn", props);
def sql = new Sql(conn);
try{
   sql.rows("""
        SELECT "ISSUEID", "SLACUSTOMFIELDID", issuenum, summary FROM "AO_4AED16_TSLAISSUEATTRS", jiraissue
        where jiraissue.id = "ISSUEID" group by "ISSUEID", "SLACUSTOMFIELDID", issuenum, summary having count(*) > 1 order by "ISSUEID" desc;
    """)
    //sql.rows("SELECT \"TIMESPENT\" FROM \"AO_4AED16_TSLAISSUEATTRS\" where \"ISSUEID\"='193412' and \"SLACUSTOMFIELDID\"=\'customfield_10557\'");
}finally{
    sql.close()
    conn.close()
}