Work Item

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
Work Item 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
Work Item N/A workitem workitem/workItem/itemId WorkItem WorkItem itemId ODS REQUEST EXTERNAL_KEY2 Operational Data Store/Request Area Request 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
Work Item N/A workitem workitem/workItem/uniqueId WorkItem WorkItem uniqueId ODS REQUEST EXTERNAL_ID Operational Data Store/Request Area Request External ID An MD5 hash of the URI for this element. N/A N/A
Work Item N/A workitem workitem/workItem/modified WorkItem WorkItem modified ODS REQUEST REC_DATETIME Operational Data Store/Request Area Request Last Updated The timestamp of the last modification date of this resource N/A N/A
Work Item N/A N/A N/A N/A N/A N/A ODS REQUEST ISSOFTDELETED Operational Data Store/Request Area Request 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
Work Item N/A workitem workitem/workItem/id WorkItem WorkItem id ODS REQUEST EXTERNAL_KEY1 Operational Data Store/Request Area Request External Key1 The system-generated id number for the work item (e.g. "123") N/A N/A
Work Item Resolution Date workitem workitem/workItem/resolutionDate WorkItem WorkItem resolutionDate ODS REQUEST RESOLVED_DATE Operational Data Store/Request Area Request Resolved Date The date and time when the work item was resolved, or null if the work item has not been resolved N/A N/A
Work Item Summary workitem workitem/workItem/summary WorkItem WorkItem summary ODS REQUEST SUMMARY Operational Data Store/Request Area Request Summary The one-line summary (or title) of the work item N/A N/A
Work Item Creation Date workitem workitem/workItem/creationDate WorkItem WorkItem creationDate ODS REQUEST CREATION_DATE Operational Data Store/Request Area Request Creation Date The date and time when the work item was created N/A N/A
Work Item Due Date workitem workitem/workItem/dueDate WorkItem WorkItem dueDate ODS REQUEST DUE_DATE Operational Data Store/Request Area Request Due Date The date and time when the work item is scheduled for completion, or null if no due date has been specified N/A N/A
Work Item Description workitem workitem/workItem/description WorkItem WorkItem description N/A N/A N/A N/A N/A N/A The description of the work item N/A N/A
Work Item N/A workitem workitem/workItem/workflowSurrogate WorkItem WorkItem workflowSurrogate N/A N/A N/A N/A N/A N/A The associated workflow N/A N/A
Work Item Tags workitem workitem/workItem/tags WorkItem WorkItem tags ODS REQUEST TAGS Operational Data Store/Request Area Request Tags The tags attached to the work item. In the case of multiple tags, this single string contains a comma-separated list of tags N/A N/A
Work Item Estimate workitem workitem/workItem/duration WorkItem WorkItem duration ODS REQUEST PLANNED_WORK Operational Data Store/Request Area Request Planned Work The estimate specified for the work item, indicated the estimated time to complete the work item. In the UI, this is called "Estimate" rather than duration. N/A N/A
Work Item Time Spent workitem workitem/workItem/timeSpent WorkItem WorkItem timeSpent ODS REQUEST ACTUAL_WORK Operational Data Store/Request Area Request Actual Work How much time has actually been spent so far on the work item N/A N/A
Work Item Correction workitem workitem/workItem/correctedEstimate WorkItem WorkItem correctedEstimate ODS REQUEST PLANNED_WORK Operational Data Store/Request Area Request Planned Work The corrected estimate for the work item, in the case that the user has corrected the estimate N/A N/A
Work Item N/A workitem workitem/workItem/dayModified WorkItem WorkItem dayModified N/A N/A N/A N/A N/A N/A The day on which the work item was last modified N/A N/A
Work Item Created By workitem workitem/workItem/creator/uniqueId WorkItem WorkItem creatorUniqueId ODS REQUEST CREATOR_ID Operational Data Store/Request Area Request Creator Id The contributor who created the work item N/A N/A
Work Item Owned By workitem workitem/workItem/owner/uniqueId WorkItem WorkItem ownerUniqueId ODS REQUEST OWNER_ID Operational Data Store/Request Area Request Owner ID The contributor who owns the work item N/A N/A
Work Item Filed Against workitem workitem/workItem/category/itemId WorkItem WorkItem categoryItemId ODS REQUEST REQUEST_CATEGORY_ID Operational Data Store/Request Area Request Category ID The category to which the work item is assigned. In the UI, this is called "Filed Against". N/A N/A
Work Item Discussion (# comments) workitem workitem/workItem/commentCount WorkItem WorkItem commentCount ODS REQUEST COMMENT_COUNT Operational Data Store/Request Area Request Comment Count A collection of zero or more comments appended to the work item N/A N/A
Work Item N/A workitem workitem/workItem/customAttributes N/A N/A N/A N/A N/A N/A N/A N/A N/A A collection of zero or more "custom attributes" attached to the work item. These are user-defined attributes (as opposed to the built-in attributes elsewhere in this list). N/A N/A
Work Item Subscribers workitem workitem/workItem/subscriberCount WorkItem WorkItem subscriberCount ODS REQUEST SUBSCRIBER_COUNT Operational Data Store/Request Area Request Subscriber Count A collection of zero or more Contributors who are subscribed to the work item N/A N/A
Work Item Project Area workitem workitem/workItem/projectArea/itemId WorkItem WorkItem projectAreaItemId ODS REQUEST PROJECT_ID Operational Data Store/Request Area Request Project ID The project area to which the work item belongs N/A N/A
Work Item Resolved By workitem workitem/workItem/resolver/uniqueId WorkItem WorkItem resolverUniqueId ODS REQUEST RESOLVER_ID Operational Data Store/Request Area Request Resolver ID The Contributor who resolved the work item, or null if the work item has not been resolved N/A N/A
Work Item Approvals workitem workitem/workItem/approvals N/A N/A N/A N/A N/A N/A N/A N/A N/A A collection of zero or more Approvals attached to the work item N/A N/A
Work Item Approvals workitem workitem/workItem/approvalDescriptors N/A N/A N/A N/A N/A N/A N/A N/A N/A A collection of zero or more Approval Descriptors attached to the work item N/A N/A
Work Item Planned For workitem workitem/workItem/target/itemId WorkItem WorkItem targetItemId ODS REQUEST ITERATION_ID Operational Data Store/Request Area Request Iteration ID The iteration that the work item is "Planned For" N/A N/A
Work Item Found In workitem workitem/workItem/foundIn/itemId WorkItem WorkItem foundInItemId ODS REQUEST RELEASE_ID Operational Data Store/Request Area Request Found In Release ID The deliverable that the work item is "Found In" N/A N/A
Work Item History workitem workitem/workItem/itemHistory N/A N/A N/A N/A N/A N/A N/A N/A N/A A collection of zero or more WorkItem elements, representing the entire history of the work item. Each state the work item has ever been in is reflected in this history list. N/A N/A
Work Item Team Area workitem workitem/workItem/teamArea/itemId WorkItem WorkItem teamAreaItemId ODS REQUEST TEAM_ID Operational Data Store/Request Area Request Team ID The team area to which the work item belongs N/A N/A
Work Item Status workitem workitem/workItem/state/id WorkItem WorkItem stateId ODS REQUEST REQUEST_STATE_ID Operational Data Store/Request Area Request Request State ID The states are user-defined as part of the project area process. N/A N/A
Work Item N/A workitem workitem/workItem/resolution/id WorkItem WorkItem resolutionId ODS REQUEST REQUEST_RESOLUTION_ID Operational Data Store/Request Area Request Request Resolution ID The resolutions are user-defined as part of the project area process. N/A N/A
Work Item Type workitem workitem/workItem/type/id WorkItem WorkItem typeId ODS REQUEST REQUEST_TYPE_ID Operational Data Store/Request Area Request Request Type ID The work item types are user-defined as part of the project area process. N/A N/A
Work Item Severity workitem workitem/workItem/severity/id WorkItem WorkItem severityId ODS REQUEST REQUEST_SEVERITY_ID Operational Data Store/Request Area Request Request Severity ID The work item severities are user-defined as part of the project area process. N/A N/A
Work Item Priority workitem workitem/workItem/priority/id WorkItem WorkItem priorityId ODS REQUEST REQUEST_PRIORITY_ID Operational Data Store/Request Area Request Request Priority ID The work item priorities are user-defined as part of the project area process. N/A N/A
Work Item Parent workitem workitem/workItem/parent/itemId WorkItem WorkItem parentItemId N/A N/A N/A N/A N/A N/A The parent work item of this work item, if one exists N/A N/A
Work Item Children workitem workitem/workItem/children N/A N/A N/A N/A N/A N/A N/A N/A N/A A collection of zero or more child work items N/A N/A
Work Item Blocks workitem workitem/workItem/blocks N/A N/A N/A N/A N/A N/A N/A N/A N/A A collection of zero or more work items which this work item blocks N/A N/A
Work Item Depends On workitem workitem/workItem/dependsOn N/A N/A N/A N/A N/A N/A N/A N/A N/A A collection of zero or more work items which block this work item N/A N/A
Work Item Duplicated By workitem workitem/workItem/duplicatedBy N/A N/A N/A N/A N/A N/A N/A N/A N/A A collection of zero or more work items which are closed as duplicates of this work item N/A N/A
Work Item Duplicate Of workitem workitem/workItem/duplicateOf N/A N/A N/A N/A N/A N/A N/A N/A N/A A collection of zero or more work items which this work item is a duplicate of N/A N/A
Work Item Mentions workitem workitem/workItem/related N/A N/A N/A N/A N/A N/A N/A N/A N/A A collection of zero of more work items which this work item is related to N/A N/A
Work Item N/A workitem workitem/workItem/href WorkItem WorkItem href ODS REQUEST URL Operational Data Store/Request Area Request URL The URI of this element N/A N/A

Feedback