The table has columns ActualStartTime, AdjustedStartTime, ActualFinishTime and AdjustedFinishTime.
We added properties JobStartTime and JobFinishTime to the table entity (see the following code).
Can JobStartTime and JobFinishTime be used in OQL?
If not, can we write an OQL based on database that provide the same results?
''' -----------------------------------------------------------------------------
''' <summary>
''' JobStartTime, ActualStartTime otherwise AdjustedStartTime if actual not available
''' </summary>
''' ----------------------------------------------------------------------------
Public ReadOnly Property JobStartTime() As Date
Get
Dim aJobStartTime As Date
Try
If Me.ActualStartTime.HasValue Then
aJobStartTime = Me.ActualStartTime.Value
Else
aJobStartTime = Me.AdjustedStartTime.Value
End If
Catch
aJobStartTime = Nothing
End Try
Return (aJobStartTime)
End Get
End Property
''' -----------------------------------------------------------------------------
''' <summary>
''' JobFinishTime, ActualFinishTime otherwise AdjustedFinishTime if actual not available
''' </summary>
''' ----------------------------------------------------------------------------
Public ReadOnly Property JobFinishTime() As Date
Get
Dim aJobFinishTime As Date
Try
If Me.ActualFinishTime.HasValue Then
aJobFinishTime = Me.ActualFinishTime.Value
Else
aJobFinishTime = Me.AdjustedFinishTime.Value
End If
Catch
aJobFinishTime = Nothing
End Try
Return (aJobFinishTime)
End Get
End Property