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.
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.