database table to get attachment details linked to a work item
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
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
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