It's all about the answers!

Ask a question

Get items modified by a specific user after a certain date with EWM Reportable REST API

Patrick Sepp (111) | asked Dec 05 '23, 9:53 a.m.


Im trying to get all items in our project, that have been modified by a set user after a certain date.

For example, I want all items that I modified after this date 01.November.2023:
ccm/rpt/repository/workitem?fields=workitem/workItem[modified>2023-11-01T10:00:00.000%2b0200 and modifiedBy/name=PATRICK]/(id|summary)
 the problem is this will only return an item if the last change was by me, not if i modified the item on the 02.November.2023 but someone else modified the item a day later.

So I tried again using the itemHistory:
This only returns repeating <workItems/> without an id or a summary.

The wiki unfortunately was no help to me, can anyone help me out please? I cant provide images since you need 60 reputation points to do that.
We use EWM 7.0.2 SR1

Best regards

One answer

permanent link
Ralph Schoon (63.1k33646) | answered Dec 06 '23, 2:30 a.m.
edited Dec 06 '23, 2:31 a.m.

 The behavior of the API indicates that you have an issue with the URL or specification what information to return. Things to look at would be URL encoding.

It is important to understand the structure of the query that specifies what information is returned how. In your 2nd example you have a slash / instead of a pipe | in (id/summary) The slash indicates summary should be a nested property of ID, which is not correct.

I tried to summarize my experience with the EWM Reportable REST API here:   

Patrick Sepp commented Dec 06 '23, 3:23 a.m. | edited Dec 06 '23, 4:17 a.m.

 Hi Ralph,

thanks for the fast answer, I replaced the / with a pipe, must have overseen that, unfortunately that isnt the problem I still get the same reply like this:

Ralph Schoon commented Dec 06 '23, 4:18 a.m. | edited Dec 06 '23, 4:34 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER[id=1 or id=2]/(id|summary) or[id=1 or id=2]/(*) get the data and display what you are interested in and then you work on the filter?

Patrick Sepp commented Dec 06 '23, 4:46 a.m. | edited Dec 06 '23, 4:48 a.m.

Ok your example worked flawlessly.

Then Itried doing this filter, that worked and displayed all data as intended.

As soon as I add a filter for the itemHistory, no matter which one, I get the same reply as in my last comment containing only <workitems/>.

This seems like a bug to be honest. 

Ralph Schoon commented Dec 06 '23, 5:14 a.m. | edited Dec 06 '23, 5:21 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER[id=1]/(itemHistory/(*)) shows the item history for me. With the filter, consider URL encoding and the like.


Ralph Schoon commented Dec 06 '23, 5:25 a.m.

 Note that the itemHistory is the history states of the work item. The filter only selects the set of work items. This set of work items is then used and the history for each item is displayed.

Ralph Schoon commented Dec 06 '23, 6:43 a.m.
showing 5 of 6 show 1 more comments

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.