Home > Class Reference > ENSLIB namespace > %BI.ScheduleTaskHist
Private  Storage   

%BI.ScheduleTaskHist


persistent class %BI.ScheduleTaskHist extends %Persistent

Inventory


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
%AddToSaveSet %AddToSyncSet %BMEBuilt %CheckConstraints
%CheckConstraintsForExtent %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 %IsNull
%KillExtent %KillExtentData %LoadFromMemory %LockExtent
%LockId %New %NormalizeObject %ObjectIsNull
%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 %ValidateIndices %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];