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

%BI.ScheduleTaskHist

persistent class %BI.ScheduleTaskHist extends %Library.Persistent

SQL Table Name: %BI.ScheduleTaskHist

Property Inventory (Including Private)

Method Inventory (Including Private)

Properties (Including Private)

property EndDate as %Date;
Property methods: EndDateDisplayToLogical(), EndDateGet(), EndDateGetStored(), EndDateIsValid(), EndDateLogicalToDisplay(), EndDateLogicalToOdbc(), EndDateNormalize(), EndDateOdbcToLogical(), EndDateSet()
property EndTime as %Time;
Property methods: EndTimeDisplayToLogical(), EndTimeGet(), EndTimeGetStored(), EndTimeIsValid(), EndTimeLogicalToDisplay(), EndTimeLogicalToOdbc(), EndTimeNormalize(), EndTimeOdbcToLogical(), EndTimeSet()
property Error as %String;
Property methods: ErrorDisplayToLogical(), ErrorGet(), ErrorGetStored(), ErrorIsValid(), ErrorLogicalToDisplay(), ErrorLogicalToOdbc(), ErrorNormalize(), ErrorSet()
property ScheduleID as %String [ Required ];
Property methods: ScheduleIDDisplayToLogical(), ScheduleIDGet(), ScheduleIDGetStored(), ScheduleIDIsValid(), ScheduleIDLogicalToDisplay(), ScheduleIDLogicalToOdbc(), ScheduleIDNormalize(), ScheduleIDSet()
property ScheduleStartDate as %Date [ Required ];
Property methods: ScheduleStartDateDisplayToLogical(), ScheduleStartDateGet(), ScheduleStartDateGetStored(), ScheduleStartDateIsValid(), ScheduleStartDateLogicalToDisplay(), ScheduleStartDateLogicalToOdbc(), ScheduleStartDateNormalize(), ScheduleStartDateOdbcToLogical(), ScheduleStartDateSet()
property ScheduleStartTime as %Time [ Required ];
Property methods: ScheduleStartTimeDisplayToLogical(), ScheduleStartTimeGet(), ScheduleStartTimeGetStored(), ScheduleStartTimeIsValid(), ScheduleStartTimeLogicalToDisplay(), ScheduleStartTimeLogicalToOdbc(), ScheduleStartTimeNormalize(), ScheduleStartTimeOdbcToLogical(), ScheduleStartTimeSet()
property StartDate as %Date;
Property methods: StartDateDisplayToLogical(), StartDateGet(), StartDateGetStored(), StartDateIsValid(), StartDateLogicalToDisplay(), StartDateLogicalToOdbc(), StartDateNormalize(), StartDateOdbcToLogical(), StartDateSet()
property StartTime as %Time;
Property methods: StartTimeDisplayToLogical(), StartTimeGet(), StartTimeGetStored(), StartTimeIsValid(), StartTimeLogicalToDisplay(), StartTimeLogicalToOdbc(), StartTimeNormalize(), StartTimeOdbcToLogical(), StartTimeSet()
property Status as %String;
Property methods: StatusDisplayToLogical(), StatusGet(), StatusGetStored(), StatusIsValid(), StatusLogicalToDisplay(), StatusLogicalToOdbc(), StatusNormalize(), StatusSet()
property TaskID as %String [ Required ];
Property methods: TaskIDDisplayToLogical(), TaskIDGet(), TaskIDGetStored(), TaskIDIsValid(), TaskIDLogicalToDisplay(), TaskIDLogicalToOdbc(), TaskIDNormalize(), TaskIDSet()
property UserID as %Integer;
Property methods: UserIDDisplayToLogical(), UserIDGet(), UserIDGetStored(), UserIDIsValid(), UserIDLogicalToDisplay(), UserIDNormalize(), UserIDSet()

Methods (Including Private)

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

Indexes

index (IdKey on ScheduleID,ScheduleStartDate,ScheduleStartTime,TaskID) [IdKey, Type = key, Unique];