DB-CLL-007 — Retrieve case status history, newest first¶

Classification¶

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

Parameters¶

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

Tables¶

Table	Access	Columns/Notes
CASE_STATUS_HISTORY	SELECT	LEGAL_CASE_SEQ_NUM, CASE_STATUS_CODE, CREATE_DATE

Sample SQL¶

Select
  CASE_STATUS_HISTORY.CASE_STATUS_HISTORY_SEQ_NUM as CaseStatusHistoryID,
  CASE_STATUS_HISTORY.LEGAL_CASE_SEQ_NUM as LegalCaseID,
  CASE_STATUS_HISTORY.CASE_STATUS_CODE as CaseStatusCode,
  CASE_STATUS_HISTORY.CREATE_DATE as CreateDate
From
  CASE_STATUS_HISTORY
Where
  CASE_STATUS_HISTORY.LEGAL_CASE_SEQ_NUM = :LegalCaseID
Order by
  CASE_STATUS_HISTORY_SEQ_NUM desc

Sources¶

SAIF.Business.Claim.Legal\LegalNet\clsCaseStatusHistory.vb