Using data history

Keep track of all changes within RentMagic to keep your records complete at all times.

By using data history, it is possible to save data from important tables within RentMagic and search back for the data or information if needed. You can use data history to look back for changes at a later time, but also if you accidentally deleted something. Looking back at price changes, old addresses or contacts, it's all possible.

The data history is found throughout RentMagic and can be used as a reference, and it is not possible to restore data from an earlier moment. The information is read-only.

Tables with data history enabled can be recognised by the following icon:

Data history in overviews

If data history is enabled for the table, it is possible to view it.

To access the data history of the table:

  • In the title bar at the top right, click on the data history icon.

All new, updated and deleted information is made visible in the overview by record.
  • Use the search filter to search for a specific record or value using a keyword.
  • Double-click the found record to open the details of the data history.

The details of the data history will open. You can find more information about this below in section data history in details.

Search filter overviews

The data history within a view is often too large and cluttered to browse. It is then necessary to use the search filter to find the correct record. 

The filters that are used are:

  • Type: What type of mutation occurred for the record.
    • All: All records, namely existing and deleted records.
    • Existing: A summary of the existing records, which are the records that have not been deleted.
    • Deleted: An overview of the deleted records. If a record has been completely deleted you will find it in the overview if this filter is selected.
  • Search: Enter free search words to refine the overview of records.

Field information

  • Entity: The table on which the change (or deletion) occurred, in combination with the primary key.
  • Sequence number: After a change or deletion has taken place, a sort of version number is kept which can be viewed to determine the sequence by the user.
  • Deleted: If this field is enabled it concerns a deletion of the record. The record will no longer appear in the current overview.
  • Last modified on: When the change or deletion has taken place.
  • Last modified by: The user who made the change.

Data history in details

From a details form it is possible to open the data history. Specifically, you then open the summary of changes and updates that have taken place on the record.

To open the data history of the record:

  • In the title bar at the top right, click on the data history icon.
The overview of the data history of the corresponding record opens.
  • Use the search filter to search specifically for a particular change using a keyword.

The details can only be accessed read-only.

Search filters details

Data history is often already large in environments that have been used for some time. It is then necessary to use filters to look up the right information.

The filters used are:

  • Period from and to: here you can search the changes between a certain period.
  • Mutation type: which mutation type you want to search for specifically
    • All: All mutation types.
    • Current value: To see the current values of the record.
    • New: All values entered when the record was new.
    • Altered: All the values that involved a change/adjustment.
    • Deleted: The values of the record at the time it was deleted.
    • Linked: If the value is linked to the record from a related table.
    • Unlinked: If the value from a related table has been unlinked (removed) from the record.
  • Changed field: An overview of all fields contained in the record. This makes it possible to easily show an overview of all changes in one field.
  • Search: free keyword input to further refine the overview of the data history.

Export to Excel

It is possible to easily export the mutation list to Excel.

To make an export to Excel:

  • Set up your filter appropriately.
  • In the action bar, click Export to Excel.
The information will be exported to an Excel file. Within your browser, the file will be downloaded.
  • Double-click the file within your internet browser to open the file (provided you have Excel installed).

The first two columns in the file are keys to the changes. You can ignore these.

Field information

  • Last modified on: When the mutation occurred.
  • Changed by: The user who made the mutation.
  • Mutation type: The mutation type. For more information see search filter information above.
  • Changed field: Which field in the mutation has been modified.
  • Old value: The value of the field before the mutation. If the value is empty it means that the value for the mutation was not entered.
  • New value: The value of the field after the mutation has taken place.