Projects.Agile.TimeEntries
Contains entries about the time spent working on cases.
General
Namespace: Projects.Agile
Repository: Projects.Agile.TimeEntries
Base Table: Apm_Time_Entries
Introduced In Version: 25.1.2.78
API access: ReadWrite
Visualization
Display Format: {Date:d} {StartTime:hh:mm} - {EndTime:hh:mm}
Search Members:
Category: Views
Show in UI: ShownByDefault
Track Changes
Min level: 0 - Do not track changes
Max level: 4 - Track object attribute and blob changes
Aggregate
An aggregate is a cluster of domain objects that can be treated as a single unit.
Aggregate Tree
Attributes
| Name | Type | Description |
|---|---|---|
| Date | date | The date for which the time entry is created. Required Filter(eq;ge;le) ORD |
| DurationHours | decimal (0, 0) | Total duration of the logged time (in hours). [ReadOnly] |
| EndTime | time nullable | The ending time of the logged work. Stored in the local time zone of the user. Empty value when the work is still in progress. Filter(eq;ge;le) |
| Notes | string (max) nullable | Notes. Filter(like) |
| StartTime | time | The start time of the logged work. Stored in the local time zone of the user. Required Filter(eq;ge;le) ORD |
References
| Name | Type | Description |
|---|---|---|
| Case | Cases | The case for which the time is recorded. Required Filter(multi eq) |
| User | Users | The user for whom the time is recorded. Required Filter(multi eq) ReadOnly |
System Attributes
| Name | Type | Description |
|---|---|---|
| Id | guid | |
| ObjectVersion | int32 | The latest version of the extensible data object for the aggregate root for the time the object is loaded from the database. Can be used for optimistic locking. |
| ExternalId | string | The id of the object, when it is imported/synchronized with external system. Used by sync apps to identify the object in external systems. [Filter(multi eq)] [ORD] [Introduced in version 24.1.0.89] |
| ExternalSystem | string | The name of the external system from which the object is imported/synchronized. [Filter(multi eq)] [Introduced in version 24.1.0.89] |
| AggregateLastUpdateTimeUtc | datetime | The exact server time (in UTC) of the last modification of the object represented by this system object. null means that it is unknown. [Filter(ge;le)] [ORD] [Introduced in version 19.1] |
| DisplayText | string | Uses the repository DisplayTextFormat to build the display text from the attributes and references of current object. |
Attribute Details
Date
The date for which the time entry is created. Required Filter(eq;ge;le) ORD
Type: date
Category: System
Supported Filters: Equals, GreaterThanOrLessThan
Supports Order By: True
Show in UI: ShownByDefault
DurationHours
Total duration of the logged time (in hours). [ReadOnly]
Type: decimal (0, 0)
Category: Calculated Attributes
Supported Filters: NotFilterable
Supports Order By: ****
Show in UI: ShownByDefault
EndTime
The ending time of the logged work. Stored in the local time zone of the user. Empty value when the work is still in progress. Filter(eq;ge;le)
Type: time nullable
Category: System
Supported Filters: Equals, GreaterThanOrLessThan
Supports Order By: False
Show in UI: ShownByDefault
Notes
Notes. Filter(like)
Type: string (max) nullable
Category: System
Supported Filters: Like
Supports Order By: False
Maximum Length: 2147483647
Show in UI: ShownByDefault
StartTime
The start time of the logged work. Stored in the local time zone of the user. Required Filter(eq;ge;le) ORD
Type: time
Category: System
Supported Filters: Equals, GreaterThanOrLessThan
Supports Order By: True
Show in UI: ShownByDefault
Id
Type: guid
Indexed: True
Category: System
Supported Filters: Equals, GreaterThanOrLessThan, EqualsIn
Show in UI: CannotBeShown
ObjectVersion
The latest version of the extensible data object for the aggregate root for the time the object is loaded from the database. Can be used for optimistic locking.
Type: int32
Category: Extensible Data Object
Supported Filters: NotFilterable
Supports Order By: ****
Show in UI: HiddenByDefault
ExternalId
The id of the object, when it is imported/synchronized with external system. Used by sync apps to identify the object in external systems. [Filter(multi eq)] [ORD] [Introduced in version 24.1.0.89]
Type: string
Category: Extensible Data Object
Supported Filters: NotFilterable
Supports Order By: ****
Show in UI: HiddenByDefault
ExternalSystem
The name of the external system from which the object is imported/synchronized. [Filter(multi eq)] [Introduced in version 24.1.0.89]
Type: string
Category: Extensible Data Object
Supported Filters: NotFilterable
Supports Order By: ****
Show in UI: HiddenByDefault
AggregateLastUpdateTimeUtc
The exact server time (in UTC) of the last modification of the object represented by this system object. null means that it is unknown. [Filter(ge;le)] [ORD] [Introduced in version 19.1]
Type: datetime
Category: Extensible Data Object
Supported Filters: NotFilterable
Supports Order By: ****
Show in UI: HiddenByDefault
DisplayText
Uses the repository DisplayTextFormat to build the display text from the attributes and references of current object.
Type: string
Category: Calculated Attributes
Supported Filters: NotFilterable
Supports Order By: ****
Show in UI: HiddenByDefault
Reference Details
Case
The case for which the time is recorded. Required Filter(multi eq)
Type: Cases
Category: System
Supported Filters: Equals, EqualsIn
Show in UI: ShownByDefault
User
The user for whom the time is recorded. Required Filter(multi eq) ReadOnly
Type: Users
Category: System
Supported Filters: Equals, EqualsIn
Show in UI: ShownByDefault
API Methods
Methods that can be invoked in public APIs.
GetAllowedCustomPropertyValues
Gets the allowed values for the specified custom property for this entity object. If supported the result is ordered by property value. Some property value sources do not support ordering - in that case the result is not ordered.
Return Type: Collection Of CustomPropertyValue
Declaring Type: EntityObject
Domain API Request: GET
Parameters
customPropertyCode
The code of the custom property
Type: stringsearch
The search text - searches by value or description. Can contain wildcard character %.
Type: string
Optional: True
Default Value: nullexactMatch
If true the search text should be equal to the property value
Type: boolean
Optional: True
Default Value: FalseorderByDescription
If true the result is ordered by Description instead of Value. Note that ordering is not always possible.
Type: boolean
Optional: True
Default Value: Falsetop
The top clause - default is 10
Type: int32
Optional: True
Default Value: 10skip
The skip clause - default is 0
Type: int32
Optional: True
Default Value: 0
CreateNotification
Create a notification immediately in a separate transaction, and send a real-time event to the user.
Return Type: void
Declaring Type: EntityObject
Domain API Request: POST
Parameters
user
The user.
Type: UsersnotificationClass
The notification class.
Type: stringsubject
The notification subject.
Type: stringpriority
The notification priority.
Type: Systems.Core.NotificationsRepository.Priority
Allowed values for thePriority(Systems.Core.Notifications.md#priority) data attribute
Allowed Values (Systems.Core.NotificationsRepository.Priority Enum Members)Value Description Background Background value. Stored as 1.
Model Value: 1
Domain API Value: 'Background'Low Low value. Stored as 2.
Model Value: 2
Domain API Value: 'Low'Normal Normal value. Stored as 3.
Model Value: 3
Domain API Value: 'Normal'High High value. Stored as 4.
Model Value: 4
Domain API Value: 'High'Urgent Urgent value. Stored as 5.
Model Value: 5
Domain API Value: 'Urgent'Optional: True
Default Value: Normal
CreateCopy
Duplicates the object and its child objects belonging to the same aggregate. The duplicated objects are not saved to the data source but remain in the same transaction as the original object.
Return Type: EntityObject
Declaring Type: EntityObject
Domain API Request: POST
Business Rules
- R38519 Time Entry - End Time Is After Start Time
- R38525 Time Entry - Check Case System State
- R38545 Time Entry - Overlapping Not Allowed
Front-End Business Rules
API
Domain API Entity Set: Projects_Agile_TimeEntries
Domain API Entity Type: Projects_Agile_TimeEntry
Domain API Query: https://testdb.my.erp.net/api/domain/odata/Projects_Agile_TimeEntries?$top=10
Domain API Query Builder: https://testdb.my.erp.net/api/domain/querybuilder#Projects_Agile_TimeEntries?$top=10