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 |
2 answers
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 |
I'm looking for the same thing as Juergen. Anyone know how to get hold of the absence summary text from a BIRT report? 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 |
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.