BIRT WorkItem & Attachments
I'm looking for a way to get the work item summary AND for each WorkItem a list of its attachments.
I tried to join in LIVE_SNAPSHOT the following class: com.ibm.team.workitem.Attachment AND com.ibm.team.workitem.WorkItem but unfortunately I didn't found any join. TipS? HintS? |
7 answers
I'm looking for a way to get the work item summary AND for each WorkItem a list of its attachments. I'm still looking to solve this problem cause we'll use attachemnts as deliverables of a Work Item so it is fundamentals to obtain a report on that. I try also to explore the internal database ... i cannot realize how the two entities (Work Item and Attachment ) are connected each other. Is there someone who have a tips on this? Thanks a lot in advance. |
Attachments are stored as blobs. How do you intend to expose that data to BIRT? Will you write special parsers for the data? Have you considered using Custom Work Item Attributes instead? Work Item attachments are not intended to be used as a Work Item extension mechanism.
|
Attachments are stored as blobs. How do you intend to expose that data to BIRT? Will you write special parsers for the data? Have you considered using Custom Work Item Attributes instead? Work Item attachments are not intended to be used as a Work Item extension mechanism. No.. what i rellay want is a report that for each Work Item makes a list of its attachments, just the file name. The problem is that I can't find a way to join the WorkItem and the attachment table. Theese are the table schema i supposed to be involved: Attachments itemId contextId modified stateId id name creationDate liveRecordCount modifiedBy.* content.internalId content.* content.contentType content.checksum content.liveRecordCount creator.itemId creator.contextId creator.modified creator.stateId creator.emailAddress creator.userId creator.name creator.archived creator.liveRecordCount projectArea.itemId projectArea.contextId projectArea.modified projectArea.stateId projectArea.archived projectArea.name projectArea.uniqueName projectArea.isInitialized projectArea.internalPublic projectArea.liveRecordCount Work Item itemId contextId modified stateId id internalState internalResolution resolutionDate summary internalSeverity creationDate internalPriority dueDate internalTags workItemType duration timeSpent internalSequenceValue correctedEstimate startDate liveRecordCount modifiedBy.* creator.* owner.* .. many many other Thanks a lot in advance for any help |
The LIVE_SNAPSHOT schema exposes only the raw queryable (indexed) data. Any missing fields means that those are not indexed. This behavior is by design.
|
The LIVE_SNAPSHOT schema exposes only the raw queryable (indexed) data. Any missing fields means that those are not indexed. This behavior is by design. Are you sure ? I connected directly to the derby DB and i saw in MODEL schema that the fields i've listed are the same fields in the database schema. BTW this isn't the problem's core! I'm still looking a way to JOIN Attachments and work Item. This is a sample of the report i try to create: Work Item summary 1 - filename1.doc - filename2.xls - filename2.doc Work Item summary 2 - filename3.doc - filename4.doc - filename5.xls etc... |
The LIVE_SNAPSHOT schema is a logical schema that exposes a subset of the repository database to BIRT. The field in the Work Item object that links to the attachment objects is not exposed.
|
The LIVE_SNAPSHOT schema is a logical schema that exposes a subset of the repository database to BIRT. The field in the Work Item object that links to the attachment objects is not exposed. fine! BUT also in the DB i cannot find a way to join the two entity ... (i use a Derby Client to connect to Database) Do you know something more about that? |
Your answer
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.