SQL-019 Allowed case status codes for the current case¶

StringBuilder/concatenation (consts CASESTATUSCODESQL + status codes + ORDERSQL → GetCodeCollection) for clsUpdateCaseManager.

Classification¶

Field	Value
SQL ID	SQL-019
Operation type	Read
Execution method	StringBuilder/concatenation (consts CASESTATUSCODESQL + status codes + ORDERSQL → GetCodeCollection)
Database	Oracle
Schema	[unqualified]**
Command type	Text
Business object	`clsUpdateCaseManager`
Criteria property	N/A
Lifecycle method	CaseStatusList property getter

Tables¶

Table	Access	Columns used
CASE_STATUS_CODE	SELECT	See database table section

Sample SQL¶

-- Reconstructed: CASESTATUSCODESQL & StatusHistory(0).StatusCode [& "', '" & StatusHistory(1).StatusCode] & ORDERSQL
-- Two-status variant (CurrentCase.StatusHistory.Count > 1):
SELECT
  code,
  code_descr
FROM CASE_STATUS_CODE
WHERE code in ('<StatusHistory(0).StatusCode>', '<StatusHistory(1).StatusCode>')

-- Single-status variant (CurrentCase.StatusHistory.Count = 1):
SELECT
  code,
  code_descr
FROM CASE_STATUS_CODE
WHERE code in ('<StatusHistory(0).StatusCode>')

Operations and processes¶

Case update screen — case status selector

Sources¶

SAIF.Application.Claim.Legal\LegalNet\clsUpdateCaseManager.vb