Table 1170 "User Task"
Base Application · Microsoft.Foundation.Task
Across versions
- BC23present
- BC243 fields changed
- BC25-28unchanged
- BC2916 fields changed
- BC30unchanged
Neighbourhood 10 connected objects and pages
Base Application · Microsoft.Foundation.Task · BC23-30 · source at ea08af5e · facts from BC29
Learn documents this table through its pages: Page 1164 “User Task List Part” (1 Learn page), Page 1170 “User Task List” (1), Page 1171 “User Task Card” (1), Page 1316 “Accountant Portal User Tasks” (1).
Properties
| Property | Value |
|---|---|
| Caption | User Task |
| DataClassification | CustomerContent |
Fields
Explanation: the field’s ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.
| No. | Name | Type | Explanation | Notes |
|---|---|---|---|---|
| 1 | ID Δ BC29 | Integer | Specifies the ID that applies. | not editable; AutoIncrement |
| 2 | Title Δ BC29 | Text[250] | Specifies the title of the task. | |
| 3 | Created By | Guid | — | TableRelation User.“User Security ID” where(“License Type” = const(“Full User”)); not editable; DataClassification EndUserPseudonymousIdentifiers |
| 4 | Created DateTime Δ BC29 | DateTime | Specifies when the task was created. | not editable |
| 5 | Assigned To Δ BC29 | Guid | Specifies who the task is assigned to. | TableRelation User.“User Security ID” where(“License Type” = const(“Full User”)) |
| 7 | Completed By | Guid | — | TableRelation User.“User Security ID” where(“License Type” = const(“Full User”)); DataClassification EndUserPseudonymousIdentifiers |
| 8 | Completed DateTime Δ BC29 | DateTime | Specifies when the task was completed. | |
| 9 | Due DateTime Δ BC29 | DateTime | Specifies when the task must be completed. | |
| 10 | Percent Complete Δ BC29 | Integer | Specifies the progress of the task. | |
| 11 | Start DateTime Δ BC29 | DateTime | Specifies when the task must start. | |
| 12 | Priority Δ BC29 | Option | Specifies the priority of the task. | OptionCaption: ,Low,Normal,High |
| 13 | Description Δ BC29 | BLOB | Specifies a descriptions of the task. | |
| 14 | Created By User Name Δ BC24 Δ BC29 | Code[50] | Specifies who created the task. | FlowField: lookup(User.“User Name” where(“User Security ID” = field(“Created By”))); not editable |
| 15 | Assigned To User Name Δ BC24 Δ BC29 | Code[50] | Specifies who the task is assigned to. | FlowField: lookup(User.“User Name” where(“User Security ID” = field(“Assigned To”))); not editable |
| 16 | Completed By User Name Δ BC24 Δ BC29 | Code[50] | Specifies who completed the task. | FlowField: lookup(User.“User Name” where(“User Security ID” = field(“Completed By”))); not editable |
| 17 | Object Type Δ BC29 | Option | Specifies the type of window that the task opens. | OptionCaption: ,,,Report,,,,,Page |
| 18 | Object ID Δ BC29 | Integer | Specifies the window that the task opens. | TableRelation AllObj.“Object ID” where(“Object Type” = field(“Object Type”)) |
| 19 | Parent ID | Integer | — | |
| 20 | User Task Group Assigned To Δ BC29 | Code[20] | Specifies the group if the task has been assigned to a group of people. | TableRelation Table 1175 “User Task Group” (“User Task Group”.Code) |
| 21 | ShouldShowPendingTasks | Boolean | — | FlowFilter; not editable |
Keys
- Key1: ID (clustered)
- Key2: Assigned To, User Task Group Assigned To, Percent Complete, Due DateTime
- Key3: User Task Group Assigned To
Events published
OnBeforeRunReportOrPageLink(var UserTask: Record "User Task"; var IsHandled: Boolean)(integration)OnCreateRecurrenceOnBeforeInsert(var UserTask: Record "User Task"; fromUserTask: Record "User Task"; Counter: Integer; RecurringStartDate: Date; Recurrence: DateFormula)(integration)OnBeforeSetCompleted(var UserTask: Record "User Task")(integration)OnAfterSetCompleted(var UserTask: Record "User Task")(integration)
Procedures
CreateRecurrence(RecurringStartDate: Date; Recurrence: DateFormula; Occurrences: Integer)SetCompleted()SetStyle(): TextGetDescription(): TextSetDescription(StreamText: Text)IsCompleted(): BooleanRunReportOrPageLink()
Triggers
OnDelete, OnInsert
Relations
- User Task Group Assigned To: TableRelation Table 1175 “User Task Group”
Pages and codeunits on this table
- Page 1164 “User Task List Part” (source table)
- Page 1170 “User Task List” (source table)
- Page 1171 “User Task Card” (source table)
- Page 1316 “Accountant Portal User Tasks” (source table)
- Page 9078 “User Tasks Activities” (source table)
Calls
From the extracted call graph of BC29 (graphify-al on the snapshot checkout): calls whose target is known from a declared type or an Object::"Name" argument. Interface dispatch and calls through events are not counted, so the list is not complete.
- Codeunit 10 “Type Helper” (2 calls:
GetDescription → LFSeparator,GetDescription → ReadAsTextWithSeparator) - Codeunit 4100 “Temp Blob” (2 calls:
GetDescription → CreateInStream,GetDescription → FromRecord)
Ask your agent
Procedure bodies are not stored here (D10). The call sections above are our own, per object, from the BC29 call graph. For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: bcatlas_resolve_node(object_type: "table", object_name: "User Task"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.