SQL-015 Purge completed tasks¶

Deletes tasks already flagged deleted/completed that are older than a caller-supplied retention window, by calling the Oracle stored procedure PK82036_Task.Task_Purge.

Classification¶

Field	Value
SQL ID	SQL-015
Operation type	Delete
Execution method	Stored procedure
Database	Oracle
Schema	`[unqualified]`**
Command type	StoredProcedure
Business object	N/A (Application layer)
Criteria property	N/A
Lifecycle method	N/A
Application class	`clsTaskCollection` (`Shared PurgeTasks`)

Parameters¶

Parameter	Direction	Type	Max length	Description
`:intasksourcecode`	Input	String	5	Source system whose tasks are purged
`:intaskcategorycode`	Input	String	5	Category whose tasks are purged
`:inkeepdays`	Input	String	5	Retention window in days (passed as a string)
`:outdelrows`	Output	`DbType.String`	15	Number of purged rows; converted with `CInt` by the caller

Tables¶

Table	Access	Columns used
TASK	DELETE	N/A — stored procedure (deletes from `TASK`)**

Sample SQL¶

-- CommandType.StoredProcedure, RequestType = Scalar, DataRequest.ID = "IMG0001_Purge_Task"
CALL PK82036_Task.Task_Purge(
  :intasksourcecode,
  :intaskcategorycode,
  :inkeepdays,
  :outdelrows)

:outdelrows is an OUT parameter (DbType.String, length 15) read back via DataRequest.ParmValue("outdelrows") and converted with CInt. The procedure body resides in the Oracle database and was not retrieved in this environment.**

Operations and processes¶

Purge completed tasks

Sources¶

SAIF.Business.Tasks/clsTaskCollection.vb