Package quadbase.scheduler
Class ScheduleObject
java.lang.Object
quadbase.scheduler.ScheduleObject
- All Implemented Interfaces:
Serializable
Represent a schedule task to be performed by the scheduler. A typical use of this class involves
the following:
// first connect to Espress Manager
ScheduleModifier.connectServer(null);
// allocate the ScheduleObject
ScheduleObject sObj = new ScheduleObject("SCH_OBJ1", ScheduleObject.REPORTOBJ);
// set the desired settings for this schedule task
sObj.setFileLocation("Templates/SAMPLE.rpt");
String exportLoc = sObj.pickDefaultExportLocation(); *
sObj.setReportType(IExportConstants.DHTML);
sObj.setTaskOption(ScheduleObject.ONE_TIME);
Calendar calendar = Calendar.getInstance();
calendar.add(Calendar.MINUTE, 5);
sObj.setStartDate(calendar.getTimeInMillis());
sObj.setSendEmail(false);
// add the task (ScheduleObject) to the scheduler
ScheduleModifier.addScheduleTask(sObj);
- See Also:
-
Field Summary
FieldsModifier and TypeFieldDescriptionstatic intstatic final intOne of the constants returned by the method getEmailType() that specifies an email type.static final intOne of the constants returned by the method getEmailType() that specifies an email type.static final intOne of the constants returned by the method getEmailType() that specifies an email type.static final intinternal use onlystatic final intOne of the constants that specifies a type of schedule jobstatic final intOne of the constants returned by the method getIntervalType() that specifies export time interval.static final intOne of the constants returned by the method getTaskOption() that specifies a type of task.static intstatic final intOne of the constants returned by the method getIntervalType() that specifies export time interval.static intstatic final intOne of the constants returned by the method getTaskOption() that specifies a type of task.protected intstatic final intinternal use onlystatic final intinternal use onlystatic final intinternal use onlystatic final intinternal use onlystatic final intstatic final intOne of the constants that specifies a type of schedule jobstatic final intOne of the constants returned by the method getIntervalType() that specifies export time interval.static final intOne of the constants returned by the method getTaskOption() that specifies a type of task.static final String[]internal use only -
Constructor Summary
ConstructorsConstructorDescriptionScheduleObject(String name) internal use onlyScheduleObject(String name, boolean isChartObject) internal use onlyScheduleObject(String name, int type) Creates ScheduleObject by providing schedule name and object typeinternal use only -
Method Summary
Modifier and TypeMethodDescriptionstatic quadbase.reportdesigner.report.ReportcreateReport(String urlPath, String filePath) internal use onlybooleanremove schedule job from the queuebooleandeleteJobPermanently(long curTime) booleanequals(ScheduleObject obj) internal use onlybooleanexportNow(long curTime) internal use onlyFor Email feature: Returns the body text of the emailinternal use onlyintreturns what type of bursting has been applied (Burst All or Burst Group)internal use onlyReturns schedule commandintIf task option is TIME_INTERVAL: Returns day interval in daysintreturns the column index whose data provides the email addresses to send the exported reports tointFor Email feature: Returns email type: ASATTACHMENT/ ASLINK/ ASHTMLlongIf task option is TIME_INTERVAL / FIXEDDAYS: if endDate = -1, it runs indefinitely Returns end date for scheduled eventintIf task option is FIXEDDAYS Returns end time (in minutes) for scheduled event.Returns export file locationlonginternal use onlyintinternal use onlyFor DHTML export: Returns the external style sheet file used for DHTML export.For Fail Job Email feature: returns the body text of the emailFor Fail Job Email feature: returns the subject of the emailFor Fail Job Email feature: returns recievers' email addressesReturns report file locationFor Email feature: Returns sender email addressinternal use onlyintgetID()internal use onlyintinternal use onlyintinternal use onlyintIf task option is TIME_INTERVAL: Returns export time interval: TIME/ DAYS/ MONTHSintinternal use onlyintIf task option is TIME_INTERVAL: Returns month interval in monthsgetName()Returns schedule job nameintFor TXT export: Returns the newline delimiter: IDelimiterConstants.WINDOWS_NEWLINE, IDelimiterConstants.MAC_NEWLINE, IDelimiterConstants.OTHERS_NEWLINE...intgetNextExportDay(int curDay, int[] specifyDays) internal use onlylongReturns next export time in millisecondsintinternal use onlyFor Param report/ chart Email feature: get hashtable for param set name (key), and email addresses (value) for example, "Param Set 1", new String[]{"peterL@quadbase.com", "HenryP@quadbase.com"}Returns all the parameter set that have been defined for a schedule job that using param report.For PDF export: Returns the PDF owner passwordFor PDF export: Returns the PDF user passwordintinternal use onlyintIf it's a drilldown report, user has to enter port number for viewing sub-level report.internal use onlyintReturns exported report type: IExportConstants.PDF, IExportConstants.DHTML, IExportConstants.HTML...Returns the report security level.If it's a drilldown report, user has to enter server name for viewing sub-level report.If it's a drilldown report, user has to enter servlet directory for viewing sub-level report.int[]If task option is FIXEDDAYS: Returns export file dates.int[]If task option is FIXEDDAYS: Returns export file daysint[]If task option is FIXEDDAYS: Returns export file time (in minutes)longReturns start date for scheduled event in POSIX time.intIf task option is FIXEDDAYS Returns start time (in minutes) for scheduled event.For Email feature: Returns the subject of the emailintReturns task option:
ONE_TIME - export once
TIME_INTERVAL - export report after certain time interval
FIXEDDAYS - only export report in certain fixed days/ datesintFor TXT and CSV export: Returns the text delimiter: IDelimiterConstants.TAB, IDelimiterConstants.SPACE, IDelimiterConstants.COMMA...intIf task option is TIME_INTERVAL: Returns time interval in minsString[]For Email feature: Returns receivers' email addressesFor Email feature: If you elect to send a link to the generated report, you will need to specify an http path to the directory in which the report is generated.internal use onlybooleanisChart()internal use onlybooleanReturns whether it is schedule command objectbooleanFor PDF export: Returns whether use encoding for DFT exportbooleanisExportDay(int curDay, int[] specifyDays) internal use onlybooleanDHTML/ HTML option: Returns whether export report to multi-pagesbooleanFor DHTML/ HTML export: Exports return in one single page with pagination.booleaninternal use onlybooleanbooleanPDF / DHTML / HTML / CSV / TXT option: Returns whether using optimize memory exportbooleanisReport()Returns whether it is schedule report objectstatic booleaninternal use onlybooleanFor Email feature: Returns whether email notification/delivery is used for the exported reportbooleanThis method will attach timestamp at the end of a file name in order to create new file everytime (instead of overwriting the file) It's useful feature for TIME_INTERVAL / FIXED_DAYS Returns whether attaching timestamp at the end of a file namebooleanFor DHTML export: Returns whether use external style sheet for DHTML exportbooleanShould HTTPS protocol be used for drill-down links (in PDF or DHTML format)?booleanFor DHTML export: Returns whether use internal style sheet for DHTML exportscheduler will pick default export file location Returns chosen file locationvoidprint()internal use onlystatic ScheduleObjectinternal use onlystatic ScheduleObjectreadComplete(DataInput orgIn, int version) internal use onlyvoidinternal use onlyvoidsetBodyText(String bodyText) For Email feature: specifies the body text of the emailvoidsetBurstEmail(Hashtable table) internal use onlyvoidsetBurstReport(int i) sets the type of bursting to be applied (QbScheduleObject.ALLBURSTING or QbScheduleObject.GROUPBURSTING)voidsetChart(boolean b) internal use onlyvoidsetChartLocation(String loc) internal use onlyvoidsetCommand(String cmd) Specifies schedule commandvoidsetDayInterval(int dayInt) if task option is TIME_INTERVAL: specifies day interval in minsvoidinternal use onlyvoidsetEmailColumnIndex(int i) sets the column index whose data provides the email addresses to send the exported reports tovoidsetEmailType(int type) For Email feature: specifies email type: ASATTACHMENT/ ASLINK/ ASHTMLvoidsetEncodePDF(boolean b) For PDF export: specifies whether use encoding for DFT exportvoidsetEndDate(long eDate) if task option is TIME_INTERVAL / FIXEDDAYS: if endDate = -1, it runs indefinitely specifies end date in millis second for scheduled eventvoidsetEndTime(int edTime) if task option is FIXEDDAYS: specifies end time for daily frequency featurevoidsetExportLocation(String loc) specifies export file locationvoidsetExportTime(long time) internal use onlyvoidsetExportToMultiPages(boolean b) DHTML/ HTML option: specifies whether export report to multi-pagesvoidsetExportToSingleWPagination(boolean b) For DHTML/ HTML export: export return in one single page with pagination specifies state of exporting report to single page with paginationvoidFor DHTML export: Specifies the external style sheet file used for DHTML exportvoidsetFailBodyText(String bodyTextFail) For Fail Job Email feature: returns the body text of the emailvoidsetFailSubject(String subjectFail) For Fail Job Email feature: returns the subject of the emailvoidsetFailToAddress(String toAddressFail) For Fail Job Email feature: returns recievers' email addressesvoidsetFileLocation(String loc) specifies report file locationvoidsetFromAddress(String from) For Email feature: specifies sender email addressvoidsetGIFTransparent(boolean b) internal use onlyvoidsetID(int id) internal use onlyvoidsetImageHeight(int h) internal use onlyvoidsetImageWidth(int w) internal use onlyvoidsetIntervalType(int type) if task option is TIME_INTERVAL: specifies export time interval: TIME/ DAYS/ MONTHSvoidsetJPEGQuality(int qual) internal use onlyvoidsetLastExportFile(String str) internal use onlyvoidsetLimitExcelCellSplit(boolean limitExcelCellSplit) voidsetMemoryOptimized(boolean b) report export option: specifies whether using optimize memory exportvoidsetMonthInterval(int monInt) if task option is TIME_INTERVAL: specifies month interval in minsvoidSpecifies schedule job namevoidsetNewLineDelimiter(int i) For TXT export: specifies the newline delimiter: IDelimiterConstants.WINDOWS_NEWLINE, IDelimiterConstants.MAC_NEWLINE, IDelimiterConstants.OTHERS_NEWLINE...voidsetPackageID(int packageID) internal use onlyvoidsetParamAddresses(Hashtable table) For Param report/ chart Email feature: create hashtable for param set name (key), and email addresses (value) for example, "Param Set 1", new String[]{"peterL@quadbase.com", "HenryP@quadbase.com"}voidsetParamList(Vector paramList) Specifies all the parameter set that have been defined for a schedule job that using param report.voidsetParamList(Vector paramListName, Vector paramList) specifies all the parameter set that have been defined for a schedule job that using param report.voidFor PDF export: specifies the PDF owner passwordvoidFor PDF export: specifies the PDF user passwordvoidsetPNGCompression(int c) internal use onlyvoidsetPortNumber(int pn) If it's a drilldown report, user has to enter port number for viewing sub-level report specifies port numbervoidsetReportLocation(String loc) internal use onlyvoidsetReportType(int type) Specifies exported report type: IExportConstants.PDF, IExportConstants.DHTML, IExportConstants.HTML...static voidsetRunMissedJob(boolean b) internal use onlyvoidspecifies the report security level If no security level is going to apply to the report, use a null stringvoidsetSendEmail(boolean state) For Email feature: specifies whether email notification/delivery is used for the exported reportvoidsetServerName(String sn) If it's a drilldown report, user has to enter server name for viewing sub-level report specifies server namevoidIf it's a drilldown report, user has to enter servlet directory for viewing sub-level report specifies servlet directoryvoidsetSpecifyDates(int[] dates) if task option is FIXEDDAYS: Specifies export file dates.voidsetSpecifyDays(int[] days) if task option is FIXEDDAYS: specifies export file daysvoidsetSpecifyTime(int[] time) if task option is FIXEDDAYS: specifies export file timevoidsetStartDate(long sDate) specifies start date for scheduled eventvoidsetStartTime(int stTime) if task option is FIXEDDAYS: specifies start time for daily frequency featurevoidsetSubject(String subject) For Email feature: specifies the subject of the emailvoidsetTaskOption(int opt) specifies task option: ONE_TIME - export once TIME_INTERVAL - export report after certain time interval FIXEDDAYS - only export report in certain fixed days/ datesvoidsetTextDelimiter(int i) For TXT and CSV export: specifies the text delimiter: IDelimiterConstants.TAB, IDelimiterConstants.SPACE, IDelimiterConstants.COMMA...voidsetTimeInterval(int timeInt) if task option is TIME_INTERVAL: specifies time interval in minsvoidsetTimestampAttached(boolean attach) This method will attach timestamp at the end of a file name in order to create new file everytime (instead of overwriting the file).voidsetToAddresses(String[] to) For Email feature: specifies receivers' email addressesvoidsetURLMapping(String urlMapping) For Email feature: If you elect to send a link to the generated report, you will need to specify an http path to the directory in which the report is generated.voidsetUseExternalStyleSheet(boolean b) For DHTML export: specifies whether use external style sheet for DHTML exportvoidsetUseHTTPS(boolean useHTTPS) Should HTTPS protocol be used for drill-down links (in PDF or DHTML format)? True for HTTPS, false for HTTPvoidsetUseInternalStyleSheet(boolean b) For DHTML export: specifies whether use internal style sheet for DHTML exportvoidsetUserName(String name) internal use onlybooleanvoidwrite(DataOutput orgOut) internal use onlyvoidwriteComplete(DataOutput orgOut) internal use only
-
Field Details
-
CHARTOBJ
public static final int CHARTOBJinternal use only- See Also:
-
REPORTOBJ
public static final int REPORTOBJOne of the constants that specifies a type of schedule job- See Also:
-
COMMANDOBJ
public static final int COMMANDOBJOne of the constants that specifies a type of schedule job- See Also:
-
PNG_COMPRESSSION_DEFAULT
public static final int PNG_COMPRESSSION_DEFAULTinternal use only- See Also:
-
PNG_COMPRESSSION_FAST
public static final int PNG_COMPRESSSION_FASTinternal use only- See Also:
-
PNG_COMPRESSSION_MAX
public static final int PNG_COMPRESSSION_MAXinternal use only- See Also:
-
PNG_COMPRESSSION_NONE
public static final int PNG_COMPRESSSION_NONEinternal use only- See Also:
-
removeScheduleIconInterval
public static final int removeScheduleIconInterval- See Also:
-
ASATTACHMENT
public static final int ASATTACHMENTOne of the constants returned by the method getEmailType() that specifies an email type.- See Also:
-
ASLINK
public static final int ASLINKOne of the constants returned by the method getEmailType() that specifies an email type.- See Also:
-
ASHTML
public static final int ASHTMLOne of the constants returned by the method getEmailType() that specifies an email type.- See Also:
-
ONE_TIME
public static final int ONE_TIMEOne of the constants returned by the method getTaskOption() that specifies a type of task.- See Also:
-
TIME_INTERVAL
public static final int TIME_INTERVALOne of the constants returned by the method getTaskOption() that specifies a type of task.- See Also:
-
FIXED_DAYS
public static final int FIXED_DAYSOne of the constants returned by the method getTaskOption() that specifies a type of task.- See Also:
-
TYPE
internal use only -
TIME
public static final int TIMEOne of the constants returned by the method getIntervalType() that specifies export time interval.- See Also:
-
DAYS
public static final int DAYSOne of the constants returned by the method getIntervalType() that specifies export time interval.- See Also:
-
MONTHS
public static final int MONTHSOne of the constants returned by the method getIntervalType() that specifies export time interval.- See Also:
-
NOBURSTING
public static int NOBURSTING -
GROUPBURSTING
public static int GROUPBURSTING -
ALLBURSTING
public static int ALLBURSTING -
packageID
protected int packageID
-
-
Constructor Details
-
ScheduleObject
internal use only -
ScheduleObject
internal use only -
ScheduleObject
internal use only -
ScheduleObject
Creates ScheduleObject by providing schedule name and object type- Parameters:
name- schedule job nametype- object type: REPORTOBJ / COMMANDOBJ
-
-
Method Details
-
isRunMissedJob
public static boolean isRunMissedJob()internal use only -
setRunMissedJob
public static void setRunMissedJob(boolean b) internal use only -
createReport
internal use only -
read
internal use only- Throws:
Exception
-
readComplete
internal use only- Throws:
Exception
-
print
public void print()internal use only -
isChart
public boolean isChart()internal use only -
setChart
public void setChart(boolean b) internal use only -
isReport
public boolean isReport()Returns whether it is schedule report object -
isCommand
public boolean isCommand()Returns whether it is schedule command object -
getName
Returns schedule job name -
setName
Specifies schedule job name -
getID
public int getID()internal use only -
setID
public void setID(int id) internal use only -
getPackageID
public int getPackageID()internal use only -
setPackageID
public void setPackageID(int packageID) internal use only -
getFullID
internal use only -
getReportType
public int getReportType()Returns exported report type: IExportConstants.PDF, IExportConstants.DHTML, IExportConstants.HTML...- See Also:
-
setReportType
public void setReportType(int type) Specifies exported report type: IExportConstants.PDF, IExportConstants.DHTML, IExportConstants.HTML...- See Also:
-
getExportType
public int getExportType()internal use only -
getJPEGQuality
public int getJPEGQuality()internal use only -
setJPEGQuality
public void setJPEGQuality(int qual) internal use only -
isGIFTransparent
public boolean isGIFTransparent()internal use only -
setGIFTransparent
public void setGIFTransparent(boolean b) internal use only -
getPNGCompression
public int getPNGCompression()internal use only -
setPNGCompression
public void setPNGCompression(int c) internal use only -
getImageWidth
public int getImageWidth()internal use only -
setImageWidth
public void setImageWidth(int w) internal use only -
getImageHeight
public int getImageHeight()internal use only -
setImageHeight
public void setImageHeight(int h) internal use only -
getFileLocation
Returns report file location -
setFileLocation
specifies report file location -
getChartLocation
internal use only -
setChartLocation
internal use only -
getReportLocation
internal use only -
setReportLocation
internal use only -
getExportLocation
Returns export file location -
setExportLocation
specifies export file location -
getCommand
Returns schedule command -
setCommand
Specifies schedule command -
getTaskOption
public int getTaskOption()Returns task option:
ONE_TIME - export once
TIME_INTERVAL - export report after certain time interval
FIXEDDAYS - only export report in certain fixed days/ dates -
setTaskOption
public void setTaskOption(int opt) specifies task option: ONE_TIME - export once TIME_INTERVAL - export report after certain time interval FIXEDDAYS - only export report in certain fixed days/ dates -
getSpecifyDates
public int[] getSpecifyDates()If task option is FIXEDDAYS: Returns export file dates. The dates are in the format of integers representing the dates of the month.
For example, {1,10,20} would run on the 1st, 10th, and 20th of the month. -
setSpecifyDates
public void setSpecifyDates(int[] dates) if task option is FIXEDDAYS: Specifies export file dates. The dates are in the format of integers representing the dates of the month.
For example, {1,10,20} would run on the 1st, 10th, and 20th of the month. -
getSpecifyDays
public int[] getSpecifyDays()If task option is FIXEDDAYS: Returns export file days -
setSpecifyDays
public void setSpecifyDays(int[] days) if task option is FIXEDDAYS: specifies export file days -
getSpecifyTime
public int[] getSpecifyTime()If task option is FIXEDDAYS: Returns export file time (in minutes) -
setSpecifyTime
public void setSpecifyTime(int[] time) if task option is FIXEDDAYS: specifies export file time -
getStartDate
public long getStartDate()Returns start date for scheduled event in POSIX time. -
setStartDate
public void setStartDate(long sDate) specifies start date for scheduled event -
getEndDate
public long getEndDate()If task option is TIME_INTERVAL / FIXEDDAYS: if endDate = -1, it runs indefinitely Returns end date for scheduled event -
setEndDate
public void setEndDate(long eDate) if task option is TIME_INTERVAL / FIXEDDAYS: if endDate = -1, it runs indefinitely specifies end date in millis second for scheduled event -
getIntervalType
public int getIntervalType()If task option is TIME_INTERVAL: Returns export time interval: TIME/ DAYS/ MONTHS -
setIntervalType
public void setIntervalType(int type) if task option is TIME_INTERVAL: specifies export time interval: TIME/ DAYS/ MONTHS -
getStartTime
public int getStartTime()If task option is FIXEDDAYS Returns start time (in minutes) for scheduled event. -
setStartTime
public void setStartTime(int stTime) if task option is FIXEDDAYS: specifies start time for daily frequency feature -
getEndTime
public int getEndTime()If task option is FIXEDDAYS Returns end time (in minutes) for scheduled event. -
setEndTime
public void setEndTime(int edTime) if task option is FIXEDDAYS: specifies end time for daily frequency feature -
getTimeInterval
public int getTimeInterval()If task option is TIME_INTERVAL: Returns time interval in mins -
setTimeInterval
public void setTimeInterval(int timeInt) if task option is TIME_INTERVAL: specifies time interval in mins -
getMonthInterval
public int getMonthInterval()If task option is TIME_INTERVAL: Returns month interval in months -
setMonthInterval
public void setMonthInterval(int monInt) if task option is TIME_INTERVAL: specifies month interval in mins -
getDayInterval
public int getDayInterval()If task option is TIME_INTERVAL: Returns day interval in days -
setDayInterval
public void setDayInterval(int dayInt) if task option is TIME_INTERVAL: specifies day interval in mins -
getUserName
internal use only -
setUserName
internal use only -
getBurstReport
public int getBurstReport()returns what type of bursting has been applied (Burst All or Burst Group) -
setBurstReport
public void setBurstReport(int i) sets the type of bursting to be applied (QbScheduleObject.ALLBURSTING or QbScheduleObject.GROUPBURSTING) -
isExportToMultiPages
public boolean isExportToMultiPages()DHTML/ HTML option: Returns whether export report to multi-pages -
setExportToMultiPages
public void setExportToMultiPages(boolean b) DHTML/ HTML option: specifies whether export report to multi-pages -
isMemoryOptimized
public boolean isMemoryOptimized()PDF / DHTML / HTML / CSV / TXT option: Returns whether using optimize memory export -
setMemoryOptimized
public void setMemoryOptimized(boolean b) report export option: specifies whether using optimize memory export -
getParamList
Returns all the parameter set that have been defined for a schedule job that using param report. Each element of Vector is an Object[] which contains the query/formula parameter value. For example,
If report contains 3 parameters: STATE(String), DRINK(String - MULTI-PARAM), QUANTITY (Integer)
And there's 2 parameter set:
[CA], [Coffee, Water], 50
[NY], [Juice, Soda, Tea], 100The param list should be:
Vector set0_Param1 = new Vector();
set0_Param1.addELement("Coffee");
set0_Param1.addELement("Water");
Object[] set0 = new Object[]{"CA", set0_Param1, Integer.valueOf(50)};
Vector set1_Param1 = new Vector();
set1_Param1.addELement("Juice");
set1_Param1.addELement("Soda");
set1_Param1.addELement("Tea");
Object[] set1 = new Object[]{"NY", set1_Param1, Integer.valueOf(100)};
Vector paramList = new Vector();
paramList.addElement(set0);
paramList.addElement(set1); -
setParamList
Specifies all the parameter set that have been defined for a schedule job that using param report. Each element of Vector is an Object[] which contains the query/formula parameter value.For example, if report contains 3 parameters: STATE(String), DRINK(String - MULTI-PARAM), QUANTITY (Integer) And there's 2 parameter set: [CA], [Coffee, Water], 50 [NY], [Juice, Soda, Tea], 100 The param list should be: Vector set0_Param1 = new Vector(); set0_Param1.addELement("Coffee"); set0_Param1.addELement("Water"); Object[] set0 = new Object[]{"CA", set0_Param1, Integer.valueOf(50)}; Vector set1_Param1 = new Vector(); set1_Param1.addELement("Juice"); set1_Param1.addELement("Soda"); set1_Param1.addELement("Tea"); Object[] set1 = new Object[]{"NY", set1_Param1, Integer.valueOf(100)}; Vector paramList = new Vector(); paramList.addElement(set0); paramList.addElement(set1);- Parameters:
paramList- a list of parameter values according to the above structure. Pass in null to "Select All" possible values if and only if the parameters have been set to map to a database column.
-
isSendEmail
public boolean isSendEmail()For Email feature: Returns whether email notification/delivery is used for the exported report -
setSendEmail
public void setSendEmail(boolean state) For Email feature: specifies whether email notification/delivery is used for the exported report -
getFromAddress
For Email feature: Returns sender email address -
setFromAddress
For Email feature: specifies sender email address -
getToAddresses
For Email feature: Returns receivers' email addresses -
setToAddresses
For Email feature: specifies receivers' email addresses -
getSubject
For Email feature: Returns the subject of the email -
setSubject
For Email feature: specifies the subject of the email -
getBodyText
For Email feature: Returns the body text of the email -
setBodyText
For Email feature: specifies the body text of the email -
getFailSubject
For Fail Job Email feature: returns the subject of the email -
setFailSubject
For Fail Job Email feature: returns the subject of the email -
getFailBodyText
For Fail Job Email feature: returns the body text of the email -
setFailBodyText
For Fail Job Email feature: returns the body text of the email -
getFailToAddress
For Fail Job Email feature: returns recievers' email addresses -
setFailToAddress
For Fail Job Email feature: returns recievers' email addresses -
getEmailType
public int getEmailType()For Email feature: Returns email type: ASATTACHMENT/ ASLINK/ ASHTML -
setEmailType
public void setEmailType(int type) For Email feature: specifies email type: ASATTACHMENT/ ASLINK/ ASHTML -
getURLMapping
For Email feature: If you elect to send a link to the generated report, you will need to specify an http path to the directory in which the report is generated. Otherwise, the link will not form correctly. Returns the url mapping -
setURLMapping
For Email feature: If you elect to send a link to the generated report, you will need to specify an http path to the directory in which the report is generated. Otherwise, the link will not form correctly. specifies the url mapping -
getSecurityLevel
Returns the report security level. If no security level is going to apply to the report, it'll returns null -
setSecurityLevel
specifies the report security level If no security level is going to apply to the report, use a null string -
getServerName
If it's a drilldown report, user has to enter server name for viewing sub-level report. Returns server name -
setServerName
If it's a drilldown report, user has to enter server name for viewing sub-level report specifies server name -
getPortNumber
public int getPortNumber()If it's a drilldown report, user has to enter port number for viewing sub-level report. Returns port number -
setPortNumber
public void setPortNumber(int pn) If it's a drilldown report, user has to enter port number for viewing sub-level report specifies port number -
getServletDirectory
If it's a drilldown report, user has to enter servlet directory for viewing sub-level report. Returns servlet directory -
setServletDirectory
If it's a drilldown report, user has to enter servlet directory for viewing sub-level report specifies servlet directory -
isUseHTTPS
public boolean isUseHTTPS()Should HTTPS protocol be used for drill-down links (in PDF or DHTML format)?- Returns:
- True for HTTPS, false for HTTP
-
setUseHTTPS
public void setUseHTTPS(boolean useHTTPS) Should HTTPS protocol be used for drill-down links (in PDF or DHTML format)? True for HTTPS, false for HTTP -
isExportToSingleWPagination
public boolean isExportToSingleWPagination()For DHTML/ HTML export: Exports return in one single page with pagination. Returns state of exporting report to single page with pagination. -
setExportToSingleWPagination
public void setExportToSingleWPagination(boolean b) For DHTML/ HTML export: export return in one single page with pagination specifies state of exporting report to single page with pagination -
isUseInternalStyleSheet
public boolean isUseInternalStyleSheet()For DHTML export: Returns whether use internal style sheet for DHTML export -
setUseInternalStyleSheet
public void setUseInternalStyleSheet(boolean b) For DHTML export: specifies whether use internal style sheet for DHTML export -
isUseExternalStyleSheet
public boolean isUseExternalStyleSheet()For DHTML export: Returns whether use external style sheet for DHTML export -
setUseExternalStyleSheet
public void setUseExternalStyleSheet(boolean b) For DHTML export: specifies whether use external style sheet for DHTML export -
getExternalStyleSheetName
For DHTML export: Returns the external style sheet file used for DHTML export. Returns the name of the external style sheet -
setExternalStyleSheetName
For DHTML export: Specifies the external style sheet file used for DHTML export- Parameters:
s- the name of the external style sheet
-
isEncodePDF
public boolean isEncodePDF()For PDF export: Returns whether use encoding for DFT export -
setEncodePDF
public void setEncodePDF(boolean b) For PDF export: specifies whether use encoding for DFT export -
getPDFUserPassword
For PDF export: Returns the PDF user password -
setPDFUserPassword
For PDF export: specifies the PDF user password -
getPDFOwnerPassword
For PDF export: Returns the PDF owner password -
setPDFOwnerPassword
For PDF export: specifies the PDF owner password -
getTextDelimiter
public int getTextDelimiter()For TXT and CSV export: Returns the text delimiter: IDelimiterConstants.TAB, IDelimiterConstants.SPACE, IDelimiterConstants.COMMA...- See Also:
-
setTextDelimiter
public void setTextDelimiter(int i) For TXT and CSV export: specifies the text delimiter: IDelimiterConstants.TAB, IDelimiterConstants.SPACE, IDelimiterConstants.COMMA...- See Also:
-
getNewLineDelimiter
public int getNewLineDelimiter()For TXT export: Returns the newline delimiter: IDelimiterConstants.WINDOWS_NEWLINE, IDelimiterConstants.MAC_NEWLINE, IDelimiterConstants.OTHERS_NEWLINE...- See Also:
-
setNewLineDelimiter
public void setNewLineDelimiter(int i) For TXT export: specifies the newline delimiter: IDelimiterConstants.WINDOWS_NEWLINE, IDelimiterConstants.MAC_NEWLINE, IDelimiterConstants.OTHERS_NEWLINE...- See Also:
-
isTimestampAttached
public boolean isTimestampAttached()This method will attach timestamp at the end of a file name in order to create new file everytime (instead of overwriting the file) It's useful feature for TIME_INTERVAL / FIXED_DAYS Returns whether attaching timestamp at the end of a file name -
setTimestampAttached
public void setTimestampAttached(boolean attach) This method will attach timestamp at the end of a file name in order to create new file everytime (instead of overwriting the file). It's useful feature for TIME_INTERVAL / FIXED_DAYS specifies attaching timestamp at the end of a file name -
getParamAddresses
For Param report/ chart Email feature: get hashtable for param set name (key), and email addresses (value) for example, "Param Set 1", new String[]{"peterL@quadbase.com", "HenryP@quadbase.com"} -
setParamAddresses
For Param report/ chart Email feature: create hashtable for param set name (key), and email addresses (value) for example, "Param Set 1", new String[]{"peterL@quadbase.com", "HenryP@quadbase.com"} -
getBurstEmail
internal use only -
setBurstEmail
internal use only -
getEmailColumnIndex
public int getEmailColumnIndex()returns the column index whose data provides the email addresses to send the exported reports to -
setEmailColumnIndex
public void setEmailColumnIndex(int i) sets the column index whose data provides the email addresses to send the exported reports to -
pickDefaultExportLocation
scheduler will pick default export file location Returns chosen file location- Throws:
Exception
-
setParamList
specifies all the parameter set that have been defined for a schedule job that using param report. Each element of Vector is an Object[] which contains the query/formula parameter value. For example, if report contains 3 parameters: STATE(String), DRINK(String - MULTI-PARAM), QUANTITY (Integer) And there's 2 parameter set: [CA], [Coffee, Water], 50 [NY], [Juice, Soda, Tea], 100 The param list should be: Vector set0_Param1 = new Vector(); set0_Param1.addELement("Coffee"); set0_Param1.addELement("Water"); Object[] set0 = new Object[]{"CA", set0_Param1, Integer.valueOf(50)}; Vector set1_Param1 = new Vector(); set1_Param1.addELement("Juice"); set1_Param1.addELement("Soda"); set1_Param1.addELement("Tea"); Object[] set1 = new Object[]{"NY", set1_Param1, Integer.valueOf(100)}; Vector paramList = new Vector(); paramList.addElement(set0); paramList.addElement(set1);- Parameters:
paramList- a list of parameter values according to the above structure. Pass in null to "Select All" possible values if and only if the parameters have been set to map to a database column.
-
setLastExportFile
internal use only -
setDeleted
public void setDeleted()internal use only -
getExportTime
public long getExportTime()internal use only -
setExportTime
public void setExportTime(long time) internal use only -
resetExportTime
public void resetExportTime()internal use only -
getNextExportTime
public long getNextExportTime()Returns next export time in milliseconds -
exportNow
public boolean exportNow(long curTime) internal use only -
deleteJob
public boolean deleteJob()remove schedule job from the queue -
deleteJobPermanently
public boolean deleteJobPermanently(long curTime) -
updateTime
public boolean updateTime() -
isExportDay
public boolean isExportDay(int curDay, int[] specifyDays) internal use only -
getNextExportDay
public int getNextExportDay(int curDay, int[] specifyDays) internal use only -
equals
internal use only -
write
internal use only- Throws:
Exception
-
writeComplete
internal use only- Throws:
Exception
-
isLimitExcelCellSplit
public boolean isLimitExcelCellSplit() -
setLimitExcelCellSplit
public void setLimitExcelCellSplit(boolean limitExcelCellSplit)
-