Optimize and improve content history

Issue

People

Delivery

Issue

People

Delivery

Description

Display relations and arrays

Show changes of relations and arrays on the content history show page.

Optimize storage of arrays

Array objects are taking too much space now, because the complete old and new array are stored. Only store the changes. For the “relation” array also store the relationId for context. Context for other arrays will not be supported any more.

Clean command

Create a command to clean a value from the content history. Also optimize the current history with the other changes in this issue.

Still unchanged documents in content history

Background

In INTEGRATED‌-1331 changes have been made to avoid storing content history changes for null values for new variables. However, this is still a problem.

Requirements

Empty values
- Values that are not set, are set with "null", so this problem is not present for the first level. This does however not work for values with multiple levels, so this check should be recursive.

// collection: content_history
{
	"_id" : "4dffab413a57354c88f91933e25e1507",
	"contentId" : "3907af99b3003b3c922989e076c59bd6",
	"contentType" : "company",
	"contentClass" : "Zkn\\Bundle\\ContentBundle\\Document\\Relation\\Company",
	"action" : "update",
	"date" : ISODate("2018-11-15T15:32:03.485+01:00"),
	"changeSet" : {
		"phonenumbers" : [
			[
				{
					"number" : "0612345678"
				}
			],
			[
				{
					"type" : null,
					"number" : "0612345678"
				}
			]
		],
		"address" : [
			{
				"street" : "Straat",
				"houseNumber" : "13",
				"zipCode" : "1000AB"
			},
			{
				"street" : "Straat",
				"houseNumber" : "13",
				"houseNumberAddition" : null,
				"zipCode" : "1000AB"
			}
		]
	}
}