Skip to content

SQL-171: Retrieve DocumentTemplateOutputProfile

This statement reads DOCUMENT_TEMPLATE_OP rows either unfiltered (GetAllTemplateOutputProfiles) or filtered to a single template (GetOuputProfilesForOneTemplate, GetDocumentSqlLines).

Classification

Field Value
SQL ID SQL-171
Operation type Read
Execution method ORM (NHibernate LINQ)
Database Oracle
Schema [unqualified]**
Command type N/A (ORM-generated)
Business object DocumentTemplateOutputProfile
Criteria property N/A — ORM
Lifecycle method GetAllTemplateOutputProfiles, GetDocumentSqlLines, GetOuputProfilesForOneTemplate

Parameters

Parameter Direction Type Max length Description
:templateId Input long N/A a.DocumentTemplateSeqNum == inId (L124) / == templateId (L958) → column DOCUMENT_TEMPLATE_SEQ_NUM

Tables

Table Access Columns used
DOCUMENT_TEMPLATE_OP SELECT all mapped columns; filter DOCUMENT_TEMPLATE_SEQ_NUM

LINQ statement

Source: Services/SAIF.Services/Documents/TemplateSearchService.cs:119. Additional fragments at :124, :958.

// Services/SAIF.Services/Documents/TemplateSearchService.cs:119
var codeRecords = unitOfWork.GetRepository<DocumentTemplateOutputProfile>().Query().ToList();

// Services/SAIF.Services/Documents/TemplateSearchService.cs:124
var codeRecords = unitOfWork.GetRepository<DocumentTemplateOutputProfile>().Query().Where(a => a.DocumentTemplateSeqNum == inId).ToList();

// Services/SAIF.Services/Documents/TemplateSearchService.cs:958
var outputProfiles = unitOfWork.GetRepository<DocumentTemplateOutputProfile>().Query().Where(a => a.DocumentTemplateSeqNum == templateId).ToList();

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
-- (1) L119 — GetAllTemplateOutputProfiles
SELECT DTOP.DOCUMENT_TEMPLATE_OP_SEQ_NUM,
       DTOP.DOCUMENT_TEMPLATE_SEQ_NUM,
       DTOP.CREATE_USER,
       DTOP.CREATE_DATE,
       DTOP.DOCUMENT_OP_CODE
FROM   DOCUMENT_TEMPLATE_OP DTOP;

-- (2) L124 — GetOuputProfilesForOneTemplate / (3) L958 — GetDocumentSqlLines
SELECT <same column list>
FROM   DOCUMENT_TEMPLATE_OP DTOP
WHERE  DTOP.DOCUMENT_TEMPLATE_SEQ_NUM = :templateId;   -- :inId (L124) / :templateId (L958)

Translation notes: - All statements materialized by .ToList(). - Mapping quirk: leading space in .Column(" DOCUMENT_TEMPLATE_SEQ_NUM") (trimmed here).

Operations and processes

Business rules

Sources

  • Services/SAIF.Services/Documents/TemplateSearchService.cs (L119, L124, L958)