Filtering RTC Custom Attributes from REST API
Hi there!
I've a Rational Insight report that displays weekly workitem data. We've a huge data volume, so the ETL process takes a high amount of time. That's not a problem importing Workitem information, so I can filter through 'MODIFIED' field and retrieve only the elements I need, but I can't do the same with the Custom Attributes information (WORKITEM_CCM.CustomAttrs), because the only relational information it has is the workitem itemId, and it hasn't any time or data information to guess which time it was modified.
As a workaround, I can get the recently modified workitems and I get their 'itemId' field. Then, I build (manually) a SQL sentence with 'or' clauses to retrieve the associated custom attributes, because REST API doesn't support the SQL 'in' clause. Alas, that's can't be automatized on Data Manager, so I'd like to know if there is some way to retrieve a set of custom attributes which have been modified from a given date.
Any help will be appreciated. Thank you so much.
Daniel.
Accepted answer
https://<server:port>/ccm/rpt/repository/workitem?size=10&fields=workitem/workItem[projectArea/archived=false]/(allExtensions/(key|type|booleanValue|decimalValue|doubleValue|integerValue|longValue|timestampValue|smallStringValue|mediumStringValue|largeStringValue)|projectArea/archived|itemId)&modifiedsince=2012-11-20T19:10:53.000-0500
I realize this is not strictly what you need but it should be easier than your current workaround.
Note that not all custom attribute types are currently supported via the REST API but RFE 184675 is open to track this:
https://jazz.net/jazz/web/projects/Rational%20Team%20Concert#action=com.ibm.team.workitem.viewWorkItem&id=184675