BIRT reports: Getting hold of latest records from dataset
![]()
Hi All,
I have a requirement to collect the data and build a report from a dataset which stores running data over timestamp. Am using Jazz data sources for building report to depict user assignment details. For Eg., if user abc is allocated to two projects proj1 (50%) and proj2 (50%); It will have two entries made in COMMON_SNAPSHOT.CONTRIBUTOR_ASSIGNMENT table for these two projects. If a user's assignment percentage to above mentioned project changed on user editor UI, say proj1 (55%) and proj2 (45%), two new entries will be made in the table along with the timestamp for this change made on the UI. I would need to get only the latest assignment details from the dataset. Did not find any control point on the dataset builder which address the same. any pointer in this direction would be of great help. Many thanks in advance. Thanks & Regards, Mohan. |
3 answers
![]()
Please see http://jazz.net/forums/viewtopic.php?t=10267
|
![]() Please see http://jazz.net/forums/viewtopic.php?t=10267 Hi Rafik, Thanks for the reply. Observed that LIVE_CONTRIBUTOR_ASSIGNMENT table remains empty always. Requesting you to let me know any other place I get these details pulled out from. Thanks & Regards, Mohan. |
![]()
LIVE_CONTRIBUTOR_ASSIGNMENT is a computed table which is not backed by a real database table. Because of that it is not as flexible as the other tables. Currently the table will require you to pass a non-empty list of the contributor item ids for whom you want to fetch the assignment data.
|
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.