Class %BI.ScheduleTaskHist

persistent class %BI.ScheduleTaskHist extends %Persistent

Parameters	Properties	Methods	Queries	Indices	ForeignKeys	Triggers
	11	1	9	1

Summary

Properties
EndDate	EndTime	Error	ScheduleID
ScheduleStartDate	ScheduleStartTime	StartDate	StartTime
Status	TaskID	UserID

Methods
%%OIDGet	%AddToSaveSet	%AddToSyncSet	%BMEBuilt
%BuildIndices	%CheckUnique	%ClassIsLatestVersion	%ClassName
%ComposeOid	%ConstructClone	%Delete	%DeleteExtent
%DeleteId	%DispatchClassMethod	%DispatchGetModified	%DispatchGetProperty
%DispatchMethod	%DispatchSetModified	%DispatchSetMultidimProperty	%DispatchSetProperty
%Exists	%ExistsId	%Extends	%GUID
%GUIDSet	%GetLock	%GetParameter	%GetSwizzleObject
%Id	%InsertBatch	%IsA	%IsModified
%KillExtent	%KillExtentData	%LoadFromMemory	%LockExtent
%LockId	%New	%NormalizeObject	%ObjectModified
%Oid	%OnBeforeAddToSync	%OnDetermineClass	%Open
%OpenId	%OriginalNamespace	%PackageName	%PhysicalAddress
%PurgeIndices	%Reload	%RemoveFromSaveSet	%ResolveConcurrencyConflict
%RollBack	%Save	%SaveDirect	%SaveIndices
%SerializeObject	%SetModified	%SortBegin	%SortEnd
%SyncObjectIn	%SyncTransport	%UnlockExtent	%UnlockId
%ValidateObject	DeleteHist

Properties

• property EndDate as %Date;

• property EndTime as %Time;

• property Error as %String;

• property ScheduleID as %String;

• property ScheduleStartDate as %Date;

• property ScheduleStartTime as %Time;

• property StartDate as %Date;

• property StartTime as %Time;

• property Status as %String;

• property TaskID as %String;

• property UserID as %Integer;

Methods

• classmethod DeleteHist(Para As %String)

Queries

• query BySchDesc(ScheID As %String)

SQL Query :
SELECT EndDate,EndTime,Error,ScheduleID,ScheduleStartDate,ScheduleStartTime,Status FROM %BI.ScheduleTaskHist
WHERE (ScheduleID = :ScheID)
ORDER BY ScheduleStartDate DESC, ScheduleStartTime DESC

• query BySchID(ScheID As %String)

SQL Query :
SELECT EndDate,EndTime,Error,ScheduleID,ScheduleStartDate,ScheduleStartTime,Status,TaskID FROM %BI.ScheduleTaskHist
WHERE (ScheduleID = :ScheID)
ORDER BY ScheduleStartDate DESC, ScheduleStartTime DESC, TaskID asc

• query ByScheIDTaskID(ScheID As %String, TID As %String)

SQL Query :
SELECT EndDate,EndTime,Error,ScheduleID,ScheduleStartDate,ScheduleStartTime,Status,TaskID FROM %BI.ScheduleTaskHist
WHERE (ScheduleID = :ScheID AND TaskID = :TID)
ORDER BY ScheduleStartDate desc, ScheduleStartTime desc

• query DeleteById(ScheID As %String)

SQL Query :
SELECT %ID, ScheduleID FROM %BI.ScheduleTaskHist
WHERE (ScheduleID = :ScheID)

• query DeleteRange(SchID As %String, Date As %Date)

SQL Query :
SELECT %ID,ScheduleID,ScheduleStartDate FROM %BI.ScheduleTaskHist
WHERE (ScheduleID = :SchID AND ScheduleStartDate <= :Date)

• query DeleteRangeAll(Date As %Date)

SQL Query :
SELECT %ID,ScheduleStartDate FROM %BI.ScheduleTaskHist
WHERE (ScheduleStartDate <= :Date)

• query ScheIdDateTime(SchID As %String, Date As %Date, Time As %Time)

SQL Query :
SELECT %ID,ScheduleID,ScheduleStartDate,ScheduleStartTime FROM %BI.ScheduleTaskHist
WHERE (ScheduleID = :SchID AND ScheduleStartDate = :Date AND ScheduleStartTime = :Time)

• query ScheIdTaskDateTime(SchID As %String, Task As %String, Date As %Date, Time As %Time)

SQL Query :
SELECT %ID,EndDate,EndTime,Error,ScheduleID,ScheduleStartDate,ScheduleStartTime,StartDate,StartTime,Status,TaskID,UserID FROM %BI.ScheduleTaskHist
WHERE (ScheduleID = :SchID AND TaskID = :Task AND ScheduleStartDate = :Date AND ScheduleStartTime = :Time)

• query TaskHistory(SchID As %String, TaskID As %String)

SQL Query :
SELECT %ID,EndDate,EndTime,Error,ScheduleID,StartDate,StartTime,Status,TaskID FROM %BI.ScheduleTaskHist
WHERE (ScheduleID = :SchID AND TaskID = :TaskID)
ORDER BY ScheduleStartDate desc, ScheduleStartTime desc

Indices

• index (IdKey on ScheduleID,ScheduleStartDate,ScheduleStartTime,TaskID) [IdKey,Unique];


[BASEXML] > [%BI] > [ScheduleTaskHist]		Private Storage