It's all about the answers!

Ask a question

query state name in itemHistory of the RTC reportable rest api


Binoy D'costa (9532537) | asked Jul 29 '15, 10:31 a.m.
I have rtc reportable query like:

https://clmserver/jazz/rpt/repository/workitem?fields=workitem/workItem[id='90866']/(id|itemHistory/(state/name|modified|modifiedBy/(emailAddress)))

which returns:

 <itemHistory>
<stateId>
_HvhuYTVYEeWOJffyorECrg
</stateId>
<predecessor>
_G7CWYDVYEeWOJffyorECrg
</predecessor>
<state>
<name>
Resolved
</name>
</state>
<modified>
2015-07-28T14:40:29.766-0400
</modified>
<modifiedBy>
<emailAddress>
Binoy.Dcosta@ipc.com
</emailAddress>
</modifiedBy>
 </itemHistory>
 <itemHistory>
<stateId>
_xtwzMWtrEeSNxt9jLfJlpA
</stateId>
<predecessor>
_68hJcB5WEeSzreHcp5MPKA
</predecessor>
<state>
<name>
Assigned
</name>
</state>
<modified>
2014-11-13T14:32:16.995-0500
</modified>
<modifiedBy>
<emailAddress>
Binoy.Dcosta@ipc.com
</emailAddress>
</modifiedBy>
 </itemHistory>


How do I query to return only state name equal to "Resolved"?

Thanks,
Binoy


One answer



permanent link
Donald Nong (14.5k414) | answered Jul 30 '15, 12:09 a.m.
https://clmserver/jazz/rpt/repository/workitem?fields=workitem/workItem[id='90866']/(id|itemHistory[state/name='Resolved']/(state/name|modified|modifiedBy/(emailAddress)))

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.