CiviCRM Community Forums (archive)

I want to place some custom data items on a relationship to report on through views - all this works nicely, but the users may want to track changes in those data over time.

It is not possible to place a repeating group into a relationship as it is on a contact record - so I can't have them create a new record every time they want to change the figures (and besides it is a real nightmare to limit the dataset to the last updated record in views).

Is looking at revision history an alternative means to presenting them with a history of changes to that relationship's data? Can I get to it?

I could also use cron to periodically export the data from the drupal view and then collate those into one file, but that seems a really messy way of doing it.

The report could be through views or otherwise

Have you looked into detailed logging? Turning it on will enable you to collect the info you want (and a lot lot more)

http://book.civicrm.org/user/current/advanced-configuration/logging/