Skip to content

SQL-154: Retrieve DocumentDistributionLog

This ORM statement performs a read operation on DocumentDistributionLog via IUnitOfWork.GetRepository<T>(), executed from Services/SAIF.Services/Documents/DocumentRequestService.cs (L262, L307, L351, L450, L529).

Classification

Field Value
SQL ID SQL-154
Operation type Read
Execution method ORM (NHibernate LINQ)
Database Oracle
Schema [unqualified]**
Command type N/A (ORM-generated)
Business object DocumentDistributionLog
Criteria property N/A — ORM
Lifecycle method DeleteRequestDistributionById, GetDocumentDistributionLogById, GetPendingRequests, UpdateDocumentDistributionLogXmlField, UpdateDocumentDistributionRecord

Parameters

Parameter Direction Type Max length Description
DocumentRequestLog.PendingRequest Input ** N/A x.DocRequestLogStatusCode == DocumentRequestLog.PendingRequest → column DOC_REQUEST_LOG_STATUS_CODE
logId Input ** N/A a.Id == logId → column DOCUMENT_DIST_LOG_SEQ_NUM
distributionLog.Id Input ** N/A a.Id == distributionLog.Id → column DOCUMENT_DIST_LOG_SEQ_NUM

Tables

Table Access Columns used
DOCUMENT_DISTRIBUTION_LOG SELECT DOCUMENT_DIST_LOG_SEQ_NUM, DOCUMENT_REQUEST_LOG_SEQ_NUM, DOC_REQUEST_LOG_STATUS_CODE, PLANNED_DISTRIBUTION_DATE, ACTUAL_DISTRIBUTION_DATE, PACKAGE_NAME, XML, PRINTER_NAME, PRINT_MODE, COPIES, SCALE_MODE, OUTPUT_PROFILE, IMPORT_INFO, EMAIL_INFO, FAX_INFO, IMAGE_PATH, TRAY, DEFERRED_INFO, CERTIFICATION_INFO, APPLICATION, CREATE_USER, CREATE_DATE, UPDATE_USER, UPDATE_DATE

LINQ statement

Source: Services/SAIF.Services/Documents/DocumentRequestService.cs:262

// Services/SAIF.Services/Documents/DocumentRequestService.cs:262-264
            var distributions = UnitOfWork.GetRepository<DocumentDistributionLog>().Query()
                .Where(x => x.DocRequestLogStatusCode == DocumentRequestLog.PendingRequest) // && x.PlannedDistributionDate != DateTime.MinValue)
                .ToList();

// Services/SAIF.Services/Documents/DocumentRequestService.cs:307
            var item = UnitOfWork.GetRepository<DocumentDistributionLog>().Query().SingleOrDefault(a => a.Id == logId);

// Services/SAIF.Services/Documents/DocumentRequestService.cs:351
            var item = UnitOfWork.GetRepository<DocumentDistributionLog>().Query().SingleOrDefault(a => a.Id == logId);

// Services/SAIF.Services/Documents/DocumentRequestService.cs:450
            DocumentDistributionLog currentLog = UnitOfWork.GetRepository<DocumentDistributionLog>().Query().SingleOrDefault(a => a.Id == distributionLog.Id);

// Services/SAIF.Services/Documents/DocumentRequestService.cs:529
            var log = UnitOfWork.GetRepository<DocumentDistributionLog>().Query().SingleOrDefault(a => a.Id == logId);

Sample SQL

Inferred SQL: This SQL was inferred from the LINQ statement above and the NHibernate mappings. It is not concrete SQL from source code; NHibernate generates the executed statement at runtime, so aliases, column order, join syntax, and bind-parameter names may differ.

-- Inferred from LINQ (NHibernate mapping translation); not concrete SQL
-- Services/SAIF.Services/Documents/DocumentRequestService.cs:262
SELECT
  DDL.DOCUMENT_DIST_LOG_SEQ_NUM,
  DDL.DOCUMENT_REQUEST_LOG_SEQ_NUM,
  DDL.DOC_REQUEST_LOG_STATUS_CODE,
  DDL.PLANNED_DISTRIBUTION_DATE,
  DDL.ACTUAL_DISTRIBUTION_DATE,
  DDL.PACKAGE_NAME,
  DDL.XML,
  DDL.PRINTER_NAME,
  DDL.PRINT_MODE,
  DDL.COPIES,
  DDL.SCALE_MODE,
  DDL.OUTPUT_PROFILE,
  DDL.IMPORT_INFO,
  DDL.EMAIL_INFO,
  DDL.FAX_INFO,
  DDL.IMAGE_PATH,
  DDL.TRAY,
  DDL.DEFERRED_INFO,
  DDL.CERTIFICATION_INFO,
  DDL.APPLICATION,
  DDL.CREATE_USER,
  DDL.CREATE_DATE,
  DDL.UPDATE_USER,
  DDL.UPDATE_DATE
FROM DOCUMENT_DISTRIBUTION_LOG DDL
WHERE DDL.DOC_REQUEST_LOG_STATUS_CODE = 'PEND'

-- Services/SAIF.Services/Documents/DocumentRequestService.cs:307
SELECT
  DDL.DOCUMENT_DIST_LOG_SEQ_NUM,
  DDL.DOCUMENT_REQUEST_LOG_SEQ_NUM,
  DDL.DOC_REQUEST_LOG_STATUS_CODE,
  DDL.PLANNED_DISTRIBUTION_DATE,
  DDL.ACTUAL_DISTRIBUTION_DATE,
  DDL.PACKAGE_NAME,
  DDL.XML,
  DDL.PRINTER_NAME,
  DDL.PRINT_MODE,
  DDL.COPIES,
  DDL.SCALE_MODE,
  DDL.OUTPUT_PROFILE,
  DDL.IMPORT_INFO,
  DDL.EMAIL_INFO,
  DDL.FAX_INFO,
  DDL.IMAGE_PATH,
  DDL.TRAY,
  DDL.DEFERRED_INFO,
  DDL.CERTIFICATION_INFO,
  DDL.APPLICATION,
  DDL.CREATE_USER,
  DDL.CREATE_DATE,
  DDL.UPDATE_USER,
  DDL.UPDATE_DATE
FROM DOCUMENT_DISTRIBUTION_LOG DDL
WHERE DDL.DOCUMENT_DIST_LOG_SEQ_NUM = :logId
-- NHibernate expects at most one row

-- Services/SAIF.Services/Documents/DocumentRequestService.cs:351
SELECT
  DDL.DOCUMENT_DIST_LOG_SEQ_NUM,
  DDL.DOCUMENT_REQUEST_LOG_SEQ_NUM,
  DDL.DOC_REQUEST_LOG_STATUS_CODE,
  DDL.PLANNED_DISTRIBUTION_DATE,
  DDL.ACTUAL_DISTRIBUTION_DATE,
  DDL.PACKAGE_NAME,
  DDL.XML,
  DDL.PRINTER_NAME,
  DDL.PRINT_MODE,
  DDL.COPIES,
  DDL.SCALE_MODE,
  DDL.OUTPUT_PROFILE,
  DDL.IMPORT_INFO,
  DDL.EMAIL_INFO,
  DDL.FAX_INFO,
  DDL.IMAGE_PATH,
  DDL.TRAY,
  DDL.DEFERRED_INFO,
  DDL.CERTIFICATION_INFO,
  DDL.APPLICATION,
  DDL.CREATE_USER,
  DDL.CREATE_DATE,
  DDL.UPDATE_USER,
  DDL.UPDATE_DATE
FROM DOCUMENT_DISTRIBUTION_LOG DDL
WHERE DDL.DOCUMENT_DIST_LOG_SEQ_NUM = :logId
-- NHibernate expects at most one row

-- Services/SAIF.Services/Documents/DocumentRequestService.cs:450
SELECT
  DDL.DOCUMENT_DIST_LOG_SEQ_NUM,
  DDL.DOCUMENT_REQUEST_LOG_SEQ_NUM,
  DDL.DOC_REQUEST_LOG_STATUS_CODE,
  DDL.PLANNED_DISTRIBUTION_DATE,
  DDL.ACTUAL_DISTRIBUTION_DATE,
  DDL.PACKAGE_NAME,
  DDL.XML,
  DDL.PRINTER_NAME,
  DDL.PRINT_MODE,
  DDL.COPIES,
  DDL.SCALE_MODE,
  DDL.OUTPUT_PROFILE,
  DDL.IMPORT_INFO,
  DDL.EMAIL_INFO,
  DDL.FAX_INFO,
  DDL.IMAGE_PATH,
  DDL.TRAY,
  DDL.DEFERRED_INFO,
  DDL.CERTIFICATION_INFO,
  DDL.APPLICATION,
  DDL.CREATE_USER,
  DDL.CREATE_DATE,
  DDL.UPDATE_USER,
  DDL.UPDATE_DATE
FROM DOCUMENT_DISTRIBUTION_LOG DDL
WHERE DDL.DOCUMENT_DIST_LOG_SEQ_NUM = :Id
-- NHibernate expects at most one row

-- Services/SAIF.Services/Documents/DocumentRequestService.cs:529
SELECT
  DDL.DOCUMENT_DIST_LOG_SEQ_NUM,
  DDL.DOCUMENT_REQUEST_LOG_SEQ_NUM,
  DDL.DOC_REQUEST_LOG_STATUS_CODE,
  DDL.PLANNED_DISTRIBUTION_DATE,
  DDL.ACTUAL_DISTRIBUTION_DATE,
  DDL.PACKAGE_NAME,
  DDL.XML,
  DDL.PRINTER_NAME,
  DDL.PRINT_MODE,
  DDL.COPIES,
  DDL.SCALE_MODE,
  DDL.OUTPUT_PROFILE,
  DDL.IMPORT_INFO,
  DDL.EMAIL_INFO,
  DDL.FAX_INFO,
  DDL.IMAGE_PATH,
  DDL.TRAY,
  DDL.DEFERRED_INFO,
  DDL.CERTIFICATION_INFO,
  DDL.APPLICATION,
  DDL.CREATE_USER,
  DDL.CREATE_DATE,
  DDL.UPDATE_USER,
  DDL.UPDATE_DATE
FROM DOCUMENT_DISTRIBUTION_LOG DDL
WHERE DDL.DOCUMENT_DIST_LOG_SEQ_NUM = :logId
-- NHibernate expects at most one row

Translation notes: - DocumentRequestLog.PendingRequest is the constant "PEND" (Data/SAIF.Data/Model/Documents/DocumentRequestLog.cs:26) -> inline literal. The commented-out PlannedDistributionDate predicate on L263 is not part of the query. - distributionLog.Id (L450) -> bind :Id.

Operations and processes

Sources

  • Services/SAIF.Services/Documents/DocumentRequestService.cs (L262, L307, L351, L450, L529)