database table to get attachment details linked to a work item

Rashmi B (19●1●26) | 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

Most liked answers ↑|Newest answers|Oldest answers

permanent link

Kenji Sarai (960●2●9) | 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

It's all about the answers!

Related questions

database table to get attachment details linked to a work item

One answer

Your answer