Task

UI Element UI Field REST API Resource REST API Property Path XDC Resource XDC Data Mapping Table XDC Column Name Data Warehouse Schema Data Warehouse Table Data Warehouse Column FM Model Path FM Model Query Subject FM Model Query Item Description Sample Input Sample Output
Task N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A
N/A workitem workitem/workItem/itemId WorkItem WorkItem itemId ODS TASK EXTERNAL_KEY2 Operational Data Store/Task Area Task External Key2 The UUID representing the item in storage. This is technically an internal detail, and resources should mostly be referred to by their unique URLs. In some cases the itemId may be the only unique identifier, however. N/A N/A
N/A workitem workitem/workItem/uniqueId WorkItem WorkItem uniqueId ODS TASK EXTERNAL_ID Operational Data Store/Task Area Task External ID An MD5 hash of the URI for this element. N/A N/A
N/A workitem workitem/workItem/modified WorkItem WorkItem modified ODS TASK REC_DATETIME Operational Data Store/Task Area Task Last Updated The timestamp of the last modification date of this resource N/A N/A
N/A N/A N/A N/A N/A N/A ODS TASK ISSOFTDELETED Operational Data Store/Task Area Task Is Deleted A boolean indicating whether or not the resource is "archived". Archived resources are typically hidden from the UI and filtered out of queries. N/A N/A
N/A workitem workitem/workItem/id WorkItem WorkItem id ODS TASK EXTERNAL_KEY1 Operational Data Store/Task Area Task External Key1 The system-generated id number for the work item (e.g. "123") N/A N/A
Resolution Date workitem workitem/workItem/resolutionDate WorkItem WorkItem resolutionDate ODS TASK_DETAIL ACTUAL_FINISH Operational Data Store/Task Area Task Detail Actual Finish The date and time when the work item was resolved, or null if the work item has not been resolved N/A N/A
Time Spent workitem workitem/workItem/timeSpent WorkItem WorkItem timeSpent ODS TASK_DETAIL ACTUAL_WORK Operational Data Store/Task Area Task Detail Actual Work How much time has actually been spent so far on the work item N/A N/A
Correction workitem workitem/workItem/correctedEstimate WorkItem WorkItem correctedEstimate ODS TASK_DETAIL PLANNED_WORK Operational Data Store/Task Area Task Detail Planned Work The corrected estimate for the work item, in the case that the user has corrected the estimate N/A N/A
Owned By workitem workitem/workItem/owner/uniqueId WorkItem WorkItem ownerUniqueId ODS TASK OWNER_ID Operational Data Store/Task Area Task Owner ID The contributor who owns the work item N/A N/A
Project Area workitem workitem/workItem/projectArea/itemId WorkItem WorkItem projectAreaItemId ODS TASK PROJECT_ID Operational Data Store/Task Area Task Project ID The project area to which the work item belongs N/A N/A
Planned For workitem workitem/workItem/target/itemId WorkItem WorkItem targetItemId ODS TASK ITERATION_ID Operational Data Store/Task Area Task Iteration ID The iteration that the work item is "Planned For" N/A N/A
N/A workitem workitem/workItem/href WorkItem WorkItem href ODS TASK URL Operational Data Store/Task Area Task URL The URI of this element N/A N/A

Feedback