Getting hold of latest records from dataset which stores running data over timestamp

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 the table for these two projects. I have a UI wherein user's assignment % can be changed; if a user's assignment percentage to above mentioned project change, 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.

Find more posts tagged with

Comments

Hans_vd

Hi Mohan,

You should do this in the query.
If you show me the query that is in your datasource and tell me what database you have, I can help you with that if needed.

mmksri76

Hi Hans_vd,
Thanks for the reply. Am using the JAZZ Data Source, wherein it displays the list of predefined snapshots and I do not have a provision to enter my custom query in this case.

Thanks,
Mohan