It's all about the answers!

Ask a question

query state name in itemHistory of the RTC reportable rest api


Binoy D'costa (9531732) | 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.4k314) | 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.