SQL-013: clsXPrintControl.RetrieveSQL¶

Retrieves a single XPRINT_CONTROL row by its primary key (XPRINT_CONTROL_SEQ_NUM). This is the live retrieve path for clsXPrintControl.GetXPrintControl(inSeqNum). The returned row populates all batch-header properties: directory name, duplex code, processed date, IDM path name, XML file name, and MD5 hash.

Classification¶

Field	Value
SQL ID	SQL-013
Operation type	Read (Retrieve)
Execution method	Inline
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsXPrintControl`
Criteria property	`RetrieveSQL`
Lifecycle method	`BeforeRetrieve`

Parameters¶

Parameter	Direction	Type	Max length	Description
`:XPrintControlSeqNum`	Input	Decimal	—	Primary key lookup

Tables¶

Table	Access	Columns used
XPRINT_CONTROL	SELECT	`DIRECTORY_NAME`, `DUPLEX_CODE`, `PROCESSED_DATE`, `XPRINT_CONTROL_SEQ_NUM`, `IDM_PATH_NAME`, `XML_FILE_NAME`, `MD5_HASH_VALUE`

Sample SQL¶

Select
    XPRINT_CONTROL.DIRECTORY_NAME           as DirectoryName,
    XPRINT_CONTROL.DUPLEX_CODE              as DuplexCode,
    XPRINT_CONTROL.PROCESSED_DATE           as ProcessedDate,
    XPRINT_CONTROL.XPRINT_CONTROL_SEQ_NUM   as XPrintControlSeqNum,
    XPRINT_CONTROL.IDM_PATH_NAME            as IDMPathName,
    XPRINT_CONTROL.XML_FILE_NAME            as XMLFileName,
    XPRINT_CONTROL.MD5_HASH_VALUE           as MD5HashValue
From
    XPRINT_CONTROL
Where
    XPRINT_CONTROL.XPRINT_CONTROL_SEQ_NUM = :XPrintControlSeqNum

Operations and processes¶

Print-control batch header lifecycle

Note: Statements marked with ** could not be confirmed; treat as unknown until verified.

Sources¶

Services\SAIF.Services.Printing.Remote\clsXPrintControl.vb