project BLF > class BReportRequestBase > business logic query RptRequestBySchedule


Parameters


iiRptRequestScheduleIdinteger


query condition


  each RptRequest where
RptRequest.RptRequestSchedule_ID = iiRptRequestScheduleId

      first RptPrinter (outer-join) where
RptPrinter.RptPrinter_ID = RptRequest.RptPrinter_ID AND

      each RptRequestMail (outer-join) where
RptRequestMail.RptRequest_ID = RptRequest.RptRequest_ID AND

          first Role (outer-join) where
Role.Role_ID = RptRequestMail.Role_ID AND


query resultset tqRptRequestBySchedule


field namedata typedb fielddescription
tcRoleNamecharacterRole.RoleNameRole Name
tcRptPrinterNamecharacterRptPrinter.RptPrinterNamePrinter Name
tcRptRequestMailBCCcharacterRptRequest.RptRequestMailBCCComma separated list of mail addresses to which the result needs to be sent (as BCC) in a mail attachment.
tcRptRequestMailBodycharacterRptRequest.RptRequestMailBodyThe text that need to be in the body of the mail to be sent.
tcRptRequestMailCCcharacterRptRequest.RptRequestMailCCComma separated list of mail addresses to which the result needs to be sent (as CC) in a mail attachment.
tcRptRequestMailSubjectcharacterRptRequest.RptRequestMailSubjectThe text that need to be in the subject of the mail to be sent.
tcRptRequestMailTocharacterRptRequest.RptRequestMailToComma separated list of mail addresses to which the result needs to be sent (as TO) in a mail attachment.
tcRptRequestMailTypecharacterRptRequestMail.RptRequestMailTypepossible values:
TO
CC
BCC
tcRptRequestOutputFormatcharacterRptRequest.RptRequestOutputFormatType of document to create when writing the report output to the file system.
possible values:
DOC
PDF
RPT
RTF
XLS
tcRptRequestSaveFileNamecharacterRptRequest.RptRequestSaveFileNameThe name of the file that needs to be saved for the result of the report execution.
tcRptRequestSaveFoldercharacterRptRequest.RptRequestSaveFolderThe name of the folder on the report server machine (best is UNC notation).
tiRptRequestSchedule_IDintegerRptRequest.RptRequestSchedule_IDReport Schedule
ti_sequenceintegercalculatedprimary index
tc_rowidcharactercalculated = rowid(RptRequest),rowid(RptPrinter),rowid(RptRequestMail),rowid(Role)


Internal usage


BLF
method BReportSchedule.CalculatePost
dataset BReportSchedule.tRptRequestInfo