Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

How to access absence summary text for reports

Hello,

Our team looked for a way to get an overview of absence times of the whole team. Therefore, I'm currently writing a report to list absence times of all team members.
How do I get the summary text that team members entered with every absence? The CONTRIBUTOR_ABSENCE of the APT_SNAPSHOT contains contributor information (id, user id, name, etc.) as well as start and end dates, but the summary text is missing. Same story with com.ibm.team.apt.resource.ContributorAbsence in the LIVE_SNAPSHOT.
I browsed through many other tables but did not find the absence summary text.
Is it possible to query the summary text of a scheduled absence entry?

I'm working with RTCz 2.0.0.2.

Thanks in advance!
Juergen

0 votes



2 answers

Permanent link
I'm looking for the same thing as Juergen. Anyone know how to get hold of the absence summary text from a BIRT report?

Thanks,
Mark

0 votes


Permanent link
I'm looking for the same thing as Juergen. Anyone know how to get hold of the absence summary text from a BIRT report?

Thanks,
Mark


Sorry, I missed the first post. It looks like you can't get that information. It's not included in our APT_SNAPSHOT (which we use mostly to calculate the sum of the absence times, not to report on individual absences), and I see a table com.ibm.team.apt.resource.ContributorAbsence in the LIVE_SNAPSHOT but it doesn't expose the description either.

If you open an enhancement request, we can consider this for a future release.

james
RTC Reports Team Lead

0 votes

Your answer

Register or log in 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.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details

Question asked: Jul 23 '10, 10:03 a.m.

Question was seen: 6,778 times

Last updated: Jul 23 '10, 10:03 a.m.

Confirmation Cancel Confirm