You can use this business rule to fetch more information of a work item from CLM system such as Rational® Team Concert.
=XPathValueFetcher('CALM link attribute',"URL parameters","XPath expression")
| Parameter | Description |
|---|---|
| CALM link attribute | The CALM link attribute that defines the link to a specific project area in a Jazz™ Team Server |
| URL parameters | The URL parameter to query the required work item information. |
| XPath expression | Specify the expression to navigate to the required element and the computation that needs to be done from the value that is retrieved. |
=XPathValueFetcher('Work Items', "/?oslc_cm.properties=rtc_cm%3Astate%7B*%7D", "//rtc_cm:state/dc:title[text()]", "State", "run_at=1")
=(XPathValueFetcher('Work Items',"/?oslc_cm.properties=rtc_cm%3AprogressTracking%7B*%7D","//oslc_pl:workCompleted[text()]","run_at=1")) / ( 1000*60*60 )
=(XPathValueFetcher('Work Items',"/?oslc_cm.properties=rtc_cm%3AprogressTracking%7B*%7D","//oslc_pl:effortRemaining[text()]","run_at=1")) / ( 1000*60*60 ) + 'Actual Effort'
=XPathValueFetcher('Requirements',"/ds:dataSource/ds:artifact/ds:collaboration/ds:attributes/attribute:objectType/attribute:customAttribute[@attribute:name='Status']/@attribute:literalName","/ds:dataSource/ds:artifact/ds:collaboration/ds:attributes/attribute:objectType/attribute:customAttribute[@attribute:name='Status']/@attribute:literalName, /ds:dataSource/ds:artifact/ds:collaboration/ds:attributes/attribute:objectType/attribute:customAttribute[@attribute:name='Difficulty']/@attribute:literalName","Status, Difficulty","update_interval=3")
=(XPathValueFetcher('Work Items',"/rtc_cm:com.ibm.team.workitem.linktype.parentworkitem.children/?oslc_cm.properties=rtc_cm:timeSpent","sum(//rtc_cm:timeSpent[text()])","run_at=1")) / ( 1000*60*60 )
=(XPathValueFetcher('Work Items',"/rtc_cm:com.ibm.team.workitem.linktype.parentworkitem.children/?oslc_cm.properties=rtc_cm:estimate","sum(//rtc_cm:estimate[text()])","run_at=1")) / ( 1000*60*60 )