and I received this output http://pastebin.com/2LFvjNig 

Ankur,

Thanks for taking a look at this.  If I execute your query, I get the results you posted.  But if I try the same query and substitute my developmentLine itemId, I get an empty result set:

https://hub.jazz.net/ccm01/rpt/repository/apt?fields=apt/workResourceDetails[developmentLine/itemId=('_Z02pYMPGEeKBWfwHYCvlmQ']/(|contributor/|contributor/workDays/|contributor/absences/)

Here's the developmentLine info:

<developmentLine>
<uniqueId>36cbc72ec8426bf303c215070d515e1a</uniqueId>
<stateId>_Z7ZwwA0ZEeOJOKWTvTaZZg</stateId>
<itemId>_Z02pYMPGEeKBWfwHYCvlmQ</itemId>
<contextId>_Zv4Cx8PGEeKBWfwHYCvlmQ</contextId>
<modified>2013-08-25T00:00:51.660+0000</modified>
<name>Main Development</name>
<archived>false</archived>
</developmentLine>

 I am not a member of your project area so can not see the data related to it. Is it a public project area? Can you give me some access to it for few days which we can remove later once this is sorted out?

Ankur,

I'm going to see if I can repro this on a test private project.  If I can't, then we can temporarily add you.  I'll work on it this afternoon.

Thanks for you help with this!

- Andre

Ankur,

Apologies for not getting back to you the other day-- stuff came up.

I was able to repro with a test private project.  Can I get your email address so that I can add you to the project?

- Andre

fields=apt/contributor/(name|assignments/*)  will actually return the combined implicit and explicit assignments. But the call can be expensive as it has the examine data like: team area membership combined with the explicit assignments, etc...

This is inline with what I found here as well. Once I went and generated some explicit data, I was able to get results with the requests you provided. If you run them again, you will see there is some data coming back now as I put in some work allocations for myself.

One issue we might need to address (or think about addressing) here is that the ccm user profile is not really exposed on JazzHub. It is not clear where users would go to input this information due to the changes we have made to the banner and navigation structure.

Is the work allocation breakdown something that's important to you?

Thanks guys for the suggestions.  My goal is to try to get all the assignments, absences, and work day info for everyone assigned to a particular project so that I can create reports and such.

The reason I'm going from apt/workResourceDetails/ is try and get all of that info with 1 call-- in the original call I posted, you can see I'm filtering on the developmentLine/itemId, and requesting that info:

https://hub.jazz.net/ccm01/rpt/repository/apt?fields=apt/workResourceDetails[developmentLine/itemId='_J9woAfOhEeKmUe8rNxZggQ']/(|contributor/|contributor/workDays/|contributor/absences/*)

What is strange is that Ankur discovered that while that call doesn't work for private projects, it does work for public projects (see his example above that works).

I could start from apt/contributor, but in that case, I'd need to make multiple calls to get each contributor.

Starting from apt/contributor, you can't filter on a developmentLine/itemId.  Ex:

https://hub.jazz.net/ccm01/rpt/repository/apt?fields=apt/contributor[assignments/developmentLine/itemId='_J9woAfOhEeKmUe8rNxZggQ']/(|assignments/|assignments/projectArea/|assignments/developmentLine/|workDays/|absences/)

Error 500: CRRED0135E: Illegal filter. The field 'apt/assignments/developmentLine/itemId' may not be used in a filter because it returns multiple values.

So, bottom line, it seems like there's a difference between how public and private projects behave.  If that's something that can be addressed, that'd make the query easier (and probably use less server resources too, I'd imagine).  If not, then the only way I can see to get the data is with a number of calls via apt/contributor.

Any thoughts / ideas?

Thanks,

Andre

Hi Andre. I am not sure what tool you are using to collect the data. But you could create one query to fetch all the members of a project area. Then iterate over each member and find their assignments. A tool like RPE makes it easy to write such reports and can even let you filter on the data just in case some of those filters cannot be expressed in a single URL.