Database channel between specific hours - rbeckman-nextgen/test-mc GitHub Wiki
Created by Jacob Brauer, last modified on Mar 23, 2009
var vSQL = " select rownum as nomfit, ";
vSQL = vSQL + " visi_centre_codi_centre as centre, ";
vSQL = vSQL + "...";
var result=""
var Hora=DateUtil.getCurrentDate('HH');
if (Hora>="10" && Hora <="12")
{
var dbConn = DatabaseConnectionFactory.createDatabaseConnection('oracle.jdbc.OracleDriver','jdbc:oracle:thin:@10.80.217.40:1521:orac','RADHTR','xxxxxx');
result = dbConn.executeCachedQuery(vSQL);
dbConn.close();
// YOUR CODE GOES HERE
// You may access this result with $('column_name')
return result;
}
else
{
return false;
}
Credit goes to Nonoy
See post:
http://www.mirthproject.org/community/forums/showthread.php?t=1926
Document generated by Confluence on Nov 11, 2019 08:40