DB-CLL-029 — Retrieve the request issue list for a case

Classification

Field	Value
SQL ID	DB-CLL-029
Operation type	R
Execution method	Text
Database	Oracle (Case Management)
Schema	[unqualified]**
Command type	Inline text SQL
Business object	clsRequestIssue collection ctor
Criteria property	MyRetrieveSQL
Lifecycle method	BeforeRetrieve

Parameters

Name	Direction	Type	Default	Description
LegalCaseID	Input	NUMBER	N/A	Legal case identifier used to filter request issues

Tables

Table	Access	Columns/Notes
REQUEST_ISSUE	SELECT	LEGAL_CASE_SEQ_NUM, REQUEST_ISSUE_CODE, REQUEST_ISSUE_TEXT

Sample SQL

Select
  REQUEST_ISSUE.REQUEST_ISSUE_SEQ_NUM as RequestIssueID,
  REQUEST_ISSUE.LEGAL_CASE_SEQ_NUM as LegalCaseID,
  REQUEST_ISSUE.REQUEST_ISSUE_CODE as RequestIssueCode,
  REQUEST_ISSUE.REQUEST_ISSUE_TEXT as RequestIssueText
From
  REQUEST_ISSUE
Where
  REQUEST_ISSUE.LEGAL_CASE_SEQ_NUM = :LegalCaseID

Operations and processes

• Manage other legal parties and request issues

Sources

• SAIF.Business.Claim.Legal\LegalNet\clsRequestIssue.vb