LIVE SNAPSHOT PLANNED SNAPSHOT TABLES
Snapshot - LIVE_SNAPSHOT
Table - com.ibm.team.apt.snapshot.PlanSnapshot
com.ibm.team.apt.plansnapshot.BaselineMember
com.ibm.team.apt.plansnapshot.EstimateRollUp
com.ibm.team.apt.plansnapshot.PlanSnapshotType
com.ibm.team.apt.plansnapshot.ProcessItemBaselineMember
com.ibm.team.apt.plansnapshot.SizeRollUp
com.ibm.team.apt.snapshot.PlanSnapshot
What information do each of the tables contain.I am building a report to perform a comparison between 2 Snapshots. What is the difference between estimate roll up and Size rollup ?
One answer
Mridula, tables exposed to BIRT through the schema named LIVE_SNAPSHOT expose the internal structure of the data persisted in the RTC repository and are not guaranteed to be there in the future. I would recommend not using those. if you really have to, I doubt you will get any help about the meaning of those as those are not public API.
Comments
Rafik, it's good to warn us that LIVE_SNAPSHOT tables are not guaranteed to be there in the future, but to future-proof BIRT reports, I need to be able to do the following:
- Extract custom attributes of an "item" type such as Iteration, Release or another work item. I currently use com.ibm.team.workitem.WorkItem for this
- Determine the item Id of a Release from its name and project area, so I can extract work items with a custom attribute with that Release name. I currently use com.ibm.team.workitem.Deliverable for this
If there are an alternative tables I can use to achieve these effects, could you please direct me to them