It's all about the answers!

Ask a question

database table to get attachment details linked to a work item


Rashmi B (19426) | asked Jan 04 '17, 3:44 p.m.
 Hello,

I am trying to create a query from database to get the list of work items/requests which has attachments.
I know that all the request information starts from RIODS.REQUEST table. However not sure where the attachment information will be stored.
I am just looking get the numbers around what items have attachments. not extracting the attachments.

I am using RTC 5.0.2

Thanks,
Rashmi

One answer



permanent link
Kenji Sarai (96029) | answered Jan 04 '17, 8:07 p.m.
Hi Rashmi,

Given that you are referring to RIODS.REQUEST, I assume you are creating a query for data warehouse. Unfortunately REST API for RTC does not have a capability to upload attachments. See
https://jazz.net/forum/questions/209067/rest-api-for-attachments-of-a-workitem

You might consider using OSLC.
https://jazz.net/wiki/bin/view/Main/WorkItemAPIsForOSLCCM20
https://jazz.net/forum/questions/179513/how-to-download-an-attachment-through-oslc-in-rtc

Your answer


Register or to post 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.