Commit History Viewer doesn't show parameter or object/relationship data

[DillonJ]

It seems like the commit history viewer only shows values that have changed, it doesn't show:

• If the value is new or updated
• What the old value was if relevant
• What the parameter is
• Any of the related entities

Not sure if this was the intended design, but it would be hugely useful if more information could be shown

[manuelma]

This is a known weakness of the current DB schema and I don't think we can do anything by 0.7.

The thing is, every time we modify a record we lose all the previous history by design. This is because the record is just updated in the db together with the new commit id. For this reason, the commit history viewer cannot find the records for previous commits - they're just gone.

Similar when we remove a record.

To be able to show a history, we should add new records with new commits instead of updating existing ones. But this means the tables have the potential to grow very large and we'd need to do something about that as well... There are some plans to handle this in the current proposal for DB schema changes.